Solved

SSIS Connection String Expression

Posted on 2014-10-24
3
166 Views
Last Modified: 2016-02-11
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
0
Comment
Question by:onesegun
3 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 250 total points
ID: 40404833
Satandard security would be...
Server=TheServer;Database=TheDatabase;User Id=TheUser;
Password=ThePassword;

Open in new window


TheServer can be an server address on your network, IP address, or URL.

Also, the site Connection Strings has a wompload of examples for all databases.
0
 
LVL 15

Assisted Solution

by:Vikas Garg
Vikas Garg earned 250 total points
ID: 40405740
Hi,

Try this


Data Source=ServerName;User ID=sa;Password=ThePassword;Initial Catalog=Databasename;Provider=SQLNCLI11.1;Auto Translate=False;
0
 

Author Comment

by:onesegun
ID: 40432366
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
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question