CODEWITHSUNDEEP
sql-serverssis
2d1b
2d1b

Reputation: 625

Deploying and calling SSIS package from .NET

I have a SSIS package that I plan to deploy on my SQL Server 2008 machine.

I need to call this SSIS package remotely and synchronously from .NET. Obviously I need to pass parameters to this package as well.

How could I do that?

Thanks, Alex

Upvotes: 2

Views: 792

Answers (3)

Michael Entin
Michael Entin

Reputation: 7764

Another way is to write simple application exposing a web service that allows executing packages - SQL Books Online has a nice sample.

Upvotes: 0

Cade Roux
Cade Roux

Reputation: 89741

You can make a job and then start the job from straight SQL using sp_start_job. This would be asynchronous.

Running on the server, it will need to have access to any files you might be reading in or writing out (it would also need to have the package - so if you are code-generating a package from a template or something, getting it onto the server might be an issue).

You can also use psexec to run a process on any remote server. In this case, it would be to run dtexec. This would get around having to enable xp_cmdshell. (same issue with needing to see the package and see any files)

Upvotes: 3

adopilot
adopilot

Reputation: 4520

If Your SQL server is in safety environment You can try make SSIS Package runnable from Stred Procedure, Then I think that is your code can easy call stored procedure on SQL server.

This considering that you must enable xp_cmdshell (at least as I know for SQL2005) which is always mentioned as dangerous task according to server security.

Upvotes: 0

Related Questions