Thanks for your help, I am still having issues, could you look at the code below and see where I am going wrong

ALTER TABLE tableName CONVERT(char(5), DATEADD(MINUTE, convert(int,150), '19000101'), 108)...

The errors are attached

I understand but how do you just import the latest files from SSIS FTP TASK, I dont want to have to import now 8000 records every 2mins. After the FTP...

set @temp= 'c:\xxx' + cast(@number as varchar(50)) + '.xml'

DECLARE @isExists INT

exec master.dbo.xp_fileexist @temp,

@isExists OUTPUT

SELECT case @isExists

when 1 then 'Yes'

return

else 'No'

end as isExists

the error is...

The main reason for backing up sequentially is because we are taking a further backup on a tape drive (TSM), if the backups are date based it backs each file,...

Could anybody supply the TSQL for this please:-)

Hi,

Yes I did enable logging in the SSIS package, but there anything useful to see.

Just out of interest can this be used with SQL 2005 SSIS packages?

Just a quick question will the solution you supplied sort the problem of comma's inside text eg '21,2000,"5 Bomley,way",xxxxx

Its worked:-):hehe:

I found the error, the text file had a blank row at the end of the text file.

thanks

Cheers that seem to solve that problem,

now for the next error:-)

Thanks for your solution, iam am getting the following error

:w00t:

thanks for your reply the only problem with that is in column3 is the process order, they have to be done in that order.

I have the tables below, I have not included scripts to insert the data as that is what the problem is, the data is provided in one text file and...

one thing i forgot to mentation is that rows in the data don't have the same number of delimiters(,), one row might have 20 delimiters and another row might have...