noeid,

I have contact MS Support - they have indicated a 'Bug' -- we'll see what the work-around will be.

thanks for all your help yesterday

mb

mdaniel,

SQL 2000 - Standard Edition // (SP2)

I did as you explained in 'setting source row errors', but when I try to 'Apply', I get the DTS Designer Error - "Invalid...

noeId,

1)Yes, I am running a script -

'**********************************************************************

'  Visual Basic Transformation Script

'************************************************************************

'  Copy each source column to the destination column

Function Main()

Dim SC

Dim col1Id

SC = DTSSource("Col001")

 If isDate(SC) then

  DTSDestination("fld06") = DTSSource("Col011")

  DTSDestination("fld05") =...

mdaniel,

If I process the 49500 row alone - everything is fine - process as expected.

There is no difference between the 49499 row and the 49500 in regards to special characters.

mb

noeId,

I'm not really sure of how to go about that, but what I can tell you is that if I take the file and make it 49,499 rows it process...

mdaniel,

Here is the error message I get when the file is over 49,500 rows - what I have been doing is splitting the file in have and then processing -...

noeId,

I just checked, and maxError = 0, fetchBuffer Size = 1, firstRow = 0 and lastRow = 0 - which I belive are all default settings.  Do you have any ideas...

quote:

---

Something like this maybe?

declare @startV15 datetime, @endV15 datetime, @currentV15 datetime



set @startV15 = '2003-12-01 00:00:00'

set @endV15 = '2003-12-02 00:00:00'



--...