onesegun
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:
Thanks,
OS
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;"
Thanks,
OS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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