Reputation: 1
Currently SSIS package 2012 is working fine in SQL server 2012 so we have migrated the objects into SQL server 2016 and the same package also converted into 2016 and deploying into SQL server 2016 but faced below error.
Batch File - We dont have dtutil in Program Files for 64 bit :
"C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\dtutil.exe" /FILE "G:\MSDB2016\MSDB2016\MSDB2016\Package.dtsx" /DestServer <> /COPY SQL;"MISSnOP_Test2016\Package" /Q > test1.txt
Error - test1.txt :
Microsoft (R) SQL Server SSIS Package Utilities Version 11.0.6020.0 for 32-bit Copyright (C) Microsoft Corporation 2012. All rights reserved.
Could not load package "G:\MSDB2016\MSDB2016\MSDB2016\Package.dtsx" because of error 0xC0011008. Description: The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. Source: Package
Note :
The same 2012 package is deployed in SQL server 2016 (MSDB), the SQL job is working fine but not triggered the packages (data is not updated into the audit table). The same package is working fine in manually through VS 2010 and VS 2015. I have tried lot of things but could not resolve this issue. Please help me to resolve the same.
Upvotes: 0
Views: 387