RE: DTS?

I would second this.  DTS would imply that data is being moved from one
database to another in a batch mode.  Is that what you expect this
application to do?  There are certainly ways to use DTS, as Walden
implies to connect to the iSeries and pull the data.  There are also
other ways to do the interface using Java.  Sounds like your vendor only
knows one way to do things and is trying to force you into it after
winning the business.

Jim 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden H. Leverich
Sent: Friday, December 16, 2005 9:35 AM
To: Midrange Systems Technical Discussion
Subject: RE: DTS?

>The vendor selected to do the work now says he needs to do the back end
on Microsoft SQL server.  

Next thing you know he'll "need" the front end to be in ASP.NET instead
of Java/Websphere! <G>

Seriously, there's no hiding the fact that I'm an MS lover, but your
vendor is full of it. Heck, depending on what he's doing w/DTS DTS can
even access DB2 tables if it has to. 

To make matters worse, I would guess that you're looking at running this
Java/WebSphere app on WAS on the iSeries, no? So the vendor is proposing
that he bypass the database sitting on the same machine and instead
access a SQLServer sitting next to it? Sounds very wrong to me.

-Walden

------------
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)


-----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.


--
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.