April 10, 2014 at 1:14 am
HI all,
i've just installed SQL Server 2012, VS 2013 (Premium) and SQL Server Data Tools (SSDTBI_VS2012_x86_ENU) on my local workstation (running Win7 x64).
Creating and debugging of new SSIS modules works well, while execution of the module using DTEXEC fails with:
Description: Package migration from version 8 to version 6 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number.".
How to create SSIS modules with VS2013, which are executable on SQL Server 2012?
Are there general constraint?
Any help is appreciated!
Thank you in advance!
Details:
D:\tmp>dtexec /f Package_by_vs2013.dtsx
Microsoft (R) SQL Server Execute Package Utility
Version 11.0.2100.60 for 64-bit
Copyright (C) Microsoft Corporation. All rights reserved.
Started: 12:48:51
Error: 2014-04-09 12:48:52.69
Code: 0xC001F02A
Source: Package
Description: Cannot create a task from XML for task "Execute SQL Task", type "Microsoft.ExecuteSQLTask" due to error 0x80070057 "Falscher Parameter.".
End Error
Error: 2014-04-09 12:48:52.69
Code: 0xC0010018
Source: Execute SQL Task
Description: Failed to load task "Execute SQL Task", type "". The contact information for this task is "Execute SQL Task; Microsoft Corporation; SQL Server 2
014; ? 2014 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1".
End Error
Error: 2014-04-09 12:48:52.72
Code: 0xC0010026
Source: Execute SQL Task
Description: The task has failed to load. The contact information for this task is "Execute SQL Task; Microsoft Corporation; SQL Server 2014; ? 2014 Microsof
t Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1".
End Error
Error: 2014-04-09 12:48:52.72
Code: 0xC0024107
Source: Execute SQL Task
Description: There were errors during task validation.
End Error
Error: 2014-04-09 12:48:52.72
Code: 0xC0010025
Source: Package
Description: The package cannot execute because it contains tasks that failed to load.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 12:48:51
Finished: 12:48:52
Elapsed: 1.123 seconds
April 10, 2014 at 1:22 am
SSIS versions are not backwards compatible (unfortunately).
VS 2013 is used for SQL Server 2014, VS 2010/12 is used for SQL Server 2012.
You can download the VS 2012 SSDTBI shell here:
http://www.microsoft.com/en-us/download/details.aspx?id=36843
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 11, 2014 at 1:35 am
Many thanks for your quick help, Koen!
This clarifies the strange behaviour.
The Microsoft documentation on this fact was not really obvious at a glance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply