Post reply

Error when trying to open SSIS package for editing

  • February 5, 2010 at 3:15 pm

    #216424

    Hi, I have an SSIS package that I have previously edited and run without problem. Now, when I try to open it for editing I get these errors:

    [font="Courier New"]Error1Error loading PACKAGE_NAME.dtsx: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:Property DTS:Name="DelayValidation">0</DTS:Property> <DTS:Property DTS:Name="ObjectName">DATABASE_NAME</DTS:Property> <DTS:Property DTS:Name="DTSID">{B2C3F6AD-FA39-49DB-9D3B-AB7DF7B33F" from node "DTS:ConnectionManager". D:\PACKAGE_NAME.dtsx11[/font]

    [font="Courier New"]Error2Error loading PACKAGE_NAME.dtsx' : Exception from HRESULT: 0xC0010014.D:\PACKAGE_NAME.dtsx11[/font]

    Like I said this was working fine as recently as a couple weeks ago. The package itself hasn't actually changed since then, I just can't open it. Does anyone know what the problem could be?

    Thanks

  • February 8, 2010 at 9:14 am

    #1115595

    I managed to open the file by manual editing the .dtsx file and removing the two SQL Server connections from the XML. I just had to make new connections for the steps after opening it.

    I still would like to know why this happened... it's easy enough to fix for one package but I'm worried something like this could happen when we have dozens.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply