Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- 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...
- 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...
- 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....
- 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...
- 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...
- 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...
- 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
- 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...
- 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...
- 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...
- 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...
- 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...
- 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. ...
- 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...
- 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...
- 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
- 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.
- 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...
- 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...
- 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...
- Q&A 2005-11-12
- << Previous
- page 1 of 2
- Next >>
Content Types
Refining Tags
- Microsoft SQL Server (13 results)
- server (11 results)
- Software (10 results)
- SQL (8 results)
- Hardware (7 results)
- programming (7 results)
- database (5 results)
- Microsoft Corp. (4 results)
- Microsoft Excel (4 results)
- kaypaul@... (4 results)
- Databases (3 results)
- Enterprise Software (3 results)
- job (3 results)
- Microsoft SQL Server 2000 (3 results)
- Data Management (3 results)
- sql server (3 results)
