Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SSIS Connection String Expression

Posted on 2014-10-24
3
165 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Suggested Solutions

Title # Comments Views Activity
SQL query with cast 38 53
Flattening heirachies 3 42
Separate 2 comma delimited columns into separate rows 2 41
too many installs coming along with SQL 2016? 1 16
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

840 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