James,

Fair comment I guess. The title was meant to be fairly colloquial (I think - Its almost two years since I wrote it and was surprised to see it republished).

-Jamie

In case anyone is interested, Mag and I sorted this one out offline and she was good enough to write a short case study which is well worth a read:

A case...

Gerald,

Some people like unicode, some people don't. Some people are not international - some people are. You can't please all of the people all of the time so they've gone for...

Jennifer,

That error comes from SQL Server so the expression has been evaluated just fine - its the resultant SQL statement that is erroring

use this technique : http://blogs.conchango.com/jamiethomson/archive/2005/12/05/2462.aspx to debug the...

Bert,

The question asks about "the results of a sql query being stored in a variable". i.e. The whole resultset in ONE variable. There is only one variable datatype that allows this -...

KD,

Its a string manipulation problem. Pull out all of the different parts of the date using DATEPART function and concatenate them together.

-Jamie

Rob is right.

System.IO.File.Exists(filename)

will do the job for you.

-Jamie

You can set the name of the file dynamically by using an expression on the Flat File/Excel/whatever connection manager. That expression can in fact do all the work for you...

Did you choose to save the package to the file system or to SQL Server?

Not a bad article Andy. I learnt some stuff I didn't know before.

Having said that, the article was a "How" to use them. I would really likemto see a "Why"...

[Can I reply first ]

Yep!

Good point Joshua if that's the case. Minor oversight if so - my apologies!

-Jamie

I'm truly shocked about this. I hope the supply of great material from Mark doesn't dry up.

Which of the two blokes in the above picture is he by the way?

Correct David. That's kinda why I included it as an option

-Jamie

There's a small fix. Set AlwaysUseDefaultCodePage=TRUE on the OLE DB Source adapter.

-Jamie