Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSIS Connection String Expression

Posted on 2014-10-24
3
Medium Priority
?
170 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 66

Accepted Solution

by:
Jim Horn earned 1000 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 1000 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

782 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