Ok, I have a DTS package. Within that package I want to create
a vbscript object that shoots up a message box with the total number
of records in a given table. I must be missing something, because I
can't figure out how to set a "select count(*) from testtable" sql statement
equal to a vbscript variable (which I would then place within a msgbox
function, i.e., "msgbox(x)"). Make sense?

Any help is appreciated, thanks.

-Roy

See, I knew it'd be simple.
Thanks!

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

OK

Using SQL Server 2000

Use an ExecuteSQL task and do

SELECT Count(*) as Amount from MyTable

now hit the Parameters button and assign "Amount" to a Global variable

Now in your Active Script task do you MsgBox thing

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Roy @ Work" <spam (AT) blah (DOT) com> wrote