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 |
|
dajonx
Starting Member
6 Posts |
 Posted - 2008-04-11 : 15:49:55
|
| Hi,I was wondering if anyone know how to do Dynamic Properties Tasks in SSIS? And, does anyone know how to create a global database in SSIS so I won't have to change all of the database names in my package? I'm sorry, I'm new to SSIS and I'm just really frustrated. Thank you. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-12 : 05:10:33
|
| The equivalent in ssis would be a configuration.http://www.nigelrivett.net/DTS/SSISConfigurationFile.htmlhttp://www.nigelrivett.net/DTS/SSISIndirectConfiguration.htmlSSIS is a lot more powerful (and better implemented) than DTS. DOn't look for equivalents - treat it as a new product and redesign your system around it.==========================================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. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-12 : 05:17:36
|
quote:
Originally posted by nr DOn't look for equivalents - treat it as a new product and redesign your system around it.==========================================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.
Yup thats absolutely true. I've often heard of people comparing between the two though SSIS is a absolutely new product with new architecture and advanced features. |
|
|
|
|
|
|
Converting DTS to SSIS - 2 Questions