TechRepublic : A ZDNet Tech Community

32 Resources for

dts

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

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
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
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
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 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
SQL Server Dates Pre 1900
I am using DTS to transfer data from a Progress database to SQL Server 2000. Unfortunately, due to poor data collection, there are dates prior to 01/01/1900 in the progress database that cause the process to fail (I believe due to the fact that SQL does not support dates prior...
Tags: dateTime, Microsoft SQL Server, munrrob, programming, server
Q&A 2006-01-30
HOW-TO: SCHEDULE A JOB FROM WITHIN VB6
Hi,I have recently created a VB6 application that provides a list of available DTS Packages on the SQL Server 2000 database to the user and allows them to execute the package. Although the function works fine, there is a need to have the task schedule to execute at a later...
Tags: DTS, fsanchez@..., job, Microsoft Visual Basic 6.0, software
Q&A 2005-11-12


Quick Reference: Linux Commands
Reduce stress and speed up resolutions with the easiest command references right at your fingertips. You'll receive a PDF file covering Linux, packed with the most common commands you'll need and use daily.
Buy Now
500 Things Every Technology Professional Needs to Know
Did you know Microsoft's RegClean does not work with XP but you can use shareware to clean your registry? Did you know most wireless access points don't have encryption enabled by default? Did you know there are 500 tidbits of information contained in TechRepublic's 500 Things Every Technology Professional Needs to Know that will help you become a successful IT professional.
Buy Now