Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kdnichols
Posting Yak Master
232 Posts |
 Posted - 2007-02-08 : 22:23:40
|
| Hello,I need to start learning SSIS. Has anyone found any good sites that explain it and that are free?Thanks,Kurt |
|
|
jhoge123
Starting Member
8 Posts |
Posted - 2007-02-09 : 13:08:57
|
| There's a good series of webcasts at LearnIntegrationServices.com that is cheap but not free. Appdev training has some videos but they're outrageously overpriced. John |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-09 : 15:37:54
|
| Best is to just try using it.Problem with most tutorials is that they tell you what's available rather than what's useful or advisable.Think of a scenario and try to implement it.Things that are usually missed are the performance of various taskshow to audit processeshow to make them flexible e.g. releasing to various environmentshow to release a packageIt's quite easy to start and create a package that does a few things.Just set one up to do a file copy.Then do a file importThen file exportthen import all files in a folder using a file mask.Add the filename to the import table and number of rows to an audit tablethen the same but making folder file mask, tables, databases, servers all configurable externally.Then log to a file configurable at run time.Now take two tables with different structure and transfer data from one to the other - doing datatype conversion and operating on columns.Now insert data that isn't in the second table and update data that is.Do it another wayAnd another - keep going and think about when you would use each type - remember to log what's happening.While doing the above use data views to see what is happening and to stop flows.Look at all the tasks available and think what they might do.That should give you a good grounding in the use of SSIS and the power of expressions and configurations and should only take a couple of days but will probably take a few weeks to be comfortable with it.Remember however much you use it you only know about things you have tried so always ask people if they know of a better way of doing things - show them what you are doing and ask for suggestions. Even if they don't have much experience they'll have a different view and you'l both benefit.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Any good places to learn SSIA free on the net?