Hi Josh,

I've just had a go at what I suggested above and, whilst I still think tis possible, there are nuances to gettig it working so I'm not goig to...

I *think* this can *probably* be achieved in an OLE DB Command component.

You can issue SQL from the OLE DB Command that gets the maximum existing value and then use...

You're right it doesn't. But you can save the package and edit it offline.

If you think you should be able to set this property within the wizard then lodge a suggestion...

Mark,

AlwaysUseDefaultCodePage is a property of the OLE DB Source Adapter.

OLE DB Source Adapter is a component within the toolbox when building a SSIS data-flow

You build SSIS data-flows within Business Intelligence...

Ahh the old desert island discs debate. Always one I like. I won't give any explanation, only to say my 5 are:

• The Stone Roses - The Stones Roses
• Leftism - Leftfield
• Blue...

Hi there Noel,

In this case the transactions are handled by DTC. Does the same still aply?

-Jamie

Thanks Steve, you beat me to it. The Excel thing is a bug in the Excel driver. Its nothing to do with SQL Server. Discredit where discredit is due!

OK cool. That makes sense. Good luck with it.

-Jamie

Hi Jake,

I'm glad you got this working but I'm interested to know why you put so much logic into the Script Task. Was it not an option to use some...

There is no way to "call" another task from within a Script Task. Given what you've said I'm sure there is another way around this though. What is your script...

Interesting comment. Do you think that its because its easier in DTS or because you're more familiar with DTS? Do you not think it will be alot quicker in SSIS...

Why does there have to be a better way? What is wrong with what you have done? Nothing at all is the answer, and its hugely more performant than what...

Agreed - the graph is misleading in the extreme. That completely passed me by so thank you to Michael for point it out.

-Jamie

Hi David,

That's a good article. Thank you very much for it - its good to have theories be tried and tested.

A couple of comments.

1) Is there there a reason you...

Each package has a Major.Minor.Build version number. You could keep track of what versions have been deployed where and then if you suspect something has changed, go and check those...