We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

What SQL SSIS Connection String ??

Medium Priority
343 Views
Last Modified: 2012-05-11

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 ?
Comment
Watch Question

Jason YousefSr. BI  Developer

Commented:
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
chokkaStudent

Author

Commented:
Where is UserName and Password

Jason YousefSr. BI  Developer

Commented:
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.
Sr. BI  Developer
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2015

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?
chokkaStudent

Author

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


Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.