Hi Steve,

Apologies I wasn't clear. That said I have managed to fix my issue, but wish to thank you all the same for your kind response.

Kind regards,

Neil

It wasn't but I added it at the top, but sadly the dts parts of the code are still erroring.

Thanks,

N

Thanks again xyoung!

When I copy the script in from Catherine's article the dts.variable is not recognised so the whole thing fails.

I'm not sure if I can declare these variables in...

Ah...I currently have SQL 2008 which only has Visual Basic 2008 and not VB .NET. Have to confess I am not up on VB so not sure if it's possible...

I'll give that a go. Thanks for your help xyoung much appreciated! 🙂

Several variations on a theme either using script task and variables or execute process task. Both worked in terms of getting files archived however they made individual archives and not...

I will give it a go. Thanks Gianluca.

Anyone?? Still have an issue with the Dts.Variable not being recognised.

Any help would be greatly appreciated.

That's brilliant! Does the same thing and saves me doing silly row count stuff!

I can't thank you enough!

Very much appreciated!

Neil

Hi Neil,

Noted!

Thanks again,

Neil McK

Eureka!

That worked perfectly. Thank you both very much for the help!

I will endeavour to remember that next time!

Kindest regards,

Neil McK

Hi Neil,

Thanks for your prompt response! Much appreciated.

Yes the row count should be 60 and it is when I put in the parameter values. However it returns 0 when...

Hi Carolyn,

Do you know if its possible to run this using Microsoft Visual Basic 2008?

When I was looking at your code in BIDS it was showing DTS as unrecognised. Can...

You were right Kingston!

Big thank you to Abu and yourself for your invaluable help! All working as intended!!

Many thanks

Neil

I did Abu, it returned the following error:

"Msg 8152, Level 16, State 13, Line 1

String or binary data would be truncated.

The statement has been terminated."