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 - 2001-08-17 : 00:31:01
|
| peterh writes "I apologise for this not being a hard question, but as a newcomer to DTS (under SQL 7), I've found making changes very hard work.We operate a number of companies with separate (identical format) SQL Server 7 databases for each company. I have created a DTS package to take data from one of these databases and transfer it to an Oracle database. I would now like to do this for my 4 other SQL databases without having to redo everything. I haven't managed to change a data source without it destroying all the future tasks. Also any small change in either the sourse or destination seems to reset the transformations back to the worst default where the first n source fields are mapped to the first n destination fields. If there had been an activex script previously, then this is lost too.Am I missing something or is this just a quirk of DTS under SQL7. Your articles suggest that 2000 is much better, and that the new parameterised features would solve this problem." |
|
|
|
|
|
DTS - Problems with editing