Since nobody else wants to post it here is the code from http://vyaskn.tripod.com/code/generate_inserts_2005.txt

SET NOCOUNT ON
GO

PRINT 'Using Master database'
USE master
GO

PRINT 'Checking for the existence of this procedure'
IF (SELECT OBJECT_ID('sp_generate_inserts','P')) IS...

and when you ran this users.txt did not exist but users.txt.tmp did?

which odbc drivers are you using for the AS400?

Is the code above in the workflow for the file import task?

Do the global variables specify the file to be imported in the task itself as well as the file...

I have found that using the executable task to execute http://ftp.exe with a script file works better than the ftp task.  It allows you to do more within the...

if you look at the global variable after you set it does it look right?  Also what ftp paramters are you using and what does the ftp script look like?

most likely the data doesn't convert because decimal(14,0) is bigger than an int.

begin

declare @dec decimal(14,0)

set @dec = 99999999999999

select cast(@dec as int)

end

when it hits the row that has a bigger number...

what happens when you

select cast(sa_LotSize as int)

from details