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 |
|
vasu4us
Posting Yak Master
102 Posts |
 Posted - 2007-04-25 : 17:56:28
|
| hi guys, i have little experience on DTS on 2000 and i have build and maintained small DB on 2000.now iam on to a project on SSIS 2005. I have no clue of how it looks like. i just want to know like where query analyzer, what all transformations or features the new release has.....coming to the point is there any web cast or tutorial online which can just walk me through or any good book.any info will help and thanks in adv |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-26 : 12:04:56
|
| There are tutorials in sql2k5 books online. |
 |
|
|
vasu4us
Posting Yak Master
102 Posts |
Posted - 2007-04-30 : 12:32:24
|
| I have completed that tutorial but i am not able to get the big picture, like creating a project, where and how to store projects and moving objects or packages, connectivities.....like i want to try running a package in a loop with multiple data sources say there are 4 data sourcesthat is as400, oracle, flat file and sql the package will compare data in warehouse to the source like date and time started, number of rows updated, number of rows failed...initially the package should work in loop for the 4 sources and lookup with warehouse next is the process should be automated for multiple sources so the the user can just update some table and with the new source and the package feature is extended to the new data source.guys i know this is too much to ask but i have enough time to research and do that... any help appreciatedmethod... webcast... ref booksThanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-30 : 12:44:26
|
| There are several books on SSIS, check amazon. |
|
|
|
|
|
|
support information and book