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

342 questions
0
votes
1 answer

Import data from Excel to Master detail tables in SQL Server

I have an excel sheet that has Four Columns SaleID, SaleDate,PersonID, ProductID, SaleQuantity,UnitRate I want to import this data in one to many relation table such that each person sale should be recorded saparately. My tables are as follows Sale…
Tassadaque
  • 8,129
  • 13
  • 57
  • 89
0
votes
2 answers

why can not i see onerror event in dbo.sysssislog table

I have run an ssis package and got error in one of the tasks(the task is inside a sequence container).But when I checked the msdb sysssislog table i could not see any ONERROR event(ONERROR) over there.let me know what might be the reason.Please be…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

How to compare DTSs in SQL Server 2005

Once your databases are converted from SQL Server 2000 to SQL Server 2005, is there any way to compare DTSs on two servers to see if they are still essentially the same? I need to see if my dev and prod are the same, and comparing them manually is…
thursdaysgeek
  • 7,696
  • 20
  • 78
  • 115
0
votes
1 answer

DTS Connections Error

I'm receiving this error while attempting to execute a package: "The connection is currently being used by a task. The connection cannot be closed or reused." Any ideas?
andyhky
  • 1,798
  • 1
  • 17
  • 30
-1
votes
3 answers

SSIS Package Deployment -DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

> [OLE DB Source [113]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "msAccess" failed with error code 0xC0202009. There may be error messages posted …
user9062231
-1
votes
3 answers

Move data accross SQL Servers with DTS packages or linked servers

We are using SQL Server 2000 and have to move data across servers to store it in a central database. We would rather not use DTS packages because we will move to SQL Server 2005 soon, and we don't want to have to upgrade to SSIS or have to support…
Jim
  • 11,229
  • 20
  • 79
  • 114
-1
votes
1 answer

How to save DTS package on windows with SQL Server 2008?

I installed SQL Server 2008 standard on windows 7. Then I can run legacy DTS package wizard from C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\DTSWizard.exe. I tried to export for this case. At the end of the wizard, I want to save DTS…
KentZhou
  • 24,805
  • 41
  • 134
  • 200
-2
votes
1 answer

Visual Basic Time Variable for DTS packages

I am converting some DTS packages over from Visual Basic to C# and am wondering what @OldDate the following would produce. I am not a VB.NET guy and really do not have the time to play around with this..and it has to be correct so I am reaching out…
BSchnitzel
  • 136
  • 2
  • 15
-2
votes
1 answer

How to log out SSIS package information in c#

I have managed to get my application to run my test SSIS package but I want to be able to retrieve information that it returned I.E Time spent to run etc. Here is how I am executing the package: //EXECUTES THE…
Ben Clarke
  • 1,051
  • 4
  • 21
  • 47
-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
  • 903
  • 7
  • 22
  • 43
-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
  • 11
-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
…
22
23