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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 SSIS variable data source info

Author  Topic 

southernpost
Starting Member

1 Post

Posted - 2006-06-12 : 15:02:42
Does anyone know of a way to use environment variables to substitute the connection string paramaters of Server Name, User ID, Password and Initial Catalog? I would like to use the same package to convert data from different copies of a source database without having to redefine the OLE DB source tasks everytime.
   

- Advertisement -