I am getting the following messages when writeing data in a dataflow to an updates table, that had been truncated in a previous SSIS step in the same package.
Error: 0xC0202009 at DF - Main, OLE DB Dest - Dim Customer Temp [345]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007000E.
Error: 0xC020204A at DF - Main, OLE DB Dest - Dim Customer Temp [345]: Unable to retrieve column information from the data source. Make sure your target table in the database is available.
Error: 0xC004701A at DF - Main, SSIS.Pipeline: OLE DB Dest - Dim Customer Temp failed the pre-execute phase and returned error code 0xC020204A.
The table does exist, (I created it a few days ago) the package is running in Visual Studio 2010 against a SQL Server 2012 database. The database is up and running and I can access the table bot before and after running the package. The SSIS connection is running under windows authorisation, using my userid/session.
I've been writing SSIS packages since DTS days and have never seen a case where the package could not retrieve meta data, while running, for a table before. Any thoughts.
Note I can go into the OLEDB DB Destination and bring up the columns and prieview the data before running the package in debug mode, where it fails.
Any thoughts?
I have changed the OLE DB provider and issue was resolved.
User contributions licensed under CC BY-SA 3.0