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 |
|
igbinosun
Starting Member
13 Posts |
 Posted - 2004-09-16 : 17:24:35
|
| I want to be able to do is to pass in the name of the table that I'm moving the data from to the dts package when I execute the package in the command line using dtsrun utility. I'll also be apending this table to the name of my output file. Any idea on how I can do this? |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-09-17 : 00:31:26
|
| First of all, if the number of tables are limited, you'd be better off creating transformations for each of these tables and program DTS to execute that transformation only depending the input parameter.But otherwise, This will need activeX scripts in the DTS that will dynamically change the package properties, source, destination and transformations.Refer to BOL under DTS -> "creating objects" for VB script samples for different objects. If you've never done so, create a sample dts package and save it as a VB file. Look at the code brifly to understand how it does that. Hemanth GorijalaBI Architect / DBA... |
 |
|
|
|
|
|
DTSRun