Will do - I gave the other articles a good reading and the block of code from Chris is still looking a little like black magic to me to be...

Thanks - into a world I know nothing about so will be reading your articles shortly - will let you know how I get on.

I've made some progress - I've changed the chart type & have found that Pie / Exploded Pie & Doughnut / Exploded Doughnut fail whilst Bar / Column charts work...

Much appreciated

Spot on, thank you for helping.

Good try but that sets the whole time part to zeros.

Just like everyone else I'd like more of everything but what I would really like is some respect shown to the people who show commitment and achieve results for the...

Yes it is, in fact that is what I've now started to do - the only "problem" with that is ensuring another drive location I know that will be available...

Having used this as the basis for my own version though I best update again - there is an error in the code when you have multiple schemas in a...

I know this comment is rather late in the day but I'm just revisiting your script - I've used it as the basis of something that suits what I want...

Can I ask how you came to the decision to only do if @Page>1000?

Thanks

I've figured it out now so in case anyone else needs to figure it out :

1) Load data from source db

2) lookup against destination DB lookup table

3) Redirect error rows...

Silly me - I can select all the columns and change the type in one step.

Much relieved.

Yes you can still use DTS - however, the import / export wizard on 2005 is based on SSIS which is probably a better bet - if you've the appropriate...

Not much info to go on here!

However, you could try executing the job as a user you know has rights to the drives you are accessing.