question

ZengJeff-0760 avatar image
0 Votes"
ZengJeff-0760 asked Monalv-msft edited

Validate/run package error: C06D007E

Our product provides a feature to load a package from a .dtsx file, validate the package and run the package. We implemented IDTSEvents and can receive error messages
In one of our customer's environment, there is error with one package. I attached the .dtsx file and the error information.

Does any one have any idea?


81362-itemserror.jpg


sql-server-integration-services
item.xml (327.4 KiB)
itemserror.jpg (38.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @ZengJeff-0760 ,

  1. We can change the item.xml as item.dtsx firstly.

  2. Then please create new ssis project and add existing package.

  3. It seems that there is a custom task in this package. So please check if you have the script of this custom task.

  4. Please check if you can test the Connection Managers correctly.

81378-ssisfile.png
81368-addexistingpackage.png
81379-addcopyofexistingpackage.png
81380-cf.png

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.







ssisfile.png (5.2 KiB)
cf.png (56.5 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

The custom task and the connection managers are ok. Our customer removed the task 'Export mbrM_ITEM' and the package can be run successfully. Since it is a Microsoft.Pipeline task, do you know why it failed? Or how can I troubleshoot it?

0 Votes 0 ·

Hi @ZengJeff-0760 ,

Integration Services includes features and tools that you can use to troubleshoot connectivity between packages and the data sources from which packages extract and load data.
Integration Services includes features and tools that you can use to troubleshoot packages when you execute them after they have been completed and deployed.

Please refer to the following links:
1.Troubleshooting Tools for Package Connectivity
2.Troubleshooting Tools for Package Execution

Best regards,
Mona


0 Votes 0 ·