Error: 0xC002F304 At Bulk Insert Task, Bulk Insert Task: An Error Occurred With The Following Error Message: Cannot Fetch A Row

Apr 8, 2008


I receive the following error message when I try to use the Bulk Insert Task to load BCP data into a table:


Error: 0xC002F304 at Bulk Insert Task, Bulk Insert Task: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.The bulk load failed. The column is too long in the data file for row 1, column 4. Verify that the field terminator and row terminator are specified correctly.Bulk load data conversion error (overflow) for row 1, column 1 (rowno).".

Task failed: Bulk Insert Task

In SSMS I am able to issue the following command and the data loads into a TableName table with no error messages:
BULK INSERT TableName
FROM 'C:DataDbTableName.bcp'
WITH (DATAFILETYPE='widenative');


What configuration is required for the Bulk Insert Task in SSIS to make the data load? BTW - the TableName.bcp file is bulk copy file as bcp widenative data type. The properties of the Bulk Insert Task are the following:
DataFileType: DTSBulkInsert_DataFileType_WideNative
RowTerminator: {CR}{LF}

Any help getting the bcp file to load would be appreciated. Let me know if you require any other information, thanks for all your help.
Paul

View 1 Replies


ADVERTISEMENT

Cannot Fetch A Row From OLE DB Provider BULK With Bulk Insert Task

Nov 23, 2005

Hi, folks:

View 18 Replies View Related

Bulk Insert Task - Error File

Oct 11, 2007

Using BCP or BULK INSERT you can specify an Error File (-e and ERRORFILE). However this does not seem to be exposed in SSIS via the Bulk Insert Task.

Does anyone know if I'm missing something and the Property is called something else or if can be accessed via script?

Cheers,

-Ryan

View 1 Replies View Related

BULK INSERT ERROR Using Format File - Bulk Load Data Conversion Error

Jun 29, 2015

I'm trying to use Bulk insert for the first time and getting the following error. I think it might have something to do with my Format File and from the error msg there's a conversion error for the first column. In my database the Field is nvarchar(6) so my best guess is to use SQLNChar for the first column. I've checked the end of each line is CR LF therefore the is correct for line 7 right?

Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 1, column 1 (ASXCode).
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

BULK
INSERTtbl_ASX_Data_temp
FROM
'M:DataASXImportTest.txt'
WITH
(FORMATFILE='M:DataASXSQLFormatImport.Fmt')

[code]...

View 5 Replies View Related

[File System Task] Error: An Error Occurred With The Following Error Message: Access To The Path Is Denied

Sep 7, 2007

Hi -

I have an File System Task that copies a file from one directory ot another. When I hard code the target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:

