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

Transfer csv file to oledb (SSIS Programming in c#) Expand / Collapse
Author
Message
Posted Tuesday, February 5, 2008 12:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 8, 2008 4:00 AM
Points: 3, Visits: 34
Hi , i m trying to tansfer csv file into sql sever 2005 database

it was giving me an error at



managedOleInstance.AcquireConnections(null);



and my application stops working!! And package did not get generated !



So I have commented that line !

Then it give me an error at this line



managedFlatFileInstance.ReinitializeMetaData();



so have commented all lines that called



AcquireConnections(null);

ReinitializeMetaData();



So now my package gets generated but it gives me an error



it gives error that output column is not synchronized with externalmetadata column..

Column "Name" has to be added to the externalmetadatacolumn
Column "Age" has to be added to the externalmetadatacolumn
Column "JoinDate" has to be added to the externalmetadatacolumn
Column "salary" has to be added to the externalmetadatacolumn
column "Retierd" has to be added to the externalmetadatacolumn





Post #451467
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse