• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

What SQL SSIS Connection String ??


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

"Provider=SQLNCLI10;Server=TestServer;Database=SampleDB;Uid=sa;Pwd=Chokka";

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

Eventually value is not exported to SQL Table ..!

Do SQL SSIS has different Connectin String ?
0
chokka
Asked:
chokka
1 Solution
 
Jason Yousef, MSSr. BI DeveloperCommented:
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

http://msdn.microsoft.com/en-us/library/cc895212.aspx
http://www.mssqltips.com/tip.asp?tip=1405

hope that helps
Regards,
Jason
0
 
chokkaAuthor Commented:
Where is UserName and Password

0
 
Jason Yousef, MSSr. BI DeveloperCommented:
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.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Jason Yousef, MSSr. BI DeveloperCommented:
CHeck that:

Integrated:

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;
0
 
käµfm³d 👽Commented:
@huslayer

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!

@chokka
Can you provide more information about what you are trying to accomplish?
0
 
chokkaAuthor Commented:

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 ..!


0
 
Alpesh PatelAssistant ConsultantCommented:
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.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now