What is the exact error message?

Create a share of the same name on both boxes and use the UNC path to the file. When you move to production, you only have to change the name...

Is the Microsoft DTSObjectLibaray dll <dtspkg.dll> installed on server Y? Does objPkg get created ok?

aziz,

There are many ways to get this done. IMHO the best, is to bcp the file into a table with one column (data varchar(4000)) and use substring(fieldname, startpos, length)...

update tablename

set model = rtrim(model) + '-R'

from tablename

Use an ActiveX script like this:

Dim FileName

FileName = "extamb1200.dat"

dim fso, fldr, f

set fso = CreateObject(Scripting.FileSystemObject")

set fldr = FSO.GetFolder("MyFolderPath")

set f = fldr.Files(0)

f.Name = FileName

set f = nothing

set fldr = nothing

set...

You didn't set the ActiveConnection property of the two new recordsets.

To eliminate NULL when summing fields, use isnull(fieldname, 0) so you end up with:

sum(isnull(fieldname, 0))

trobinson, Cool!

Is your file delimited or fixed width?

Just reread my post and it's pretty sloppy. Jay, if decide to go the bcp route and need help with the exact syntax, drop me an email.

Thanks,

John

I believe you're getting that "extra line" every time you do f.close. The close must insert an extra linefeed character, although I can't put my finger on it. ...

@ParentID is an int.

1 is an int.

'000053-1' is not an int. The type mismatch will raise an error in SQL 2000.

Change @ParentID to a nvarchar(30) and put...

'This will not error

if left(null, 1) = 1 then

msbox "boo hoo"

else

msgbox "woo hoo"

end if

'neither will this

msgbox isdate(null)

'This will error

msgbox Len(Null) 'invalid use of null

'finally,

DestValue = CInt(DTSSource(SourceCol)) + 19000000

CInt will...

DuruG

The date format is a bit weird but... The first position is the century. If this is a 0 the year is 19 (if 1 then 20) & positions 2...