BULK INSERT in SSIS 2008

  • 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

  • This was removed by the editor as SPAM

  • 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...

  • This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply