1

Getting this error while trying to run Package.dtsx from command file(.cmd).

To run SSIS package outside of SQL server Data Tools you must install %File_creation% of Integration services or higher

I've used package parameters & File System Tasks in the package. I used below script in command file.

DTEXEC /FILE "F:\SOME FOLDER\Package.dtsx" /CONFIGFILE "F:\SOME FOLDER\PackagedtsConfig"

Appreciate any help on this.

CDspace
  • 2,639
  • 18
  • 30
  • 36
user2919579
  • 39
  • 2
  • 10
  • Maybe this can help: http://stackoverflow.com/questions/35469249/to-run-a-ssis-package-outside-of-sql-server-data-tools-you-must-install-move-fil#39553924 – Jens Mar 31 '17 at 09:46
  • What version of SQL Server (express/standard/enterprise) and what year? – sorrell Mar 31 '17 at 11:36

1 Answers1

1

The main problem is that SSIS packages are deployed using a SSDT version newer that the one installed on the server you are trying to execute the package on it. You have to install the same version of SSDT on the server.

Useful Links

Community
  • 1
  • 1
Yahfoufi
  • 2,220
  • 1
  • 22
  • 41
  • @user2919579 if it solved your issue you have to [accept or upvote this answer](http://www.stackoverflow.com/tour), else give me a feedback – Yahfoufi Mar 31 '17 at 13:16