Error when setting up dynamic connection string

• Abu Dina

  SSChampion

  Points: 14155

  More actions

  August 24, 2012 at 9:24 am

  #263342

  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[/url]

  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

• n79799

  SSC Eights!

  Points: 804

  More actions

  August 27, 2012 at 12:06 pm

  #1530455

  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.