Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Error when setting up dynamic connection string Expand / Collapse
Posted Friday, August 24, 2012 9:24 AM

Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, October 11, 2016 4:41 AM
Points: 713, Visits: 3,323
Hi there,

I am creating an SSIS package to pull information about job history and store it in a centralised database.

I won't go into too much detail but I have my connection string defined as below:

When I run my package I get the following error!

Any ideas?


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1349754
Posted Monday, August 27, 2012 12:06 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 26, 2016 10:31 AM
Points: 35, Visits: 122
Hope the variable @[user::connecitonstring] actually holds only the ServerName\Instance name and NOT the whole connection string.

(because the name sounds as if it holds the whole conn string). Please check.
Post #1350512
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse