What's up everyone? I have a question about importing data into SQL Server from the AS/400, and the setup on the DB Server that is required. Basically, this is where I'm at. I am able to create a DTS package that uses a DSN to grab data from the AS/400 and put it into a SQL Server 2000 table on my local development DB. I can execute it no problem, and everything is fine. I have an ASP page that can run a Stored Procedure that executes this DTS Package and everything.
However, the problem lies on the production server. The production server does not have the Client Access ODBC Driver, so I cannot set up the DSN on the machine. The Admins here refuse to put it on there, since they claim it has been known to lock up machines. Since I can't create this DSN, I can't execute this package. If I open up Enterprise Manager on my machine and execute the DTS on the server, it runs fine. I guess it uses my local DSN for that. Is there anyway I can do this while connecting to the server from ASP? I need a way of importing this data without having a DSN setup on the server. Any ideas or other suggestions would be greatly appreciated. Thanks!!!
Doug
However, the problem lies on the production server. The production server does not have the Client Access ODBC Driver, so I cannot set up the DSN on the machine. The Admins here refuse to put it on there, since they claim it has been known to lock up machines. Since I can't create this DSN, I can't execute this package. If I open up Enterprise Manager on my machine and execute the DTS on the server, it runs fine. I guess it uses my local DSN for that. Is there anyway I can do this while connecting to the server from ASP? I need a way of importing this data without having a DSN setup on the server. Any ideas or other suggestions would be greatly appreciated. Thanks!!!
Doug