SSIS package deployment

1. SSIS package deployment can generate deployment files, deploy them to sqlserver, and then execute them through scheduled jobs.

2. You can also use shell to call dtsx and scheduled to call EXE through windows scheduled tasks.

Either way, the server must install sqlserver integration service. after integration service is installed, go to c: \ Program Files (x86) \ common files \ microsoft shared \ vsta \ pipeline \ addinviews or C: \ Program Files (x86) \ Microsoft SQL Server \ 100 \ SDK \ assemblies directory contains Microsoft. sqlserver. dtsruntimewrap. DLL

Reference this DLL

Using system; using system. collections. generic; using system. LINQ; using system. text; using system. io; using system. configuration; using dtsruntime = Microsoft. sqlserver. DTS. runtime. wrapper; namespace ssisshell {class program {Private Static string ssisname = configurationmanager. deleetask[ "ssisname"]; static void main (string [] ARGs) {try {log. write ("start execution"); string Path = path. combine (appdomain. currentdomain. basedirectory, ssisname); dtsruntime. application dtsapplication = new dtsruntime. application (); dtsruntime. idtspackage100 package = dtsapplication. loadpackage (path, true, null); dtsruntime. dtsexecresult result = package. execute (); log. write ("execution ended, execution result:" + result);} catch (exception ex) {log. write (Ex );}}}}

 

SSIS package deployment