SQL Server Performance

Dynamically Change Global Variables

Discussion in 'SQL Server 2005 Integration Services' started by Jon M, May 12, 2008.

  1. Jon M Member

    With SQL Server 2000 DTS, we can dynamically change a global variable using the Dynamic Properties Task.
    I understand that Dynamic Properties is no longer available in SQL Server 2005. How do I achieve the following?
    1. I need to set the value of a global variable named "numofrecords" dynamically based on a query "select count(*) from temptable".
    Previously, using Dynamic Properties Task I can just set the value property of "numofrecords" with source as Query and the writing the actual query.
    2. I need to set the DataSource value of my Text File (Destination) dynamically using a global variable. Meaning, DataSource = GlobalVar (something like that).
    Previously, I can set this using Dynamic Properties Task with Destination Property of DataSource, Source Type of Global Variable, Source Value of MyGlobalVariable.
    Jon M
  2. satya Moderator

  3. Jon M Member

Share This Page