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-09-09 : 19:47:53
|
| Hi,I have researched the creation of configuration files for the past few days and made certain that I created them exactly the way the author said (Source: http://www.mssqltips.com/tip.asp?tip=1405). I have changed the connection string to point to another database on the same server (for a simple Execute SQL Statement task). When I execute the package, the connection to the Execute SQL Statement task does not change to the connection on my configuration file. Am I missing something in my properties or something? Any help would be greatly appreciated. Thank you for taking the time to read my problem. |
|
|
favaz.farook@gmail.com
Starting Member
8 Posts |
Posted - 2008-09-15 : 09:46:26
|
| when it comes to connection string setting the connection string through variables should be done inside a Script Task using VB Script, when you set it using Expessions it does not get set for some reason |
 |
|
|
|
|
|
Configuration File Error?