hello there... it's beren a long time... but better late than never...

THANK YOU so very much for the follow up.... we'll will resucitate this issue and look into, will keep...

Thank you all for your prompt response. This site is my fountain of knowledge; I'll start my inevitable new mission, to rewrite the DTS in SSIS.

'till next hurdle... have...

That's exactly what we are doing, but they don't want to accept the work around and insist that I come up with the 64-bit solution!!!!

Thanks for your input.

Annie G.

Scott, that worked like a charm; thank you so much

'till the next challenge!

The change worked;-) Can I extend a question for the script with all the databases....

If I want to get a list of all the tables  that have the word school...

Hi Mdaniel,

Do I need to replace any info on the query above or can I run it just as is??? (I'm still a rookie at this;-) thanks.

Hi Scott,

I tried the code 'for one db' without the '%char%', because the fields vary, ran the code but received an 'Arithmetic overflow error for data type tinyint, value =...

The table names, field names and length all differ!

Hello cyber world,

I was able to resolve the date comparison issue by using the 'Dynamic Properties Task's Globalvariables' to assign the date loaded in the .txt file, and then using ActiveX to test...

Hello Vic,

Forgive my ignorance, but where exactly I can issue this command from?  I normally remote to the server I'm working on and when I press the ctrl/g nothing happens!

Hello again,

The 'datediff' syntax in ActiveX didn't error out, but when I execute the complete dts, when the pk12_date (11/22/2006) is not the same as the current_timestamp, it shouldn't execute the next dts, but...

You made my day!!! just when I was about to convert back to the mainframe (only kidding;-):

Now for part II, since the .txt...

Hi Vic,

Thank you for responding, you are my first cyber contact;-)

The 'dd' is the DATEPART parameter for 'day' that specifies which part of the date to calculate the difference.  If...