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 |
|
ashgupta
Starting Member
17 Posts |
 Posted - 2008-12-15 : 00:19:43
|
| Hi experts, I have designed an DTS to export data, however my question is , is it possible to design an DTS in sql 2000 with an input parameter ?any help ! appreciated |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 00:23:07
|
| you can use global variables for this purpose and set values of global variables during execution of dts. the global variables can then be mapped to any of your task properties using dynamic properties task in dtys. if you can provide more information on your scenario, we will be able to help more. |
 |
|
|
ashgupta
Starting Member
17 Posts |
Posted - 2008-12-15 : 00:37:47
|
| I have a dts package, that exports from sql servers to access. my problem is that i want to export the data to access according to versions field in the table - eg select * from table ABC where [Version]='1' . I want to design the package to take input parameter as @version which keep chagnging from time to time. I dont want to go around and create new package for each version. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 00:46:06
|
| and just in case the value of variable somes from a query then use execute sql task with reqd query and map value returned to output parameter which will correspond to created variable. then use it for later queries. |
|
|
|
|
|
|
DTS help