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.
Comments
Post a Comment