Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Exporting Data from SQL2005 to Access using the SQL Server Agent

Avatar of cErasmus
cErasmusFlag for Namibia asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
5 Comments1 Solution326 ViewsLast Modified:
Hi Experts,

I have created a package(SSIS) with multiple Data Flow Tasks, I run this package through the SQL Server Agent everyday. Today the package failed after 4min at a Data Flow Task that's almost at the finish of the pakage. I restarted the job and it failed within 6seconds, the error I got is:

Code: 0xC0202009     Source: AllSuppliers OLE DB Destination [351]     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.  End Error  Error: 2008-07-09 09:54:32.19     Code: 0xC0209029     Source: AllSuppliers OLE DB Destination [351]     Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "input "OLE DB Destination Input" (364)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (364)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.  End Error  Error: 2008-07-09 09:54:32.19     Code: 0xC0047022     Source:...  The package execution fa...  The step failed.

What the Data Flow Tasks do is to send SQL Tables to Access, the first step of the Package is to clean all the Tables in Access.

What causes this unexpected problem?
Avatar of cErasmus
cErasmusFlag of Namibia image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answers