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 |
|
MarkyBoy666
Starting Member
14 Posts |
 Posted - 2005-02-15 : 04:32:04
|
| Hi,I have a transform data task which transfers data from a csv file to a table in a SQL database. The file name and destination table are both set up using global variables. However, I also need to be able to specify which transformation (column mapping) to use, from a set list of pre-defined transformations, also using a global variable. Unfortunately I have yet to find a way of doing this - has anyone else come across a solution to this?Many thanks for any suggestions. |
|
|
|
|
|
DTS Transform Data Task - Global Variables