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 |
|
FYA
Starting Member
1 Post |
 Posted - 2008-01-18 : 13:13:10
|
| I've 50 databases with the same structure and I have 50 DTS (SQL 2000) Now we are converting to 2005 and I need help with SSIS packages ..I need run one SSIS for all 50 databsess on server Please help ASP I need maybe code sample or SSIS sampel if posiible I am new to SSIS |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-18 : 21:52:49
|
| One method to achieve this is to use a For Each loop container and create a recordset with name of 50 dbs.Then inside For Each loop container use a variable to access the db name for each iteration and do the reqd operations using this variable name in place where you need to refer to dbname. |
 |
|
|
|
|
|
SSIS