What SQL SSIS Connection String ??

Posted on 2011-04-22
Last Modified: 2012-05-11

I am passing Connection String from C# Application to .dtsx package ..!


Every thing looks good !!! Execution Result comes as Success ..!

Eventually value is not exported to SQL Table ..!

Do SQL SSIS has different Connectin String ?
Question by:chokka
    LVL 21

    Expert Comment

    Yep , it uses something like

    Data Source=localhost;Initial Catalog=SampleDB;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;

    You can read more here about SSIS configurations.

    the second link is a walkthrough

    hope that helps

    Author Comment

    Where is UserName and Password

    LVL 21

    Expert Comment

    More options:

    1.You can use the Execute Package Utility to change your datasource, before running the package.

    2.You can run your package using DTEXEC, and change your connection by passing in a /CONNECTION parameter. Probably save it as a batch so next time you don't need to type the whole thing and just change the datasource as required.

    3.Or you can use the SSIS XML package configuration file.
    LVL 21

    Accepted Solution

    CHeck that:


    Data Source=ServerHere;Initial Catalog=TestDB;Provider=SQLNCLI10.1;Integrated Security=SSPI;

    U / P :

    Data Source=ServerHere;Initial Catalog=TestDB;Provider=SQLNCLI10.1;Pwd=gunhill;User ID=sagent;
    LVL 74

    Expert Comment

    by:käµfm³d 👽

    Yep , it uses something like...
    That is dependent on the DB you are targeting and the communication mechanism you are using. The string you posted is not applicable to every database!

    Can you provide more information about what you are trying to accomplish?

    Author Comment


    I am passing this connection string from my Application to SSIS Package ..

    string destDir = "Provider=SQLNCLI10.1;Server=Server;Database=DB;Uid=sa;Pwd=Password;";

    I am getting the output as Execution result as Success ..! But values are not populated in Database ..!

    LVL 21

    Expert Comment

    by:Alpesh Patel
    Please first double check
    1. Package is running successfully from BIDS.
    2. Parameter reach at Package
    3. Create Custom Error log or Trace log to track the process. Using this you can track the cause of this.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
    Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now