CODEWITHSUNDEEP
sql-serverssissql-server-2012
Vinay Pratap Singh Bhadauria
Vinay Pratap Singh Bhadauria

Reputation: 9947

Error running the SSIS package out side the Development studio

I am learning to work with the SSIS packages.

I have made an SSIS package to work with the delta data(changed data since last run).

But i am having troubles running the package outside the development enviroment

I have tried to runt it with DTEXECUI.EXE utilty but it gives me the following error.

enter image description here

I have also tried to run it from a stored procedure by enabling the xp_cmdshell but i still get some error like this.

enter image description here

Please help, i am also trying to Google my way through.

Upvotes: 0

Views: 57

Answers (1)

Divi
Divi

Reputation: 7691

It's clear from the error messages To run a ssis package outside of sql server data tools you must...

SSIS 2012 components have to be installed on your server to resolve the issue.

As per this post:

What you need are the base SQL Server binaries which are installed with the DB engine. So you need a SQL Server Instance of some flavour to have dtexec running. Whether it's the DB Engine or the SSIS service installed but disabled.

Running packages in BIDS is a special case. Run the package on the same PC as BIDS via dtexec and it will fail unless you have installed server components (= a SQL Server Instance)

Upvotes: 1

Related Questions