Enterprise Evaluation Edition SSIS/BIDS/DTS

[Skittle]

I am evaluating SQL Server 2005 to use on a project that needs connectivity to an AS400/Iseries.

My installed Enterprise Evaluation Edition doesn't want to talk to the AS400 so I've tried to load the DTS backward compatibility msi. I've run the install but I can't find it within SQL Server 2005's legacy tree.

Am I looking in the right place?
Does the DTS backward compatibility install work with the evaluation version?

I need to be sure I can talk to the AS400 before I recommend we buy SQL Server 2005.

Dazed and confused

 

[RiverGuy]

I'm not sure why you need DTS to talk to an AS400. All you should need is an OLEDB/ODBC driver to be used in SSIS.

 

[mrdenny]

In order to talk to the AS/400 you will need to install the AS/400 drivers on both your workstation and the SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

If you are looking for where the DTS packages are, then look at: Management > Legacy in SSMS.

-SQLBill

Posting advice: FAQ481-4875

 

[Skittle]

I outlined my problems on the (slightly) cross posted thread at

http://www.tek-tips.com/viewthread.cfm?qid=1383054&page=1

I've found a few other pages on the internet that indicate there can be AS400 connectivity issues.
See

http://www.ibm.com/developerworks/forums/dw_thread.jsp?thread=135790&forum=292&cat=19&ca=drs-fo

Iagree it should work fine - but sadly it does not.


Dazed and confused