Setting DTS global Variables

[dndaughtery]

Is it possible to set global variable in a DTS package with data from a table in the database? If so how? Use SQL in activex? Set global variable from a sproc?

 

[SQLDenis]

yes,

with a dynamic properties task

or

with ActiveX
DTSGlobalVariables( "gvDate" ).Value ="20050101"

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[dndaughtery]

I tried to using dynamic properties once to set the name of a file I was writing but it only worked the first time. After the first time it used the same name and overwrote the old file.

Know of any good tutorials online about dynamic properties? i plan on ordering a book on DTS programming tomorrow since I can't find them in any bookstores.

 

[SQLDenis]

you have to execute the task every time if not the value won't change

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[dndaughtery]

So does that mean that you can't set a dts package to run at a certain time everyday and create a different filename each day without going into the package and executing the dynamic properties?

 

[SQLDenis]

yes,

you can use a query, I have this for one of them
select convert(varchar,getdate,112)
and I use that later on to create a filename

in your dynamic Properties Task use query as sourcetype

make sure it's the first thing and create a workflow (those green arrows) to the next task

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[aftertaf]

can i then use the dts global variable as data that can be inserted into a table, in an sql query task object in the dts job?

Aftertaf
We shall prevail, and they shall not