August 10, 2010 at 5:49 am
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
August 10, 2010 at 12:09 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply