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 - 2004-09-28 : 07:23:53
|
| Rupshi writes "I would like to import data from an Informix Database to SQL using the DTS Service. But the data to pull from Informix has to have a date which is greater then the last date from a table in the SQL database. Is it possible to create a DTS package that checks the MAX date in SQL and then uses that date to pull data from the Informix database? If so, how can that be accomplished? Really need to get this done and need help." |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2004-09-28 : 07:45:24
|
| Use an Execute SQL task with an output parameter to store the max date. Use this global variable in the query that forms the source of the transform data task.Mark |
 |
|
|
|
|
|
DTS Service