Import Flat file to sql server programmatically

Import Flat file to sql server programmatically

• DevDiver

  Don't map a column to the identity column in the table. Leave it out.
  
  For instance, in terms of SQL this won't work:
  
  insert into table (ID, Description) values (1,'Row1');
  
  But this will:
  
  insert into table (Description) values ('Row1');
  
  So in your package, don't map a data flow field to the identity column.
  
  
  

• IamWasim

  Hi,

  i have created a package successfully to import flat file. i got some error while i am importing fixedwidth textfiles. The error is,

  No column was specified to allow the component to advance through the file.
  component "Flat File Source" (1) failed the pre-execute phase and returned error code 0xC02020F0.

  and my text file data like this,

  00001234561195469 040000 0000 7674491234 47674491234 211252901209030000199804130128431998041301292900003800IXCRD1

  
  00001234568002251234 0400234096321234 0000 8002251234 09782251234 111170401218830000199804130634501998041305345900000400IXCRD1

  can anybody give me a solution

  Thanks & regards,

  sivani

  
  

• shekhar saran

  Hi,

  Thanks for your reply. i want it to do programmatically. Give me some sample code in vb.net to igmore the identity column.

  regards,

  sivani

  
  

• bazad

  Did you find an anwer to your question

  Jay

  
  
  

• Jake52

  Yes, Finally i found the solution

  Jayanthi.

  
  

• Cliff hewett

  Sivani wrote:

  Hi, Thanks for your reply. i want it to do programmatically. Give me some sample code in vb.net to igmore the identity column. regards, sivani

  
  
  I don't understand. Don't do anything with the identity column. Leave it out/alone.
  
  
  
• Import Flat file to sql server programmatically