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 |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2008-01-23 : 06:23:50
|
| Hi ,Is it possible to use a system variable in a 'Execute sql task'or any other query component in SSIS? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-23 : 07:31:39
|
| Yup you can use it by going to Expressions->property expressions tab of each task. By the way can i ask what are trying to do with variable here? |
 |
|
|
varalakshmi
Yak Posting Veteran
98 Posts |
Posted - 2008-01-24 : 01:58:49
|
| I had to retrive the system starttime,package id and packagename using a query... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-24 : 09:49:17
|
| You can set these values in Expressions tab of SQL task.you can access all System and user variables inside the property tab. |
|
|
|
varalakshmi
Yak Posting Veteran
98 Posts |
Posted - 2008-01-25 : 00:23:16
|
| Thank u...It works... |
|
|
|
|
|
|
System variable in a Query