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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-18 : 07:42:11
|
| David writes "I have a DTS package with a number of global variables. Some are set at design time (such as email addresses) and some at run-time (such as the number of records that failed a particular operation).I'm having *a lot* of problems using the global variables, in that sometimes they work and sometimes they don't. Even trying to set a variable to the current date, by using the Dynamic Properties to assign it the value of SELECT GETDATE() doesn't work, yet in the same task, setting a different variable to the result of SELECT COUNT(*) FROM myTable WHERE myColumn = 1 does work!" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-18 : 19:42:18
|
| Forget it.Either let DTS creat a new table (not reccommended) or Load a work table. Once it's loaded use transact sql to do what you want.Besides, it's slower in DTS....row by row...oeyi..Brett8-) |
 |
|
|
|
|
|
Using Dynamic Properties task