Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Trying insert long data into OLEDB to excel Expand / Collapse
Author
Message
Posted Wednesday, February 26, 2014 2:42 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:47 AM
Points: 2,296, Visits: 1,427
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.
Post #1545280
Posted Wednesday, February 26, 2014 8:11 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
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; They'll drag you down to their level and beat you with experience"
Post #1545425
Posted Thursday, February 27, 2014 1:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:47 AM
Points: 2,296, Visits: 1,427
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.
Post #1545751
Posted Thursday, February 27, 2014 6:31 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
Can you attach an example of the data in a flat file to this thread?

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1545839
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse