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

• paririps

  SSC Journeyman

  Points: 95

  More actions

  February 5, 2008 at 12:07 am

  #186195

  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