Thanks for going to all that effort Peter - it will come in very useful in the next couple of days.

No - those approaches won't work. The data doesn't even make it into the data pipeline.

The Excel driver 'decides' on a datatype for every field as it is pushing the...

Your VB sample is just doing the file copy - am I right?

How are you structuring the rest of your package (the backup/restore bits) to achieve the parallelism you are...

Following on from Tim's response, you have to decide what is involved in your migration.

If it's just all 'application' databases, you can forget the system databases - they already exist...

:unsure: How disappointing. I still think magic and ghosts...

But Row_Number() was new in 2005, wasn't it?

Doesn't help that I'm developing on 2005 for a 2000 system ...

Oh yeah, that's what I want, very nice work, thanks! 😎

Now I'll try to understand how you did that 🙂

Thanks again.

There are some third-party utilities available which allow you to run a Crystal Report from the command line. So, once you have that working, your problem reduces to building the...

I hope you did not take offence - none was intended. My comment was meant in fun.

I never even suspected that English was not your native language - you...

Hmmm, you might be pretty good at SSIS, but I'm not so sure about your English! 😀

If no one else answers in the meantime, I will try to set up a test later. There must be a way! What about firing in the number which Excel...

Sounds like it's going into Excel as text to me.

So if you remove all display formatting in Excel, what does the field actually contain?

OK, if your table is called t1, this should do it:

with t as (

select distinct ID, Max(Cost) Cost

from T1

group by ID

)

select t1.ID, max(t1.Cost), Max(t1.ItemNumber) from T1

join T on T1.ID =...

If you can use SQL Server to do the work:

Select Convert(Varchar(10) , Cast('12-OCT-2009 18:23:20' as Datetime), 103)

--edit - oops, misread your post. That's not a date datatype 🙁 ignore me.