February 26, 2014 at 2:42 am
Hi,
I am trying to insert data from SQL to excel destination,but I am getting error as below:I have tried many ways but no luck.This is urgent requirement ,can any one help me asap.
[Excel Destination [156]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
[Excel Destination [156]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
[SSIS.Pipeline] Error: component "Excel Destination" (156) failed the pre-execute phase and returned error code 0xC0202025.
February 26, 2014 at 8:11 am
Check your Flat File Connection Manager, make sure you've specified the appropriate data types and lengths for the fields you are mapping into Excel.
If you've not done it this way and in your Data Flow task are directly mapping your SQL Server data into an Excel Destination, you may need to add a Data Conversion task to convert the data types (you could receive an error stating you cannot convert between unicode and non-unicode string data types)
Just a shot in the dark, but hard to tell without seeing your project...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 1:25 am
Hi,
i am inserting large procedures and queires into the execl sheet.due to procedures length issue it is not fitting in the excel sheet.
February 27, 2014 at 6:31 am
Can you attach an example of the data in a flat file to this thread?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply