Date Parameters with DTS packages

[Rob999]

Hi everyone. I'd like to know if there's an EZ way to use a global variable from a Dynamic Properties task to limit the number of records imported from a table by Date.

I've used dynamic properties before with tasks, but I don't know how to use a 'gvDate' in the required SQL string from the Source tab of a Transform Data task. The default string reads-

SELECT fields
FROM table

I'd like to add-
WHERE trnsDate = gvDate,

with gvDate being the variable. I've tried declaring a @variable and some other things but don't know what I'm missing. Thanks.

 

[tlbroadbent]

Check the following link.

Global Variables and SQL statements in DTS

http://www.sqldts.com/default.aspx?6,102,205,7,0

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm