Declare @FileName as varchar(200)

set @FileName = 'C:\Whatever.txt'

select 'copy F:\data_dump\emer\inventory.txt ' + @filename

--copy F:\data_dump\emer\inventory.txt C:\Whatever.txt

select 'copy F:\data_dump\emer\inventory.txt ''' + @filename + ''''

--copy F:\data_dump\emer\inventory.txt 'C:\Whatever.txt'

select 'copy F:\data_dump\emer\inventory.txt "' + @filename + '"'

--copy...

Anyways, try it and see what comes up.

Hey Vasc do you know of an article that compares both NON DETERMINISTIC and DETERMINISTIC for speed?

Yup... you were pointing back to your current comment on this thread

you mean this?

set @cmd = 'copy F:\data_dump\emer\inventory.txt ' + @filename

No, but that could work too .

Let's try it in english this time .

Open the package, File/properties/3rd tab (logging or saving), then file out the err handling section. ...

AMEN!

Not even worth trying to compare.. gonna be too depressing .

Have you turned on the logging to file of the steps? Maybe the error could be more relevant in there.

I still wouldn't mess with the data just to beautify the data (unless it causes other problems). You can create much bigger problems that way... especially if you don't...

I didn't provide that solution. Looks to me like you reinsert data that is already in the table. So I would just add a where not exists in...

Are you sure you got the right URL?

Thanx was looking for the definition... didn't know that people had so much time on their hands...

K... please post the results.. I'm curious to see if I'm right about this one.