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 |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2010-11-10 : 11:27:47
|
| I have two package level variables (server_result and db_result), which are set using the results of a SQL Task.I then use the variables as part of a connection string expression(Connection Manager) which connects to a SQL db ("Data Source=" + @[User::server_result] + ";Initial Catalog=" + @[User::db_result] + ";Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;")I am unable to choose a table or view in the Data Flow Task when using this connection. The list of tables or views displays nothing.I know the variables are set correctly, because I display them via a message box (script task) from the Control Flow tab.Can anyone help me out? |
|
|
|
|
|
Cant use variables set as a connection string.