Thanks John,

An example of a row in the csv file:

"ABERDEEN FUND MANAGERS LTD","B","VOD.L","19 NOV 2008","1.249547","ABERD9001","GM","586.85","-390644.32","313100","GBP","B16GWD5"

So the error related to the Date field '19 NOV 2008' the colum is set...

Thanks again, question:

How do I pull it into SSMS and debug it?

Please see screen shot

Ok thanks for the prompt reply's!!

I am a total newbe to SSIS & DTS so im going to ask you some realy bumb questions now:

1. Where do I dind the...

Ok so I have editied the package, it now seems to be erroring:

SSIS package "Package.dtsx" starting.

Error: 0xC002F210 at Execute procImportAllFiles UPDATE AND APPEND DATA, Execute SQL Task: Executing the query...

Thanks for the clear info.

The BAT file:

dtsrun /Slocalql23\book /Usa /Peastcoat /N"Import" > e:\bookFTP\dtsftpscheduleV2.log

no referance to send email in BAT file.

Did you mean in the SSIS(DTS) package?

Thanks, I only have something like 700rows of data so it run quick for me!

Thanks again!

:):D:):D:):D

Thank you very very much!

Thanks, so for the following returned data:

SELECT *

FROM tblPandL

WHERE Currency not like 'GBP'

AND Currency not like 'ZAR'

AND Date >= '04/08/08'

order by date desc

I want to run the power...

Thanks very much, worked well!! 🙂

Thanks

AND d2.trade_date BETWEEN getdate() -730 AND getdate()

worked fine

Thanks, that cleared it up abit.

I'll try this and see how it goes!

Thanks again all

Would it just be easier to take the DB 'Off line', copy the MDF and LDF files which I need then bring the DB 'Back Online'?

Would this allow me to...

Thanks thats was a good article.

But, they are talking about transferring logibs from two servers BOTH running SQL Server 2005.

I have one server running SQL Server 2000 & one server...