An example is that it sees the time in Sybase (Sybase 11) table as 12:52:39.000, but SSIS sees the value as a DT_I8 with a value of 463590000000.

Ewh. Would you say then that if we've already developed a SQL data warehouse being populated by SSIS packages and reported on via SSRS that it's probably not worth while...

So, are you saying SSAS provides a more intuitive platform for producing and displaying statistics from the data warehouse? In other words, I can do what SSAS would do in...

Do you mean type "T-7" in to the default value field for the parameter in question in report manager > properties (of the report) > Parameters tab?

Hey, I like that! Haven't used sp_send_dbmail before and it's worked fine. Thanks.

Yes, I agree. At a loss how to force writing to a date field (or custom date and time formatted field) really. There doesn't seem to be any means of...

I've only got a header row containing my column headers in the template file. Once the spreadsheet is populated the field has 10/12/2009 15:32:22 in it in a general format.

Tried that and it didn't work. Key to that really was that even when I tried to convert the value to be a date field once I created the previous...

STOP PRESS! Interesting this. I just put a data viewer between my lookup transformation and my Excel destination and the derived column date is showing in UK format. It must...

My source file is a pipe-delimited text file so not able to do any sql processing unless I build a staging sql table in between, which seems a little overkill....

Can you use this function from within a ssis data flow task though?

The locale id for the derived column transformation is English (United Kingdom) so...

Thanks. Will have a look.

Very useful responses. Many thanks.

OK. I'll try decimal(18,6) I think. Thanks for your help.