question

mjharper avatar image
mjharper asked

running SSIS through DTExec

Hi I am trying to run a dtsx package through DTExec and get the following error: Description: To run a SSIS package outside of SQL Server Data Tools you must install of Integration Services or higher. where `` changes depending on the first task in the package. This used to work fine on my old laptop, but I had SQL2012 development edition installed on there whereas now I only have SQL 2012 management tools installed. Do I have to have a SQL Server installed in order to run a SSIS package through DTExec? Thanks.
ssis
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Martin Schoombee avatar image
Martin Schoombee answered
Yes, if you are trying to execute a package locally (irrespective of the method) you have to have SSIS and the SQL Server shared components installed.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

mjharper avatar image mjharper commented ·
thanks Martin.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.