Link to home
Start Free TrialLog in
Avatar of onesegun
onesegunFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SSIS Connection String Expression

Hi there,

Can anyone show me an example of a connection string to an sql database with:

1.A server
2.An instance name
3.A login user name
4.A password

I can't seem to form one.

Here's is the one that is not working:

"Data Source=LMHT-SQ12DEV\\UATITDEV;Initial Catalog=SSIS_CONFIG;Integrated Security=False;User ID=Smith;Password=#####;Provider=SQLNCLI10.1;"

Open in new window


Thanks,

OS
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of onesegun

ASKER

Hi All,

Thanks for your help. I realised that the problem was with the packaged. I was trying to use the connection string in an SSIS config database table and because I didn't save the package with a password encrypted it seemed to be playing havoc with the reference the SSIS package was trying to use for the connection sting.

Thanks,

OS