May 20, 2008 at 4:24 am
I am trying to generate Excel documents from SQL DB 2005 using SSIS packages. I created a schedule, which works fine when it runs every 5 minutes etc, but it stops when I change back frequency to once a day. Schedule works only once, and second day not with following error code:
Code: 0xC0202009 Source: Data Flow Task Destination - Query [22] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37. End Error Error: 2008-05-20 10:43:01.46 Code: 0xC02020E8 Source: Data Flow Task Destination - Query [22] Description: Opening a rowset for "Query" failed. Check that the object exists in the database. End Error Error: 2008-05-20 10:43:01.46 Code: 0xC004701A Source: Data Flow Task DTS.Pipeline Description: component "Destination - Query" (22) failed the pre-execute phase and returned error code 0xC02020E8. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:43:00 AM Finished: 10:43:01 AM Elapsed: 0.609 seconds. The package execution failed. The step failed.
I will appreciate any idea and help.
/Saban
May 21, 2008 at 1:18 pm
I found the following doing a search for your error code:
http://gps678.com/21/18812c397bfe53f4.html
http://wiki.sqlis.com/default.aspx/SQLISWiki/0xC02020E8.html
It appears to be a problem with the destination file, not the source as the error makes it sound.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply