c# - Executing SSIS 2012 package that has script components from external application -


i'm writing application execute ssis 2012 package using microsoft.sqlserver.manageddts v 11.0 assembly. package i'm trying execute designed , executed ssdt-2012, , has script components handle rows don't transfer correctly.

when try run application error message each of script components:

ssis.pipeline: run ssis package outside of sql server data tools must install [script component name] of integration services or higher.

configuration: building application x86 on windows following app.config file:

<?xml version="1.0" encoding="utf-8" ?> <configuration>     <startup uselegacyv2runtimeactivationpolicy="true">         <supportedruntime version="v4.0"/>         <supportedruntime version="v2.0.50727"/>     </startup> </configuration> 

the relevant code is:

using system; using system.data; using system.data.common; using system.io; using microsoft.sqlserver.dts.runtime; class myapp {     public void executepackage()     {         //assume have variables need packagefile, packagename,          //srcconnectionstring, destconnectionstring , eventlistener etc.          package pkg;         application app;         dtsexecresults pkgresults;          app = new application();         pkg = app.loadpackage(packagefile, eventlistener);          pkg.variables["srcconnectionstring"].value = srcconnectionstring;         pkg.variables["destconnectionstring"].value = destconnectionstring;          if (null != srcassembly || null != destassembly)         {             foreach (connectionmanager connection in pkg.connections)             {                 if (null != srcassembly && connection.name.contains("source"))                 {                     connection.setqualifier(srcassembly);                 }                 else if (null != destassembly && connection.name.contains("destination"))                 {                     connection.setqualifier(destassembly);                 }             }         }          pkgresults = pkg.execute(null, null, eventlistener, null, null);     }  } 

any ideas?

you not have sql server integration services service installed on machine application running from.

see https://dba.stackexchange.com/questions/49786/error-to-run-a-ssis-package-outside-of-sql-server-data-tools-you-must-install


Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -