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 |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2005-04-19 : 10:32:10
|
| Hi Everyone -I have a DTS package that runs every so many minutes on a SQL server database. It pulls data from a Sybase database (odbc) connection.The problem is - if the sybase table structure changes, the DTS job fails...SO - the question is this....Is there a way to tell DTS to recreate the table using the new table structure that can be supplied from Sybase?My mind was running in a thousand different ideas, but none of them seem to simple of a solution - so i am askingthe group to see if they have any ideas...thankstony |
|
|
|
|
|
field changes - dts fails