March 8, 2002 at 11:20 am
We have an old Sql 6.5 server that needs to run a SQL 7 DTS package for about 6 months. The package will import data from another SQL server and an HP-midrange system (via ODBC).
1. Do I have to install a full copy of Sql 7 on the Sql 6.5 box? I remember some "redistrib.exe" (?) package one could use to move DTS functionality between machines. I wonder if I could get away with using that.
2. If I need more than the DTS engine, do you think the MSDE (Sql Desktop Engine) could do the trick?
It seems a waste buying a full copy of Sql 7 for a 6 month run. (Especially, given that I want the place to use Sql 2K!)
TIA,
Bill Salkin
March 8, 2002 at 11:33 am
I believe you can distribute the DTS componnents, but don't have a list of stuff. I'll try to look for one.
Steve Jones
March 8, 2002 at 12:30 pm
I'll try to find it but I believe the DTS components for SQL DTS packages are lincensed only with the install of the appropriate SQL version check out http://www.microsoft.com/sql as I think it was there somewhere. You may want to try MSDE but I don't use it and cannot tell you too much detail.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 12, 2002 at 6:47 am
DTS is a redistributable application and can be freely used. I beliebe SQLRedis.exe distributes this file, but if you like, I have a list of DLL files I could post.
-
-
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
March 12, 2002 at 9:48 pm
Thanks to all for your responses.
I found SQLRedis.exe contained in Sql Server SP3. I installed it but it doesn't leave a menu or any trace I can find on the computer. I presume that I create a DTS package using Enterprise Manager on another server but how do I run this DTS package with SqlRedist.exe?
TIA,
Bill
March 13, 2002 at 4:31 am
Brian's right, found what I was looking for, go here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8lmb.asp for details. And here for some additional information http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/deploybus_depdbsol.asp.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply