Hi,

I want to use dynamic properties task to set the valuesfor the global
variables in SSIS 2005

In SQL 2000 this task is named "dynamic properties task". I can't found this
task in SSIS 2005 enterprise or standard.

Is there elsewhere in SQL Server 2005 ?

The migration task from DTS 2000 to 2005 create an empty Script task !!!

Thanks for your help.

Best regards

Bertrand Burquier

Hi,

There is no dynamic properties task in SSIS, so if yoi migrate any package
from 200 to 2005 with this property, mostly will not work. it is better to
redesign the package. you can set global variable by right clicking on BIDs
and selecting user global variable and you can do much more with global
variable than before. Read the sql book online.

SP

"Bertrand Burquier" wrote:

Hello Bertrand,

In SSIS you need to be looking at

Property Expressions
Configurations

These are the way forward.

You can have a variable value be the result of an expression and in SP1 MS
have added an editor to this functionality which makes it a whole load easier
than RTM.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com