DTS is not a 3rd party tool.
Good resources for DTS?
Allan Mitchell (Microsoft SQL Server MVP)
I support PASS - the definitive, global community
for SQL Server professionals - [url]http://www.sqlpass.org[/url]
"Bob Castleman" <nomailhere> wrote in message
news:#cwGPZ7RDHA.2316tk2msftngp13.phx.gbl...next> Anybody ever use Data Junction or other third party tools for moving data
> between different database formats? My reason for asking is that in thedatabase> 12 months we are presumably integrating our application into an corporate
> scale enterprise version. Our current customers tend to be less than 20
> clients. The corporate version is supposed to consolidate data from many
> remote offices into a centralized system, which may be a third party, high
> end accounting package with at least at this point, an unknown backend. I
> will have the pleasure of developing the initial proposal for this. I need
> to look at third party tools, DTS, tion, etc.
> Can anybody suggest good references beyond BOL for DTS and tion?
> If anyone reading this has followed my postings here on consolidating our
> event logs from our customers, I am frankly scared sh*tless. If the
> cleanliness of the event logs is any indication of the rest of ourit> health, it's going to be an "interesting" excercise. A big issue is thatfinanciers> looks like a non-trivial portion of the data pushed up to the corporate
> level will be modified, and some of those modifications will need to be
> propagated back down to the remote sites.
> The really frightening part is that the whole IT piece has to be in place
> (and working!) by sometime next year because the customer's business plan
> includes going public at a time already loosely determined by the> using assumptions that include the information systems.
> Bob Castleman
> SuccessWare Software