Stack Overflow
Stack Overflow

Questions tagged [dts]

Data Transformation Services, or DTS, is a set of objects and utilities to allow the automation of extract, transform and load operations to or from a database. The objects are DTS packages and their components, and the utilities are called DTS tools. DTS was included with earlier versions of Microsoft SQL Server, and was almost always used with SQL Server databases, although it could be used independently with other databases.

Data Transformation Services, or DTS, is a set of objects and utilities to allow the automation of extract, transform and load operations to or from a database. The objects are DTS packages and their components, and the utilities are called DTS tools. DTS was included with earlier versions of Microsoft SQL Server, and was almost always used with SQL Server databases, although it could be used independently with other databases.

More information: http://en.wikipedia.org/wiki/Data_Transformation_Services

348 questions
-2
votes
4 answers

Merge data from 2 tables into one

I have Employees and Non Employees tables (data is being imported from views). Now, I need to create a single table which holds both Employee and Non Employee data. I am unable to progress from here. I am getting this error when I try it using…
Aruna Raghunam
  • 823
  • 4
  • 20
  • 38
-2
votes
1 answer

import data from dts to ssis

I got asked to migrate DTS to SSIS. As I've never seen this in my life, I started looking in here and here! This got me started but I still don't know how to integrate this and run it in my project. Does anyone know of a good tutorial about DTS to…
msenos
  • 39
  • 1
  • 10
-3
votes
1 answer

How to copy txt/ doc File

I want to copy a txt file from one folder to another. While coping i need to check whether the file exists or not, if yess then replace the file.
Asif Iqbal
  • 1
  • 1
1 2 3
…
23
24