RE: DTS?

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

DTS provides a somewhat simpler way to transform data from one table to
another.

Usually used in the context of import/export between flat files and the
database.

Nothing that can't be done on DB2. But I'd bet the vendor has some DTS
scripts he wants to reuse.

I'd consider finding another vendor.

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> george.wagner@xxxxxxxxxxxxxxxx
> Sent: Friday, December 16, 2005 5:54 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: DTS?
> 
>         We are looking at creating a custom A/R system (do 
> not ask why 
> custom!) using WebSphere/Java/DB2 on the iSeries.  The vendor 
> selected to 
> do the work now says he needs to do the back end on Microsoft 
> SQL server. 
> When asked why not DB2/400 as originally specified, he said 
> it was because 
> of DTS (data transformation services?) on MS SQL server.  
> Does anyone know 
> what DTS does?  Is there an IBM product that does what this 
> DTS does?  Is 
> the vendor saying this because he does not know DB2?  Is 
> there any reason 
> to do this project on an WINTEL box instead of the iSeries?
> 
> Please help.
> 
> Thanking you in advance.
> 
> 
> 
> 
>  
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>