c# - Trouble running SSIS package programmatically and from command line (DTEXEC) -


i attempting execute ssis package programmatically using c#.

application app = new application(); package package = app.loadpackage(pkgfullpath, null); package.execute(); 

i getting error saying:

error in microsoft.sqlserver.dts.runtime.taskhost/ssis.pipeline : run ssis package outside of sql server data tools must install conditional split of integration services or higher.  error in microsoft.sqlserver.dts.runtime.taskhost/ssis.pipeline : run ssis package outside of sql server data tools must install lookup of integration services or higher. 

i using ssis in visual studio 2010, executing c# code nunit test in vs 2012 (running .net 4.0)

the package runs fine inside ssis project in vs 2010 if launch debugging (press f5), fails same error if try run using dtexec command line (same failure in both 32 , 64 bit version of dtexec). fails same error if launch inside visual studio using ctrl + f5 (without debugging)

i have found articles online suggest it's related 64 bit v 32 bit problem, seeing same error when running both versions of dtexec. using version 11.0.2100.60 of dtexec, matches version of sql server integration services designer in vs 2010.

i don't error if run simple package without conditional split , lookup. have install in order run outside of visual studio?

any ideas?

in continuation above comment,if service installed properly, might issue regarding rights(i see using sql 2012) of account packages executed from.

refer http://technet.microsoft.com/en-us/library/hh213130.aspx

hope helps.


Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -