Just noticed that include is different.

Seems I was able to figure out the problem. Added MaximumErrorCount = 100 for Loop Container and it doesn't stop now.

It doesn't work for me. I checked StopOnFailure = False. FTP task becomes...

Edward C Smith (7/5/2007)

I read your post as I'm trying to do something similar. I have a large repository of what appear to be paradox table files from our...

Any ideas?

Here is the table:

IF OBJECT_ID('tBufOMIM') IS NULL

BEGIN

CREATE TABLE tBufOMIM (

NOINT NOT NULL PRIMARY KEY,

TIVARCHAR(MAX)NULL,

TXVARCHAR(MAX)NULL,

SAVARCHAR(MAX)NULL,

CSVARCHAR(MAX)NULL,

CNVARCHAR(MAX)NULL,

RFVARCHAR(MAX)NULL,

CDVARCHAR(MAX)NULL,

EDVARCHAR(MAX)NULL,

MNVARCHAR(MAX)NULL,

AVVARCHAR(MAX)NULL

)

PRINT 'Table tBufOMIM was created'

END

GO

Format file:

<BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<RECORD>

<FIELD ID="1" xsi:type="CharTerm" TERMINATOR="*RECORD**FIELD* NO"/>

<FIELD...

As it turned out, some fields can have null values. So, the correct sample will be:

*RECORD*

*FIELD* NO

1

*FIELD* TI

...

*FIELD* TX

...

*RECORD*

*FIELD* NO

2

*FIELD* TI

...

*FIELD* TX

...

*FIELD* CN

...

*THEEND*

I've tried to make a format file...