Deploying SSIS Package and calling it from Console application

[indian143]

Hi, I have an SSIS package which does some Database functionalities, I want to deploy that package as just .dtsx file on to some servers filesystem and call it from a schduled task. Can I just copy the .dtsx file from the solution folder and put it on some server and execute it from .Net code. If not how to deploy an SSIS package on to filesystem as just .dtsx file and call it from .net code to finish its functionalities. I am also searching on the internet but any kind help like code snippet, suggestion or any link would be appreciated. Thanks in advance.

Thanks & Regards, Abdul Aleem Mohammad St Louis MO - USA

[unclepaul]

See this article http://blog.sqlauthority.com/2011/05/21/sql-server-running-ssis-package-from-command-line/[^] Caveat: Each machine where the package is to be run must have a SSIS Installation which requires a SQL server license. This can get expensive.

If at first you don't succeed, look for directions in the trash.

[Mycroft Holmes]

What is it with you people today, the previous bloke wanted to use a trigger, you want to deploy a dtx and schedule it with some tool. USE A SQL JOB. That is precisely what it is designed for! there are a whole bunch of stuff available [^]

Never underestimate the power of human stupidity RAH