Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
 Posted - 2005-10-19 : 10:48:53
|
| I'm playing around with using the dynamic properties task to set some global variables in a package. I'm having the dynamic properties query the database to get it's value. I'm finding that if I type in some invalid SQL (bad table name or even just some random text) the dynamic properties task won't generate an error message. It just leaves the property value unchanged.Has anyone else seen this?===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-10-19 : 11:42:54
|
| Graz,I have used dynamic properties in couple of my dts packages, but I never tried with invalid values. My understandig is that even if you give invalid values it will assign the value to the global variables but your sql task should fail stating invalid object name.ThanksKarunakaran |
 |
|
|
|
|
|
Dynamic Properties Task won't fail