SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SSIS Package Fails with DTEXEC

SSIS Package Fails with DTEXEC

SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 11
I have an Integration Services Project that uses two connections to transfer data from a cloud database to a local SQL Server database. The Cloud database uses a 32 bit ODBC Driver which has been set up using the 32 bit ODBC setup program. I also set up a 32 bit ODBC data source for the local SQL database. My Project runs fine in VS 2015. If I try to execute the .dtsx file using dtexec (verifying that I am running the 32 bit version of DTExec), it fails with the following:

Microsoft (R) SQL Server Execute Package Utility
Version 13.0.1601.5 for 32-bit
Copyright (C) 2016 Microsoft. All rights reserved.

Started: 2:31:59 PM
Error: 2017-05-12 14:31:59.26
Code: 0xC0010018
Source: Package
Description: Error loading value "<DTS:ConnectionManagers xmlnsBigGrinTS="www.microsoft.com/SqlServer/Dts"><DTS:ConnectionManager DTS:refId="Package.ConnectionManagers[VisionReportingData]"
DTS:CreationName="ODBC" DTSBigGrinTSID="{0B7F485E-9C4C-4BC4-8D01-6903FC20BF74}" DTS:ObjectName="VisionReportin" from node "DTS:ConnectionManagers".
End Error
Could not load package "package.dtsx" because of error 0xC0010014.
Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors.
This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.
Source: Package
Started: 2:31:59 PM
Finished: 2:31:59 PM
Elapsed: 0.219 seconds

The connection it complains about is the SQL Server ODBC connection. It may have a problem with the cloud one, but just reports this on first. The "ObjectName" is cut off in the error message.
The version of DTEXEC I am using is from the ...\130\Binn Folder of SQl Server. There is no dtexec.exe in the 140\Binn folder.

I have moved the porgram to another machine with VS 2015 and SSIS for VS 2015 and it behaves execatly the same way.

Any help/ideas would be appreciated.
PS. The smiley faces are colons on the screen. No idea why they converted to them when pasted.


You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum