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 2005 Forums
 SSIS and Import/Export (2005)
 package configuration

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-10-28 : 10:13:57
1. i create simple package in my clinet.
2. create enviroment variable (name of production server -BIPROD) in my
client and in production server.
3. create enviroment variable (name of DEVELOPMENT server-BIDEV) my
Development server.
4.create configuration packge, for each data source i choose the
enviroment variable

when i open the packge in my client i get this warning,
why?
"this package contains at least one connection wich is based on a datasource.
The Connection string for connections and data sources listed below are currently not identical."

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-11-02 : 02:11:59
i ask another question:

how i worked with package configuration in my client,dev,prod?
i preffer to use enviroment variable and sql server.
Go to Top of Page
   

- Advertisement -