I would like to create a global varible from a result of
a query. I use the rowset value into glabal varile.
Here is what I did:

SELECT MAX(updateDate)
FROM tblLobbyistDisbursment


click paratmeter/output parameter/row set/

create global variable/
name:glbMaxDate, type: I chose Date, Value: I wonder what
should I put here, I leave it blank.

After I click OK, it tells me: cannot convert varible
from type bstr to type date.
I check the update fields type in my Access database is
Datetime, in SQL server is smalldatetime.

So I don't know where bstr comes from

Any suggestions will be appreciated

Ann

In article <105001c38db4$f57c0040$a401280a (AT) phx (DOT) gbl>, Ann
<xiaowei.cao (AT) state (DOT) mn.us> writes
Just leave the type as a string. It is a variant under the covers any
way. The value can be left blank as it will be set as soon as the
package executes. I always use a string, and if this is wrong, then DTS
will change it for you when you execute the package.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org