SSIS Package Fails with DTEXEC

• gphillips-817745

  SSC Veteran

  Points: 239

  More actions

  May 12, 2017 at 3:43 pm

  #330233

  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 xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:ConnectionManager DTS:refId="Package.ConnectionManagers[VisionReportingData]"
  DTS:CreationName="ODBC" DTS:DTSID="{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.