Thanks for the kind words Mike.

Well Im back at it. I have made a lot of progress! I have opened a recordset based on a query to the Progress...

Mike,

Your suggestion worked perfectly. I am capturing the maxtran value I need!

If you can tolerate one more question: my understanding is that this DTS global variable is only...

I just ran:

Function Main()

Dim cnn

Dim rst

Dim theSQL

Set cnn = CreateObject("ADODB.Connection")

Set rst = CreateObject("ADODB.Recordset")

'Set rst = DTSGlobalVariables ("maxtran").Value

cnn.Open "DSN=TM SQLServer Syteline_test"

theSQL = "SELECT MAX([trans-num]) FROM matltran"

rst.Open theSQL, cnn

MsgBox("maxtran is ' "...

Nope, there is nothing on the sql task window to deal with a global variable that I can see nor is it mentioned in BOL. I guess its a...

Hi Mike

I defined global variable in package property "maxtran" as

maxtran Int 0

I then made my connection object to the local SQL database. I then made...

Ok I'm stuck. I am very new at VBScript so bear with me!

I created the global variable in the package property window and named it "maxtran". I tried...

Thank you Clive. I will give it a try today and post my code if it works!

Jonathan

I should have mentioned, I am using SQL 7 SP4

Thanks all for the rapid response. You guys are great!

Jonathan

Thanks again Ranjit

I will take your suggestion and try a test.

Jonathan

Thanks for your reply Ranjit,

I am hesitant to link servers because the Progress database is our production database for our ERP (Enterprise Resource Planning)software. The Progress database has its...

Thanks for your reply Mike,

I see now that ActiveX is the way to go here. I am a bit confused about the big picture however. What about this:

1. ...

By commenting out the entire SQL and uncommenting one line at a time and parsing each time I found that the following version of my original update works! For...

By commenting out the entire SQL and uncommenting one line at a time and parsing each time I found that the following version of my original update works! For...

Sorry about the delay responding. Thanks a ton for the code. It will take me awhile to absorb what you sent. In the meantime, my soundex procedure...