Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

SQL Server Integration Services (SSIS) Basics - MSSQL 2008

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
103,730
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jul 27, 2009

http://sqlserver2008tutorial.com/sql-tutorials.html

We use SQL Server Integration Services (SSIS) to import data from an access database. Using enterprise edition of microsoft sql server 2008 and microsoft access 2000 database. We also connect to integration services using the sql server management studio (ssms). MSSQL 2008

Visit our other sites:

http://www.learningcomputer.com
http://www.sqlazuretutorials.com
http://learningsqlserver2008.com/
http://compare-insurance-car.com/insurance_coverage.html
http://www.mycar-insurance.net
http://datatechnologyllc.com/search-engine-optimization/Dallas-SEO.html

  • likes, 1 dislikes

Link to this comment:

Share to:

Uploader Comments (baghul)

  • Hi. I really like your presentation. Very good speaker and trainer. I am trying to get a handle of SSRS. How can get a hold of your series of similar videos such as these?

  • @MsUpandready Thank you for the nice comments. We have two sites with FREE samples. Also plz Subscribe

    sqlserver2008tutorial dot

    learningsqlserver2008 dot

  • How do you transfer at the same time transform data between tables where datatypes are also different?

  • @rezaurkhan Typically not a good idea to transform between data types. However sql will do implicit conversions like number to text etc.

  • Can I use SSIS to synchronize data bases in two different servers? that means once a table update in a database, other server same table should be updated at the same time. just like triggers

  • @nanjayarathne You could create a SSIS package and then run it in a job. For syncing, its better to use either Replication or DB Mirroring. We have a video on the second topic on Youtube. Kash

Video Responses

see all

All Comments (52)

Sign In or Sign Up now to post a comment!
  • @Nirmals44 Glad u liked. Thanks Man!

  • Very informative and is easily understandable... Good work dude...

  • @digi3e Awesome! Thx buddy. ;-)

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more