Calling SSIS package from C# code

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Calling SSIS package from C# code

Author

Topic

Lightbug3
Starting Member

6 Posts

Posted - 2007-04-10 : 09:01:54

I am using the following code to run my SSIS package:

Package package = app.LoadFromSqlServer
("\\EPSROI\\dts_Client_Eligibility_Import", "SQL32", "username",
"password", null);

Variables vars = package.Variables;
vars["InputFile"].Value = txtInput.Text;
vars["OutputFile"].Value = txtOutput.Text;
vars["Client"].Value = cboClientName.SelectedValue.ToString();
vars["Chopper"].Value = Chopper;

DTSExecResult result = package.Execute();

It runs fine on my machine; however, on anyone elses machine "result" comes back as "failure". We have figured out that it is loading the package and variables fine but failing before the first step of the package. Does anyone know why this would be? Or how to fix it? I am totally stumped considering it works fine on my machine.

Thanks.
Danielle

slaws
Starting Member

9 Posts

Posted - 2007-04-18 : 16:14:09

This might be assumed but....Do the users have SSIS running on their machines? Apparently to run SSIS packages on another machine SSIS needs to be installed and Microsoft didn't make this redistributable. Each user would need to have a license. I ended up running all of my packanges using the DTEXEC command in a stored procedure. I hope that helps.

Scott

SatyaSKJ
Starting Member

46 Posts

Posted - 2007-04-19 : 06:49:03

Also I would suggst to check for the privileges for those users on the SQL Server, sometimes the error is pretty generic and hard to dig through the root cause. Make sure they can ping the SQL Server without any issues to connect.

Satya SKJ
SQL Server MVP
http://www.sqlserver-qa.net

jcrivera
Starting Member

1 Post

Posted - 2008-07-10 : 15:56:43

greetings, slaws.

I'd like to know how I can do this (to use dtexec) to run a SSIS package that contains a stored procedure with parameters. I know how to call the stored proceudre that will execute the dtexec from my C# code, however am stucked on how to deal with the SSIS.

Please advise.

jc

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources