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 - 2002-06-28 : 09:51:15
|
| Scott Wolfe writes "Hello guys!! I have FoxPro 2.6 tables that I regularly import into my SQL tables (via DTS) for and online application. Now I have the need to export SELECT /WHERE SQL data back into different FoxPro tables. My question is, can DTS except parameters on the fly? Or is it just a straight table to table copy? Example, select * from online_orders where order_num = ‘User selection’. Thanks." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-28 : 10:20:58
|
| Yeah, just use a SQL Statement in your transformations....PeaceRick |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-06-28 : 10:34:56
|
| To expand on Rick's answer, there are a number of things you can do to parameterize DTS transformations. The functionality of DTS was greatly enhanced in 2K from 7.0, so I hope you're using 2K.DTS has 'global variables' which can be set through a variety of mechanisms: command line switches to dtsrun.exe, activeX tasks, dynamic properties tasks, etc. etc. Global variables can be passed into various tasks as parameters and used to modularize package execution.If you've got a specific question or scenario please post it and we can delve into more detail.Jonathan Boott, MCDBA |
|
|
|
|
|
|
DTS export with selective data