BULK INSERT in SSIS 2008

• patelbadri

  SSC Journeyman

  Points: 88

  More actions

  August 10, 2010 at 5:49 am

  #387541

  I am trying to use BULK insert in stored procedure and invoking stored procedure from the Execute SQL Task in SSIS.

  Below is the syntax i used

  BULK INSERT TBALE_NAME FROM '\\Server_Name\Complete_Path\FileName.txt' WITH (

  FIELDTERMINATOR = '|',

  ROWTERMINATOR = '|',

  LASTROW = 0,TABLOCK

  )

  I am getting below exception

  Error: 7330, Severity: 16, State: 2

  My file is not remove server and running SSIS package on sql server.

  This SSIS package works fine when I have few rows of data in text file but when my file does not have any data( contains only one character '|'), I am getting exception.

  Please help

  Thanks in Advance

• August 10, 2010 at 7:14 am

  This was removed by the editor as SPAM

• patelbadri

  SSC Journeyman

  Points: 88

  More actions

  August 10, 2010 at 12:09 pm

  #1204952

  that was my typo. Row terminator is '|'

  syntax I have used in my stored procedure is as below

  BULK INSERT TBALE_NAME FROM '\\Server_Name\Complete_Path\FileName.txt' WITH (

  FIELDTERMINATOR = '|',

  ROWTERMINATOR = '|',

  LASTROW = 0,TABLOCK

  )

  I have not used data flow task because this code is in stored procedure and I am simply converting DTS packages to SSIS 2008.

  Thanks for you response.

  waiting for response...

• August 10, 2010 at 11:53 pm

  This was removed by the editor as SPAM