Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Error 0xc0202009: Data Flow Task 1: SSIS

Author  Topic 

jim_jim
Constraint Violating Yak Guru

306 Posts

Posted - 2010-05-27 : 16:40:31
Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unspecified error".

The Above is the error message I keep getting repeatedly when Iam trying to import to a table from csv files and excel files.Iam able to load them to a test table which has no constraints

Need Help
   

- Advertisement -