Error when setting up dynamic connection string

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Error when setting up dynamic connection...

Error when setting up dynamic connection string

Rate Topic

Display Mode

Topic Options

Author

Message

Abu Dina

Posted Friday, August 24, 2012 9:24 AM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 9:30 AM
Points: 484, Visits: 2,122

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?

-----------------------------------
http://www.SQL4n00bs.com

Post #1349754

n79799

Posted Monday, August 27, 2012 12:06 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 10:30 PM
Points: 35, Visits: 81

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 »

Permissions