Transfer csv file to oledb (SSIS Programming in c#)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by U.K Padmaja » Transfer csv file to oledb (SSIS Programming...

Transfer csv file to oledb (SSIS Programming in c#)

Rate Topic

Display Mode

Topic Options

Author

Message

paririps

Posted Tuesday, February 05, 2008 12:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 08, 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 »

Permissions