Wow! it worked! thanks so much

hm.. haha you're right! thanks for the tip

What I meant was to do something like this:

Set objConn1 = DTSGlobalVariables.Parent.Connections("gDBConnection")

objConn1.DataSource = DTSGlobalVariables("gDataSource").Value

objConn1.Catalog = DTSGlobalVariables("gCatalog").Value

objConn1.Username = DTSGlobalVariables("gUsername").Value // <-- doesn't work

objConn1.Password = DTSGlobalVariables("gPassword").Value // <-- doesn't work

Do you know...

Hi trey,

I wasn't able to find the details on the event model package on the site, but I tried doing something that involves events as well. I'm not sure if...

Hm.. no ones answering... does this mean that this can't be done?

I'm not sure if this will work for you, but from my code above...

DECLARE @dbName VARCHAR(20)

SELECT @dbName = databaseName FROM GlobalVariables

DECLARE @command VARCHAR(1000)

SET @command = 'SELECT *...

the problem with using parameters is that it does not allow parameters to be used as database names... so it does not allow a statement like

SELECT * FROM ?.dbo.Table1

but anyway, I...

wow! haha thanks a lot! I tried doing this already but I found out that it cannot detect the Exec Package Name...