Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  How to import http based T-SQL script in DTS ?

Author  Topic  gispro Starting Member 21 Posts Posted - 2006-02-03 : 06:00:48 I have a MySQL database on a remote Internet server, that runs a company planning module. I would like to have a clone of the planning module running on an internal server servicing the LAN. The app is to use a SQL Server for backend. To that end, I've created a script to dump the content of the MySQL database as T-SQL commands (truncate, insert etc.), and is able to call it via http. I've verified that the script output is immidiatedly runnable in Query Analyzer. I would like to have this task automated to run on a fixed schedule, and therefore want to create a DTS package to do so. However, I'm stuck at how to retrieve the T-SQL script in the first place. And I'm also unsure on how to "execute" the script content/file once it's been imported/transferred. I would be happy if someone could provide me with some pointers on this. Is this even the proper way to tackle this task ? ODBC and OLE-DB etc. are out of the question, it needs to be based on http (or ftp) transfer. Using MS/SQL 2000. TIA -- GisPro