SSIS package fails while running using cmd line

2
votes

when I try to run a SSIS package , it fails throwing an error

Description: To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition (64-bit) of Integration Services or higher.

this occurs only with a few packages, few of them succeed while few of them fail with this error. I am confused, can someone help me on this ?

All the packages are the same, i am creating a ADO.net source and OLE DB destination which dumps the file to sql server 2012.

please advice.

1
sql-servercmdssisetl
The error says clearly what you need? To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition (64-bit) of Integration Services or higher. – Ramesh Rajendran
there are the other packages which are running successfully on the same machine. it is only with a few packages that throws out this error. – partha buragohain
Which Windows version are you running? And, is it 32-bit or 64-bit? – lit

1 Answers

0
votes

In Visual studio.

Go To Projects Menu -> Package Properties ->Debugging

Change Run64BitRuntime to false

Menu

enter image description here