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-03-25 : 07:38:18
|
| Ray writes "Hell everyone i have a question.In DTS I have made a package: that if I press the execute buttona table called "customer" gets updated in 3 other databases that also have the name "customer"My question is could I make a package that is variable.What i mean by that is if someone else makes another table en it'shave another table name how could the data be updated?Please help" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-03-25 : 07:47:47
|
| Yes, in SQL 2K you can set Global Variables when you execute DTSRun.exe. This, in effect, allows you to pass variables to the package.Using an activex scripting task you can set your source and destination of a datapump task at run time as well.Jay White{0} |
 |
|
|
killer2002
Starting Member
12 Posts |
Posted - 2003-03-26 : 05:07:51
|
| How can it be done do yuo have a example? |
|
|
|
|
|
|
Table with another name be updated, help