[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".

Where do I change the security settings?

Thanks - Grace

View 5 Replies View Related

[XML Task] Error: An Error Occurred With The Following Error Message: There Are Multiple Root Elements.

Aug 18, 2006

I'm trying to use an XML Task to do a simple XSLT operation, but it fails with this error message:

[XML Task] Error: An error occurred with the following error message: "There are multiple root elements. Line 5, position 2.".

The source XML file validates fine and I've successfully used it as the XML Source in a data flow task to load some SQL Server tables. It has very few line breaks, so the first 5 lines are pretty long: almost 4000 characters, including 34 start-tags, 19 end-tags, and 2 empty element tags. Here's the very beginning of it:

<?xml version="1.0" encoding="UTF-8"?>
<ESDU releaselevel="2006-02" createdate="26 May 2006"><package id="1" title="_standard" shorttitle="_standard" filename="pk_stan" supplementdate="01/05/2005" supplementlevel="1"><abstract><![CDATA[This package contains the standard ESDU Series.]]></abstract>

There is only 1 ESDU root element and only 1 package element.

Of course, the XSLT stylesheet is also an XML document in its own right. I specify it directly in the XML Task:

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"/>

<xsl:template name="identity" match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>

<xsl:template match="kw">
<xsl:copy>
<xsl:apply-templates select="@*"/>
<xsl:attribute name="ihs_cats_seq" select="position()"/>
<xsl:apply-templates select="node()"/>
</xsl:copy>
</xsl:template>

</xsl:stylesheet>


Its 5th line is the first xsl:template element.

What is going on here? I do not see multiple root elements in either the XML document or the XSLT stylesheet.

Thanks!

View 5 Replies View Related

How Do You Use An Identity Column When Doing A Bulk Insert Using The Bulk Insert Task Editor

Apr 18, 2008



Hello,

I'm just learning SSIS and I've hit my first bump. I am doing a bulk import from a tab delimited text file to an empty sql table that has a Idendity column defined. How do I tell the bulk insert task to skip that column when inserting from the text file. If I remove the identity column it imports the data fine, but I want to create the indentity column in the table too.

Thanks.

View 8 Replies View Related

Bulk Insert - Bulk Load Data Conversion Error

Jan 17, 2008

Im having some issues with bulk insert.

This is the table:

CREATE TABLE [dbo].[tmp_GA_status](

[GA_recno] [int] NOT NULL,

[GA_desc] [varchar](40) NULL

)


This is the file (unicode):
1|"test1"
2|"test2"
3|"test3"
4|"test4"
5|"test5"
6|"test6"
7|"test7"
8|"test8"


and this is the sql:

bulk insert tmp_GA_status from 'C: empTextDumpGA_status.dta'

with (CODEPAGE='RAW', FIELDTERMINATOR='|', ROWTERMINATOR='
', DATAFILETYPE='widechar')



so yeah, pretty simple. But whatever I do I get this;

Msg 4864, Level 16, State 1, Line 1

Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 2 (GA_desc).



So what am I doing wrong ?

View 13 Replies View Related

Bulk Insert Using Script And Not Bulk Insert Task

Nov 2, 2007



Does anyone know how to do a bulk insert using just the script task? I've been searching everyehere but can't seem to find a sample.

View 6 Replies View Related

Exec Pkg Task: Error 0xC0202009 While Preparing To Load The Package. An OLE DB Error Has Occurred. Error Code: 0x%1!8.8X!.

Feb 21, 2007

I cannot execute a package by using Execute Package task.
I supplied sa credentials to connection manager, and it shows the list of Packages on SQL Server but when running the task it says

Error 0xC0202009 while preparing to load the package. An OLE DB error has occurred. Error code: 0x%1!8.8X!.



Any clue ?


Thanks,
Fahad

View 1 Replies View Related

DTS Bulk Insert Task

Jan 12, 2001

I am using the Bulk Insert task object in DTS and I am using a format file as well to import data from a text file. I was able to insert data into my SQL table fine when I did not have a identity column defined in my table; however, I added a identity field and now the bulk insert will not work. Anyone had a similiar problem?

The error msg box that pops up says:

The statement has been terminated.
string or binary data would be truncated.

View 1 Replies View Related

Order By On Bulk Insert Task

Aug 23, 2007

I want to check sorted data option for bulk insert task on DTS Package. I want to sort data on 1st column. How can I put order by clause on sorted data option? I put ORDER (SSNo) but I am getting error.
Thanks
ss

View 4 Replies View Related

Heavy Bulk- Insert Task

Jan 18, 2008

I am doing heavy Bulk insert task to one Database.When i checked the Activity Monitor I saw it was suspended and Wait type:PAGEIOLATCH_EX
So it stopped itself.Do any experts have good idea about what is going on?

Appreciate for help

View 17 Replies View Related

Null - Bulk Insert Task

Jun 5, 2007

Dear All,

For ex:
In SQL Server 2005 when we create table with 3 columns which has allow nulls option is disabled. Then we try to insert record with blank to any one of the column SQL server throws error, coz column name is NOT Null without inserting data it won't saves the record.
When we try to import a csv data file has 3 columns & has null data. If we use BULK INSERT TASK option, it easily inserts the data, without throwing error.

My question is how can we restrict null data without inserting it into the table using BULK INSERT TASK using SQL Server 2005.

Please suggest me to solve this issue.

Thanks in advance
Karna

View 5 Replies View Related

Bulk Insert Task - Where Does The First Row Begin?

Jan 25, 2007

Hi,

I am using the Bulk Insert Task to bulk copy data from a flat file to a SQL Server 2005 table. The flat file contains pipe ( | ) delimited columns and several thousand records which are {CR}{LF} delimited. The file also contains a header record and trailer record, which contain several words but also contains a ( | ) symbol among those words.

E.g.:

HEDR | yadi yadi yada500 | Data Data | More Data | 600460 | Datum | More More | 705550 | Data | Data | 603FOOTR | yadi yadi yada


I need to ignore the header and trailer records and just pickup the proper records. But even though I manually set the First Row property to 2 and the Last Row property to 4, It does not pickup the first true record i.e. the record which begins with 500, and if I set the First Row to 1, it throws me an error citing 'truncation error' or similar. I think it is taking the first record (i.e. header row along with the first row as one, and since there are now more pipes ( | ) the error is thrown)

I've tried setting different values for these properties but to no avail... Any help will be deeply appreciated...

Thanks
Gogula

View 3 Replies View Related

SSIS Bulk Insert Task

Sep 19, 2006

i need to do a bulk insert for every csv file from a particular folder & i wish to do this programatically.

i hav tried a "foreach" loop & using variables for the filenames but it doesnot seem to be working & i just cant figure out why !!

View 3 Replies View Related

Ssis Bulk Insert Task

Aug 28, 2006

hi,

i have a bulk insert task and i want to transfer to the source connection each time a different

text file name. how do i transfer to the connection source field a parameter with a new name

each time. the name will b excepted as a parameter to the package. can i do it in a bulk insert

task?

thx,

Tomer

View 4 Replies View Related

Error When Doing A Bulk Insert

Oct 8, 1999

I'm doing a bulk insert from a text file to sql server 7
I'm getting an error:

Server: Msg 4867, Level 16, State 1, Line 1
Bulk insert data conversion error (overflow) for row 1, column 169 (LOT_WIDTH).
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
The statement has been terminated.

Now my lot-width field coming in is defined as a numeric 9(5).
My table is defined as an INT.

Any suggestion? I'm new to SQL7

Thanks

Jason

View 1 Replies View Related

BULK INSERT Error

Jan 9, 2007

Hello SQLTEAM

I have a flat fix length file...

H315620060417
H315620060417

I have a format file

8.0
2
1 SQLCHAR 0 5 "" 4 MCO_Number SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 8 "
" 5 Run_Date SQL_Latin1_General_CP1_CI_AS

I get the following BULK INSERT

"BULK INSERT data conversion error (truncation) for
row 1, column 1 (MCO_Number).

Columns in destination table are nvarchar (5) and nvarchar (8). I have tried using "
" and "" as row terminators.

Any help appreciated.

View 1 Replies View Related

Bulk Insert Eof Error

Sep 6, 2007

I am attempting to bulk insert a comma delimited text file with double quotes as the text qualifier but I keep getting an error message(EOF) on the bulk insert.

I think the problem lies in my format file (see below)

Please take a look and let me know what I am missing?

Thanks,
Matt


Error message:
Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

Format File:
8.0
19
1 SQLCHAR 0 0 """ 0 first_quote SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 0 "","" 1 nt_id SQL_Latin1_General_CP1_CI_AS
3 SQLCHAR 0 0 "","" 2 first_name SQL_Latin1_General_CP1_CI_AS
4 SQLCHAR 0 0 "","" 3 last_name SQL_Latin1_General_CP1_CI_AS
5 SQLCHAR 0 0 "","" 4 department SQL_Latin1_General_CP1_CI_AS
6 SQLCHAR 0 0 "","" 5 phone SQL_Latin1_General_CP1_CI_AS
7 SQLCHAR 0 0 "","" 6 mgmt_level SQL_Latin1_General_CP1_CI_AS
8 SQLCHAR 0 0 "","" 7 emp_id SQL_Latin1_General_CP1_CI_AS
9 SQLCHAR 0 0 "","" 8 rc SQL_Latin1_General_CP1_CI_AS
10 SQLCHAR 0 0 "","" 9 subrc SQL_Latin1_General_CP1_CI_AS
11 SQLCHAR 0 0 "","" 10 location SQL_Latin1_General_CP1_CI_AS
12 SQLCHAR 0 0 "","" 11 floor SQL_Latin1_General_CP1_CI_AS
13 SQLCHAR 0 0 "","" 12 supervisor_id SQL_Latin1_General_CP1_CI_AS
14 SQLCHAR 0 0 "","" 13 status SQL_Latin1_General_CP1_CI_AS
15 SQLCHAR 0 0 "","" 14 hiredate SQL_Latin1_General_CP1_CI_AS
16 SQLCHAR 0 0 "","" 15 jobtitle SQL_Latin1_General_CP1_CI_AS
17 SQLCHAR 0 0 "","" 16 paygrade SQL_Latin1_General_CP1_CI_AS
18 SQLCHAR 0 0 "","" 17 id SQL_Latin1_General_CP1_CI_AS
19 SQLCHAR 0 0 ""
" 18 email SQL_Latin1_General_CP1_CI_AS

View 11 Replies View Related

Bulk Insert Error

Feb 28, 2008

My server updated from SQL2000 to SQL2005, SP2.

I found error in bulk insert: -
"Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator and row terminator are specified correctly.".

I do read a few article saying that after apply SP2 and hotfixes, this error should be fix, but unfortunately, it is not in my case, what should i do to fix it?

This is my script: -
BULK INSERT wng01_work..nw_business_person FROM 'g:SQLFTPCDIS_Extractew_worker.dat'
WITH
(
MAXERRORS = 1,
FORMATFILE ='g:sqlftpcdis_extractew_work.fmt'
)

Please advice, Thank you

View 4 Replies View Related

Error Msg 141 On Bulk Insert

Jun 5, 2006

I've got the following SP to automatically insert all files in a directory into the database:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE Imp_Header_PO_sp

@FilePath varchar(1000) = 'D:EBTOutbound',

@WIPPath varchar(1000) = 'D:EBTOutboundWIP',

@ArchivePath varchar(1000) = 'D:EBTOutboundArchive',

@FileNameMask varchar(1000) = '*Header.txt'

AS

BEGIN

SET NOCOUNT ON;

declare @Filename varchar(1000),

@File varchar(1000)

declare @cmd varchar(2000)

create table #Dir (s varchar(8000))

-- Move Header files to WIP

select @cmd = 'move ' + @FilePath + @FileNameMask + ' ' + @WIPPath

select @cmd = 'dir /B ' + @WIPPath + @FileNameMask

delete #Dir

insert #Dir exec master..xp_cmdshell @cmd

delete #Dir where s is null or s like '%not found%'

-- Import file



while exists (select * from #Dir)

begin

select @FileName = min(s) from #Dir

select @File = @WIPPath + @FileName

select @cmd = 'bulk insert'

select @cmd = @cmd + ' POWebOutHeader'

select @cmd = @cmd + ' from'

select @cmd = @cmd + ' ''' + replace(@File,'"','') + ''''

select @cmd = @cmd + ' with (Fieldterminator = ',')'

-- Import the data

exec (@cmd)

-- remove filename just imported

delete #Dir where s = @FileName

-- Archive the file

select @cmd = 'move ' + @WIPPath + @FileName + ' ' + @ArchivePath + @FileName

exec master..xp_cmdshell @cmd

end

drop table #Dir

END

GO

When I try to execute the code, I get the following error, on this line: select @cmd = @cmd + ' with (Fieldterminator = ',')'

Msg 141, Level 15, State 1, Procedure Imp_Header_PO_sp, Line 46

A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

I've tried to find a fix for this error, but it seams to only relate to a select statement and not a Bulk Insert. Can someone please help me figure out how to fix this error?

Thanks,

Laura

View 5 Replies View Related

Bulk Insert Error

Apr 30, 2007

Simple test project. Created Flat File connection, database connection (both local), and Bulk Insert Task. When running the package I get the following error:

[Bulk Insert Task] Error: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.Bulk load: An unexpected end of file was encountered in the data file.".

I've tried different settings for the Flat File config, and the database connection, but still get the error. Any suggestions would be helpful.

Tks.

View 4 Replies View Related

Bulk Insert Error

Jun 26, 2006

Hi,

I am using bulk insert to insert a lot of information from file to memory. In many cases it do the work but in one place it gives me the exception.

My code:

BULK INSERT tblCompVSNet1 FROM 'E:EasySeriesWindowsApplication1inDebug blCompVSNet1.tbl' WITH ( FIELDTERMINATOR = '|',ROWTERMINATOR = '|',LASTROW = 0,ROWS_PER_BATCH = 10000,CODEPAGE = 'RAW',TABLOCK)

The error:

Invalid object name 'tblCompVSNet1'

The table exists and the query works fine in query analyzer but in code through OLEDB it doesn't work sometimes.

How can I solve my problem?

Thank's
Alexei

View 6 Replies View Related

DTS Bulk Insert Task Date Problem?

Mar 16, 2004

Really Don't understand this and have run out of hair to pull out.

DTS package whihc has a Bulk Insert Task. The task is populated with its source filename dynamically. It has a format file which is stored locally to the box its running on.

The output file is from a unix box pipe delimited. Great dandy. All works a treat as long as I treat everything as either an INT or CHAR. But I have a couple of columns that are DATES in the format 13/02/2004.

I want these inserted into smalldatetime columns. Will settle for datetime columns though.

I get an error on every row Bulk Insert data conversion error (type mismatch) for Row X Column 11 (PostingDate) which happens to be the first date column.

Tried loading it as CHAR, SQLDATETIME and SQLDATETIM4 in the format file all to no avail. TRied it with columns in the dest table as DATETIME and SMALLDATETIME

Anyone have any ideas?

View 9 Replies View Related

Validation Problem Bulk Insert Task

Jan 28, 2008

Hi,

I use a "Bulk Insert Task" inside of a "ForEach Container" and set the ConnectionString-Property of the "FlatFile-ConnectionManager" with an expression, pulling from a variable.
The packages works fine, but I get an Error-Message in the Output-Window:

Fehler: 0xC001401E bei Package, Verbindungs-Manager 'FlatFile': Der in der Verbindung angegebene Dateiname 'c:old.txt' war ungültig.

Translation:


Error: 0xC001401E at Package, Connection-Manager 'FlatFile': Cannot open the file 'c:old.txt'.
(Sorry, in this office is the no english version available).

'C:old.txt' is the initial value of the variable.
The new value is 'C:ew.txt' and I can see the new value in the Debugger or in a Scripttask.

Before the execution of the "Bulk Insert Task" starts, SSIS makes a validation. I have tried to stop the validation on setting the property "DelayValidation" = True (Package,ForEach-Container,BulkInsert-Task,FlatFile-ConnectionManager), but it is not possible to stop the validation and the error-message.
After printing the error-message, the variable is evaluated and the package works fine. After the first loop, there is no more error-message.

The error-message is a problem, because the operators look at the error-output.

As a workaround I can set the property in a Scriptatsk. Is there another solution????

Dan has a blog to this problem, but no solution:

http://www.developerdotstar.com/community/node/347



Thanks

Berthold Neumann

View 7 Replies View Related

Rowcount From A Bulk Insert Task In SSIS

Oct 5, 2006

I would like to get the rowcount from a bulk insert task to validate that all the data is being inserted correctly. So far the only way that I can see this being done is through a trigger on the target tables. I would like to have this information inside the DTS package. Can anyone help me?



Thanks

View 3 Replies View Related

Bulk Insert Task COnfusion In SSIS??

Apr 15, 2008

Hi, ALL





I have a confusion with Bulk Insert task for several days.
Here is what Books Online say, which i totally understand---
"The source file that the Bulk Insert task loads can be on the same server as the SQL Server database into which data is inserted, or on a remote server. If the file is on a remote server, you must specify the file name using the Universal Naming Convention (UNC) name in the path."

Now, If my Bulk Insert task (within a package) is on one server, say ETL ( so when i run the package, it will run from ETL server); but, My destination table where data will be inserted, is in another server, say PROD. So, My OLEDB connection will be pointing to a remote server .Now, If my text file is on ETL server, do i have to give UNC path?..Or If i have text file on the same server as my destination ( here PROD) do i Have to Give UNC naming?. I found in several places that Bulk insert Task runs on that server where its connections points to.
My scnerio: I have multiple SSIS packages. Now These packages will be on ETL server, but all the databases will be hosted on PROD server. Now for my Bulk Insert , I asked them to keep all flat file on ETL server(where packages will be ). Looks like this will give me a problem later, since all my Destination will be on PROD server, during bulk insert , sql server will go and look for those files on PROD server rather than ETL server? Or i AM confused here?......
Say package.dtsx is On SER1which useses bulk insert tasks..
My OLEDB connection is SERV2 database B and Table T
Now my flat file connection is D:myfilefile.txt

Now when i run this task where does these txt file will be pulled from. Does it pulls from local server (SER1) or does it goes to SERV2 looking for txt file.

I tried several combinations of moving files to different servers, yet i have no conclusions.

Thanks, Kumar

View 1 Replies View Related

File Could Not Be Opened In Bulk Insert Task

Apr 2, 2007

hi



with my ssis-package i have to read several flatfiles. this files are stored in different folders on a unix machine. in my loop-task i have first a script, that checks whether the file exists. it does, so i set the path to a variable. in the connection-manager for the flat-file i have set source for the file to that variable. the bulk-insert-task starts, read the file and everithing is cool. but, sometimes, the package fails with this message:



[Bulk Insert Task] Error: An error occurred with the following error message:
"Cannot bulk load because the file "\Owpu0kas005
eceivedw000005.090"
could not be opened. Operating system error code 53(error not found)."



i stop the degugging-mode, restart debuging and what happens? it runs ... maybe for the next one, two or three files and the error comes again, but never on the same file. i'm going crazy, what can i do?



thanks for your help.

View 3 Replies View Related

Bulk Sql Insert Task Can Do Tables With Identity?

Mar 23, 2006

 

 

 i got some bulk insert tasks in SSIS inserting into some tables with identity set ON....

in 1 column. Can the bulk insert task go smoothly?

 PS: i cannot find anywhere in the bulk insert task that can set the ignore identity columns...........

 

 

now my steps are prepare database -> create database -> bulk insert into tables

working on my previous problem, Jamie.

View 1 Replies View Related

Bulk Insert Returning Error

Apr 13, 2000

Help! I am importing a large comma delimited text file into an existing table useing the BULK INSERT command. The table is 4 colums (char16, char16, varchar50, char1). The first 100 or so lines go in without an error. then, I recieve an error stateing that an entry is too long for the field in the database, and kicks me out. The entry is 50 characters, which is allowed. Any ideas why this would happen?

View 1 Replies View Related

Bulk Insert Error...Urgent.

Oct 23, 2000

I am using the following bulk insert statement:

bulk insert DB_Kash.dbo.tb_category
from 'C:cpdataSUPPLIER_5305OUTPUTTb_Category.txt'
with (formatfile = 'C:b_category.txt')

This works on one sql server and the same code does not work on another server.I have taken care to see that the path is appropriate.
Are there any server settings involved?
The table structure is the same in both cases and the select into nulk copy option has been selected.
The table has full text indexing set on it but I don't think that this would make any difference.
The only error it gives is "ILE DB Stream reported an error.The stream does not provide any expalanation regarding this error." Something like this.

Infact the same format file and datafile work fine when I am doing BCP.
I have tried with select into bulk copy option on and off too.
Any info on this is greatly appreciated.

thanks
Sush.

View 1 Replies View Related

Capturing Bulk Insert Error

May 26, 2004

Hi,
Can someone help me out with capturing the bulk insert error.I have a job which calls a procedure in which I used the bulk insert command .If the bulk insert is failing due to some reason as wrong delimitor,wrong path etc then the job fails.I need to track that error and see that the job doesnt stop and goes onto the next cursor record.
Thanks,
Nodbek

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved