Validate/run package error: C06D007E

Zeng, Jeff 1 Reputation point
2021-03-25T03:14:57.367+00:00

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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points
    2021-03-25T06:48:17.723+00:00

    Hi @Zeng, Jeff ,

    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.