Sponsored White Papers, Webcasts, and Downloads
- BNET Industries
- DTS is a provider of branded entertainment technologies, which are incorporated into an array of entertainment products by licensee customers. Co.'s digital multi-channel audio technology...
- DTS Inc. company page on BNET »
TechRepublic Resources
- Arlington County: Providing IP-Based Videoconferencing Services to an Entire County
- Arlington County, Virginia is located directly across the Potomac River from Washington D.C. Being at the center of the Washington D.C. metropolitan area, Arlington County serves as a base for many tourists visiting the area. The Institutional Network INET is a key element of Arlington County's e-Government strategy. DTS operates...
- Tags: Video Conferencing, IP, Stryon iNET, DTS, E-government, Network Technology, Networking, Government
- Case studies
- Customize Data Transfers with SQL Server
- DTS is a set of related tools that enable you to manipulate or transform data from various sources. To create a DTS package, you can use the DTS wizards to move data. You can also use the more advanced DTS Designer, which lets you create a multitude...
- Tags: Database, Package, Microsoft SQL Server, Server, DTS, Microsoft Excel, Storage, Databases, Microsoft Office, Office Suites, Software, Hardware, Enterprise Software, Data Management, Steven Warren
- Blog posts 2007-12-19
- DTS & SSIS Diagrams
- Tim:I've asked this question on a couple of boards and got no response thus far.What form, file, language etc are the DTS & SSIS diagrams in and how do I get at them?I would like to access the actual graphic file and reuse it on another MS Program PopflyAny insight...
- Tags: Databases, john.webb@..., SSIS, DTS
- Discussion threads 2007-11-09
- modify records in one sql server which is differ from anothe server by DTS?
- Hi all,currently, I've been incolved in a data migration project. The objective is synchronize the sales invoice from one server to another server by DTS! And Now, I can use DTS to tranfer data between these two servers. But I just want to appending the new invoice without duplicate records....
- Tags: SQL, jle@..., DTS, server
- Discussion threads 2007-07-02
- Optimize the performance of Microsoft Operations Manager 2005 (MOM): Configure, monitor, and troubleshoot the DTS package
- Microsoft Operations Manager MOM uses the DTS package to transfer data from the OnePoint operational database to the SystemCenterReporting archive datawarehouse database. Archiving old data from the OnePoint database to the SystemCenterReporting database keeps the OnePoint database small and streamlined, thus improving the performance of MOM....
- Tags: Monitor, Performance, Microsoft Operations Manager, Microsoft Corp., DTS, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Download resources 2006-12-19
- Enterprise Manager, DTS 2000 - Set Maximum Characters per column.
- Hi,Enterprise Manager, DTS 2000 - Set Maximum Characters per column. I have a query which is okay when i run via Query Analyzer 2000 becuase I set the limit via Query Analyzer 2000: Tools - Options - Results - set maximum characters per columnBut when I create a DTS package...
- Tags: ismailc@..., DTS, Enterprise Manager
- Discussion threads 2007-04-26
- DTS projects
- Hi all, I'm currently learning DTS and wanted to get some practice in package building, so as to better understand the product and packages I'll encounter in new production environments. If anyone knows a site/source showcasing a wide spectrum of DTS projects, preferably already in production, I'd be grateful for...
- Tags: czaroftime@..., DTS
- Discussion threads 2007-04-09
- Importing data from Progress to SQL Server 2000
- I need to import Data from a 'Progress' db to SQL2000 db.In SQL, I have set up a local DTS package 'Progress_Data' which links a 'Progress' database to SQL2000.If I right click the local package and select 'All Tasks', then 'Import Data', the 'DTS Import/Export Wizard' window appears.I select the...
- Tags: Databases, thomas.forrest@..., Microsoft SQL Server, Microsoft SQL Server 2000, DTS, File DSN, Unexpected Error, DTS Package, SQL2000
- Discussion threads 2007-04-04
- Committing imports in SQL Server a little at a time
- Learn how Arthur Fuller helped a colleague, who was working on an Informix database and needed to search TEXT columns using wildcards. Check out the simple solution to this seemingly perplexing problem. A colleague working on an Informix database needed to search TEXT columns using wildcards. While Informix...
- Tags: Microsoft SQL Server, Informix Software, Databases, Arthur Fuller, DTS, Commit Final Batch, text-file, server, SQL Server Newsletter, TechRepublic Inc., Option, TEXT, Enterprise Software, Software, Data Management
- Technical articles 2006-07-31
- SQL Server Management Studio Express and Backwards Compatibility
- I downloaded the SQLServer2005_DTS.msi install and ran it on a workstation that has Microsoft SQL Server Management Studio v.9.00.1399.00installed and I was able to see the legacy Sql Server 2000 packages on another server. Works Great! My Issue is w
- Tags: programming, sql server, software, business@..., Microsoft SQL Server Management Studio, Microsoft SQL Server, DTS, server
- Discussion threads 2006-11-30
- SQL Server 2000 Replication
- I'm looking at building a reporting server to help take some load off one our production SQL servers. Does the replication setup make any changes to the tables or databases that are going to be replicated? Are columns added to the tables replicated? How does SQL server...
- Tags: database, DTS, it management, Microsoft SQL Server, Microsoft SQL Server 2000, programming, replication, server, smittyrt@..., software, sql server
- Discussion threads 2006-10-11
- DTS Designer (Customize data transfers with DTS and SQL Server)
- take us into your system with a text cartoonicon link to explanation {chapter/book/cartoon} thenwhen we are in we will see how it works !!!!!Don't bother, MS have killed it.With 2005 it's now SSIS, completely changed.Note you do get a wizard to migrate existing packges but it may stumble on complex...
- Tags: DTS, DTS Designer, hardware, info, lawrephord10@..., Microsoft SQL Server, server, SSIS, tutorial
- Discussion threads 2006-09-23
- SQL Server 2000 data replication issue
- We currently have a production installation of SQL Server 2000 Enterprise Edition that has a 40 gig database that is hit heavily. I am setting up another installation of SQL 2000 to host a read only copy of the production database to strictly run reports. The data will...
- Tags: bhendrix@..., data replication, DTS, Microsoft SQL Server, Microsoft SQL Server 2000, networking, read only
- Q&A 2006-09-20
- Customize data transfers with DTS and SQL Server
- DTS is a set of related tools that enable you to manipulate or transform data from various sources. To create a DTS package, you can use the DTS wizards to move data. You can also use the more advanced DTS Designer, which lets you create a multitude of packages and...
- Tags: tool, multitude, DTS, Microsoft SQL Server, workflow, server, FTP, scripting language
- Image galleries 2006-09-13
- Customize data transfers with SQL Server
- DTS is a set of related tools that enable you to manipulate or transform data from various sources. To create a DTS package, you can use the DTS wizards to move data. You can also use the more advanced DTS Designer, which lets you create a multitude of packages and...
- Tags: DTS, DTS Designer, Microsoft Excel, Microsoft SQL Server, server
- Blog posts 2006-09-11
- SQL2000: DTS Query Task - Return Value
- In SQL Server 2000, in DTS, a SQL Query Task executes a stored procedure that returns 0 or -1. Either value causes a Workflow property of success, but I require two different actions. I do not want to cause the package to fail for example with raiseerror. ...
- Tags: Databases, DTS
- Q&A 2006-08-19
- SQL 2005 DTS
- I've tried everything I can think of. Can't get DTS to work in SQL Server 2005. I get this error every freakin time!'Violation of PRIMARY KEY constraint 'PK_Alerts'. Cannot insert duplicate key in object 'dbo.Alerts'.Sometimes it's a foriegn key. I can't figure this out. I try to have DTS drop...
- Tags: Databases, DTS
- Discussion threads 2006-06-26
- Prepare the Copy (Use DTS to Migrate an Access Database to MSDE)
- Can't find a......"report a broken link page" or something... I noticed that the image on page six is corrupted. I ave provided the link:http://content.techrepublic.com.com/2346-10877_11-0.html?galleryId=1124&seq=6
- Tags: Copy, DTS, Prepare, Access Database, Migrate, access, sql, Use DTS, yanipen@..., hardware, Microsoft Access, Microsoft Data Engine, database
- Discussion threads 2006-06-21
- Use DTS to Migrate an Access Database to MSDE
- With an aging homebrew helpdesk system increasingly experiencing speed and usability issues, database admins on a budget ($0) find a simple, affordable, and effective solution by using Microsoft Data Transformation Services DTS to migrate the backend Access database to Microsoft Data Engine MSDE. This gallery shows you the migration process.
- Tags: Access Database, database, DTS, help desk, Microsoft Access, Microsoft Corp., Microsoft Data Engine, migration
- Image galleries 2006-06-15
- What DVD/scene to use when shopping for speakers?
- What DVD/scene to use when shopping for speakers?Back in the day (i.e., pre-Internet Bubble) I was told to bring a copy of "Star Trek: Generations" when I went shopping for new speakers. The scene where the Enterprise crashes onto the planet has everything–dialogue and music playing above the gigantic booming...
- Tags: speaker, speakers, dvd, RexWorld, off-topic, DTS, movie
- Discussion threads 2006-03-06