April 17, 2009 at 5:31 am
Hi
I'm having problems setting up a connection string variable. I've created a connection in the connection manager. Set the svrname & dbname, checked that it works, then in the connection properties set the connectionstring expression to be the my connectionstring variable. This doesn't want to work though.
The connectionstring is "Data Source=DevSvr;Initial Catalog=DevDb;Provider=SQLNCLI.1;Integrated Security=SSPI;"
The error i receive is connection "Data Source=DevSvr;Initial Catalog=DevDb;Provider=SQLNCLI.1;Integrated Security=SSPI;" is not found.
Any help would be appreciated. Are there any tutorials as to set connectionstrings as variables as I can't seem to find any.
Cheers
Lbob
April 17, 2009 at 6:25 am
Create 2 variables for ServerName and DatabaseName and use them in the property expression to form the connection string as below.
"Data Source="+ @[User::ServerName] +";Initial Catalog="+ @[User::DatabaseName] +";Provider=SQLNCLI.1;Integrated Security=SSPI;"
April 17, 2009 at 3:19 pm
Here is some configuration information for you to take a look at:
Best Practices for Integration Services Configurations
Reusing Connections with Data Sources and Configurations
Understanding Integration Services Package Configurations
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 6, 2009 at 8:06 am
Hi
Sorry for the delay in replying, thanks for the info, will be looking into it all today.
Lbob
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply