Your assumption is correct, so something else must be happening.

a) Double check the scope of the variables

b) Double check that the variable is actually being set as you think (Msgbox...

This is also simply achieved with a short piece of script, if you feel like dabbling. This would have the added benefit of not feeling like a bit of a...

Get that man a beer :exclamation::exclamation::exclamation::exclamation:

I am impressed & will no doubt be checking out this thread again when next I have to import from Excel 🙂

No problem & good luck. Too many people have wasted too much time on this Excel data-typing / NULLing issue.

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...