DTS (Data Transformation Services) for SQL-Server allows the creation of 'packages' that are essentially automated scripts and processes that can extract data from several sources, transform data suitable for destination tables. It is a powerful interface tool that was heretofore only available from 3rd parties. Microsoft has included this functionality in recent versions of SQL-Server. DTS does require ODBC, file, or other driver (ie: sql*net) access to the datasource and destination.
-alan ----- Original Message ----- From: Michael She <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 7:22 PM Subject: RE: [CFTALKTor] ColdFusion Hosting > Are you using SQL Server? > > > Doesn't SQL server have a function called DTS which allows you to copy > records between databases? > > > At 03:51 PM 4/3/2002 -0500, [EMAIL PROTECTED] you wrote: > > > >Hi, > > > >I've just set up an account with Cyrstal tech and I found out that > >I cannot set up the Crystaltech datasource as a remote on my development > >server > >due to security concerns. > > > >I was wondering how any body else has dealt with this issue. > > > >I use my development server for staging and admin purposes and I would like > >to be able to add/update > >records from development to Crystaltech easily (There will be several users > >doing daily updates). > > > >Any feedback would be much appreciated. > > > >Rob Smith > > > > > > > > > > > > > > "Michael > > She" > > > > <michael.she@imag To: > > <[EMAIL PROTECTED]> > > ineer.net> cc: > > > > Sent by: Subject: RE: [CFTALKTor] > > ColdFusion Hosting > > owner-cfug@cfugto > > > > ronto.org > > > > > > > > > > > > 03/04/2002 > > 03:35 > > > > PM > > > > Please respond > > to > > > > CFTALK > > > > > > > > > > > > > > > > > > > >I don't think CT offers CF 4.5 anymore. They've upgraded to v5.0. > > > >Anyhow, CT is a great hosting company... I wholeheartedly recommend them... > >blah blah blah. > > > > > >---------- Original Message ---------------------------------- > >From: Jeremy Oudit <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >Date: Wed, 03 Apr 2002 12:10:13 -0800 > > > > >Does the same apply for Cold fusion 4.5? > > > > > >-----Original Message----- > > >From: Kevin Towes [mailto:[EMAIL PROTECTED]] > > >Sent: March 28, 2002 1:34 PM > > >To: [EMAIL PROTECTED] > > >Subject: RE: [CFTALKTor] ColdFusion Hosting > > > > > > > > > > > > > > >-----Original Message----- > > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > >Sent: January 9, 2002 10:59 AM > > >To: [EMAIL PROTECTED] > > >Cc: [EMAIL PROTECTED] > > >Subject: [CFTALKTor] Hosting Solutions Summary > > > > > > > > > > > >Crystal Tech's fee for ColdFusion plus SQL Server is much more expensive > > >then Experthost, but you get a bit more bang.... Here are some recent > > >comarisms that I have done.... > > > > > >CrystalTech.com (PLAN III) - USA > > >CF 5 + MSSQL2k + 450Mg = ~$CDN 970.00/yr w/$80 setup fee > > > > > >ExpertHost.com (VirtualPlan/NT) - USA > > >CF5 + MSSQL2k + 50Mg = ~$CDN 590/yr w/$25 setup fee > > > > > >GoodMedia.com (Tier 1 SQL) - CAN > > >CF 5 + MSSQL + 50Mg = $CDN 750/yr w/$50 setup fee > > > > > >REMWebSolutions.com - CAN > > >CF5 + MSSQL + 50Mg = $CDN 840/yr w$25 setup fee > > > > > >I am also analysing the following: > > >- SiteHosting.net (Solutions Plan / e-Biz Plan) > > >- RunningTide.com > > >- Pavliks.com > > >- Nexx.com > > >- Telus.ca (formally known as PSINET) > > > > > >The following local providers are out of the running due to their lack of > > >support for CF5 and SQLServer 2k > > >- UUNET / WorldComm > > >- BellGlobal (Ecommerce Hosting) > > > > > > > > > > > >- > > >You are subscribed to the CFUGToronto CFTALK ListSRV. > > >This message has been posted by: "Kevin Towes" <[EMAIL PROTECTED]> > > >To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > > >Manager: Kevin Towes ([EMAIL PROTECTED]) > >http://www.CFUGToronto.org/ > > >This System has been donated by Infopreneur, Inc. > > >(http://www.infopreneur.net) > > > > > >- > > >You are subscribed to the CFUGToronto CFTALK ListSRV. > > >This message has been posted by: "Kevin Towes" <[EMAIL PROTECTED]> > > >To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > > >Manager: Kevin Towes ([EMAIL PROTECTED]) > >http://www.CFUGToronto.org/ > > >This System has been donated by Infopreneur, Inc. > > >(http://www.infopreneur.net) > > > > > > > > > > > >- > >You are subscribed to the CFUGToronto CFTALK ListSRV. > >This message has been posted by: "Michael She" <[EMAIL PROTECTED]> > >To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > >Manager: Kevin Towes ([EMAIL PROTECTED]) > >http://www.CFUGToronto.org/ > >This System has been donated by Infopreneur, Inc. > >(http://www.infopreneur.net) > > > > > > > > > > > > > >- > >You are subscribed to the CFUGToronto CFTALK ListSRV. > >This message has been posted by: [EMAIL PROTECTED] > >To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > >Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > >This System has been donated by Infopreneur, Inc. > >(http://www.infopreneur.net) > > > > > >-=-=- > >SBG-Priority: 3 (Normal) http://www.internz.com/SpamBeGone/ > > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: Michael She <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Alan Goldberg" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
