| Groups | Blog | Home |
sql server dts : SSIS Package Error
How can I determine what is causing the following package to fail?
Error: Error 0xC0012050 while loading package file "C:\Documents and Settings\wardte\Local Settings\Temp\2\InnerPackage.dtsx". Package failed
Here's the rest of the information:
Information: 0x40043006 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, DTS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, DTS.Pipeline: Execute phase is beginning. Information: 0x402090DF at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, OLE DB Destination [2]: The final commit for the data insertion has started. Information: 0x402090E0 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, OLE DB Destination [2]: The final commit for the data insertion has ended. Information: 0x40043008 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, DTS.Pipeline: Post Execute phase is beginning. Information: 0x40043009 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, DTS.Pipeline: Cleanup phase is beginning. Information: 0x4004300B at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, DTS.Pipeline: "component "OLE DB Destination" (2)" wrote 0 rows. Information: 0x4004300A at {05004535-2B97-4B58-906A-11E69AA53323}, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at {05004535-2B97-4B58-906A-11E69AA53323}, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at {05004535-2B97-4B58-906A-11E69AA53323}, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 at {05004535-2B97-4B58-906A-11E69AA53323}, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at {05004535-2B97-4B58-906A-11E69AA53323}, DTS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at {05004535-2B97-4B58-906A-11E69AA53323}, DTS.Pipeline: Execute phase is beginning. Information: 0x402090DF at {05004535-2B97-4B58-906A-11E69AA53323}, OLE DB Destination [2]: The final commit for the data insertion has started. Information: 0x402090E0 at {05004535-2B97-4B58-906A-11E69AA53323}, OLE DB Destination [2]: The final commit for the data insertion has ended. Information: 0x40043008 at {05004535-2B97-4B58-906A-11E69AA53323}, DTS.Pipeline: Post Execute phase is beginning. Information: 0x40043009 at {05004535-2B97-4B58-906A-11E69AA53323}, DTS.Pipeline: Cleanup phase is beginning. Information: 0x4004300B at {05004535-2B97-4B58-906A-11E69AA53323}, DTS.Pipeline: "component "OLE DB Destination" (2)" wrote 0 rows. Information: 0x4004300A at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: Validation phase is beginning. Error: 0xC0047008 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: The package contains two objects with the duplicate name of "output column "ErrorCode" (69)" and "output column "ErrorCode" (14)". Error: 0xC0047008 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: The package contains two objects with the duplicate name of "output column "ErrorColumn" (74)" and "output column "ErrorColumn" (15)". Error: 0xC004706B at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_ISCORRUPT". Error: 0xC004700C at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: One or more component failed validation. Error: 0xC0024107 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}: There were errors during task validation. Error: 0xC00220DE at Execute Inner Package: Error 0xC0012050 while loading package file "C:\Documents and Settings\wardte\Local Settings\Temp\2\InnerPackage.dtsx". Package failed validation from the ExecutePackage task. The package cannot run. .. Task failed: Execute Inner Package Task failed: CompensatingSql SSIS package "Reporting_Database.dtsx" finished: Failure. [quoted text, click to view] "Terry" wrote:
> How can I determine what is causing the following package to fail? > > Error: Error 0xC0012050 while loading package file "C:\Documents and > Settings\wardte\Local Settings\Temp\2\InnerPackage.dtsx". Package failed
My investigation would start around here in your output
Error: 0xC0047008 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: The package contains two objects with the duplicate name of "output column "ErrorCode" (69)" and "output column "ErrorCode" (14)". Error: 0xC0047008 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: The package contains two objects with the duplicate name of "output column "ErrorColumn" (74)" and "output column "ErrorColumn" (15)". Error: 0xC004706B at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_ISCORRUPT". Error: 0xC004700C at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: One or more component failed validation. Error: 0xC0024107 at {5C909D87 From BOL VS_ISCORRUPT means The component is irreparably damaged and must be completely reset. The designer calls the component's ProvideComponentProperties method in response. -- Allan Mitchell Konesans Ltd T +44 7966 476 572 F +44 2071 008 479 http://www.konesans.com [quoted text, click to view] "Terry" <Terry@discussions.microsoft.com> wrote in message news:25235232-484B-47D2-B734-1771C6014203@microsoft.com... > Here's the rest of the information: > > Information: 0x40043006 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > DTS.Pipeline: Prepare for Execute phase is beginning. > Information: 0x40043007 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > DTS.Pipeline: Pre-Execute phase is beginning. > Information: 0x4004300C at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > DTS.Pipeline: Execute phase is beginning. > Information: 0x402090DF at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, OLE DB > Destination [2]: The final commit for the data insertion has started. > Information: 0x402090E0 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, OLE DB > Destination [2]: The final commit for the data insertion has ended. > Information: 0x40043008 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > DTS.Pipeline: Post Execute phase is beginning. > Information: 0x40043009 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > DTS.Pipeline: Cleanup phase is beginning. > Information: 0x4004300B at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > DTS.Pipeline: "component "OLE DB Destination" (2)" wrote 0 rows. > Information: 0x4004300A at {05004535-2B97-4B58-906A-11E69AA53323}, > DTS.Pipeline: Validation phase is beginning. > Information: 0x4004300A at {05004535-2B97-4B58-906A-11E69AA53323}, > DTS.Pipeline: Validation phase is beginning. > Information: 0x4004300A at {05004535-2B97-4B58-906A-11E69AA53323}, > DTS.Pipeline: Validation phase is beginning. > Information: 0x40043006 at {05004535-2B97-4B58-906A-11E69AA53323}, > DTS.Pipeline: Prepare for Execute phase is beginning. > Information: 0x40043007 at {05004535-2B97-4B58-906A-11E69AA53323}, > DTS.Pipeline: Pre-Execute phase is beginning. > Information: 0x4004300C at {05004535-2B97-4B58-906A-11E69AA53323}, > DTS.Pipeline: Execute phase is beginning. > Information: 0x402090DF at {05004535-2B97-4B58-906A-11E69AA53323}, OLE DB > Destination [2]: The final commit for the data insertion has started. > Information: 0x402090E0 at {05004535-2B97-4B58-906A-11E69AA53323}, OLE DB > Destination [2]: The final commit for the data insertion has ended. > Information: 0x40043008 at {05004535-2B97-4B58-906A-11E69AA53323}, > DTS.Pipeline: Post Execute phase is beginning. > Information: 0x40043009 at {05004535-2B97-4B58-906A-11E69AA53323}, > DTS.Pipeline: Cleanup phase is beginning. > Information: 0x4004300B at {05004535-2B97-4B58-906A-11E69AA53323}, > DTS.Pipeline: "component "OLE DB Destination" (2)" wrote 0 rows. > Information: 0x4004300A at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, > DTS.Pipeline: Validation phase is beginning. > Error: 0xC0047008 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > The package contains two objects with the duplicate name of "output column > "ErrorCode" (69)" and "output column "ErrorCode" (14)". > Error: 0xC0047008 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > The package contains two objects with the duplicate name of "output column > "ErrorColumn" (74)" and "output column "ErrorColumn" (15)". > Error: 0xC004706B at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > "component "OLE DB Source" (1)" failed validation and returned validation > status "VS_ISCORRUPT". > Error: 0xC004700C at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > One or more component failed validation. > Error: 0xC0024107 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}: There were > errors during task validation. > Error: 0xC00220DE at Execute Inner Package: Error 0xC0012050 while loading > package file "C:\Documents and Settings\wardte\Local > Settings\Temp\2\InnerPackage.dtsx". Package failed validation from the > ExecutePackage task. The package cannot run. > . > Task failed: Execute Inner Package > Task failed: CompensatingSql > SSIS package "Reporting_Database.dtsx" finished: Failure. > > > > > "Terry" wrote: > >> How can I determine what is causing the following package to fail? >> >> Error: Error 0xC0012050 while loading package file "C:\Documents and >> Settings\wardte\Local Settings\Temp\2\InnerPackage.dtsx". Package failed >> validation from the ExecutePackage task. The package cannot run. .
Allan. I'm getting a very similar error message when I build and run a
backup package through the wizard: 'Error : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (54)" and "output column "ErrorCode" (14)". helpFile=dtsmsg.rll ....' Your explanation below is a little cryptic. Can you elaborate more? Are you saying the backup package is corrupt? I'm building it from scratch every time, and I get the same error message. Are you saying the *db* is corrupt? That would be beyond painful. This *is* a db that was originally built in 2000 and the ported over. If I remember correctly, this was simply a matter of backing up the db from 2000 and then restoring in 2005. I don't exactly remember, though. Any help you can offer would be greatly appreciated. [quoted text, click to view] "Allan Mitchell" wrote:
> My investigation would start around here in your output > > Error: 0xC0047008 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > The package contains two objects with the duplicate name of "output column > "ErrorCode" (69)" and "output column "ErrorCode" (14)". > Error: 0xC0047008 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > The package contains two objects with the duplicate name of "output column > "ErrorColumn" (74)" and "output column "ErrorColumn" (15)". > Error: 0xC004706B at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > "component "OLE DB Source" (1)" failed validation and returned validation > status "VS_ISCORRUPT". > Error: 0xC004700C at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > One or more component failed validation. > Error: 0xC0024107 at {5C909D87 > > > From BOL VS_ISCORRUPT means > > The component is irreparably damaged and must be completely reset. The > designer calls the component's ProvideComponentProperties method in > response. > > -- > > > Allan Mitchell > Konesans Ltd > T +44 7966 476 572 > F +44 2071 008 479 > http://www.konesans.com > > > > "Terry" <Terry@discussions.microsoft.com> wrote in message > news:25235232-484B-47D2-B734-1771C6014203@microsoft.com... > > Here's the rest of the information: > > > > Information: 0x40043006 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > > DTS.Pipeline: Prepare for Execute phase is beginning. > > Information: 0x40043007 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > > DTS.Pipeline: Pre-Execute phase is beginning. > > Information: 0x4004300C at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > > DTS.Pipeline: Execute phase is beginning. > > Information: 0x402090DF at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, OLE DB > > Destination [2]: The final commit for the data insertion has started. > > Information: 0x402090E0 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, OLE DB > > Destination [2]: The final commit for the data insertion has ended. > > Information: 0x40043008 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > > DTS.Pipeline: Post Execute phase is beginning. > > Information: 0x40043009 at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > > DTS.Pipeline: Cleanup phase is beginning. > > Information: 0x4004300B at {A3C9B3E4-6629-433F-9456-37C2B8C7CF9F}, > > DTS.Pipeline: "component "OLE DB Destination" (2)" wrote 0 rows. > > Information: 0x4004300A at {05004535-2B97-4B58-906A-11E69AA53323}, > > DTS.Pipeline: Validation phase is beginning. > > Information: 0x4004300A at {05004535-2B97-4B58-906A-11E69AA53323}, > > DTS.Pipeline: Validation phase is beginning. > > Information: 0x4004300A at {05004535-2B97-4B58-906A-11E69AA53323}, > > DTS.Pipeline: Validation phase is beginning. > > Information: 0x40043006 at {05004535-2B97-4B58-906A-11E69AA53323}, > > DTS.Pipeline: Prepare for Execute phase is beginning. > > Information: 0x40043007 at {05004535-2B97-4B58-906A-11E69AA53323}, > > DTS.Pipeline: Pre-Execute phase is beginning. > > Information: 0x4004300C at {05004535-2B97-4B58-906A-11E69AA53323}, > > DTS.Pipeline: Execute phase is beginning. > > Information: 0x402090DF at {05004535-2B97-4B58-906A-11E69AA53323}, OLE DB > > Destination [2]: The final commit for the data insertion has started. > > Information: 0x402090E0 at {05004535-2B97-4B58-906A-11E69AA53323}, OLE DB > > Destination [2]: The final commit for the data insertion has ended. > > Information: 0x40043008 at {05004535-2B97-4B58-906A-11E69AA53323}, > > DTS.Pipeline: Post Execute phase is beginning. > > Information: 0x40043009 at {05004535-2B97-4B58-906A-11E69AA53323}, > > DTS.Pipeline: Cleanup phase is beginning. > > Information: 0x4004300B at {05004535-2B97-4B58-906A-11E69AA53323}, > > DTS.Pipeline: "component "OLE DB Destination" (2)" wrote 0 rows. > > Information: 0x4004300A at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, > > DTS.Pipeline: Validation phase is beginning. > > Error: 0xC0047008 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > > The package contains two objects with the duplicate name of "output column > > "ErrorCode" (69)" and "output column "ErrorCode" (14)". > > Error: 0xC0047008 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > > The package contains two objects with the duplicate name of "output column > > "ErrorColumn" (74)" and "output column "ErrorColumn" (15)". > > Error: 0xC004706B at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > > "component "OLE DB Source" (1)" failed validation and returned validation > > status "VS_ISCORRUPT". > > Error: 0xC004700C at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}, DTS.Pipeline: > > One or more component failed validation. > > Error: 0xC0024107 at {5C909D87-0DA3-47F1-83B5-2FC49ABD6DAC}: There were > > errors during task validation. > > Error: 0xC00220DE at Execute Inner Package: Error 0xC0012050 while loading > > package file "C:\Documents and Settings\wardte\Local > > Settings\Temp\2\InnerPackage.dtsx". Package failed validation from the > > ExecutePackage task. The package cannot run. > > . > > Task failed: Execute Inner Package > > Task failed: CompensatingSql > > SSIS package "Reporting_Database.dtsx" finished: Failure. > > > > > > > > > > "Terry" wrote: > > > >> How can I determine what is causing the following package to fail? > >> > >> Error: Error 0xC0012050 while loading package file "C:\Documents and > >> Settings\wardte\Local Settings\Temp\2\InnerPackage.dtsx". Package failed > >> validation from the ExecutePackage task. The package cannot run. . > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |