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
3
votes
5 answers

Is there a simple way to Copy SQL Server 2000 DTS package and deploy it in another server?

I am trying to copy a database from one server to another in id different location, including all the schema, data, DTS Package and Scheduled Jobs. I used Redgates SQL Packager to pack the schema and data.But I am having trouble in packing the DTS…
Elias Haileselassie
  • 1,325
  • 1
  • 18
  • 26
3
votes
5 answers

DTS Package sql job

Ive never used sql jobs or dts. What does.. N'DTSRun…
Beginner
  • 25,463
  • 62
  • 148
  • 228
3
votes
4 answers

How can I create a human-readable script for every DTS package on a SQL server?

I know I can edit each individual DTS package and save it as a Visual Basic script, but with hundreds of packages on the server, that will take forever. How can I script them all at once? I'd like to be able to create one file per package so that…
Daniel
3
votes
1 answer

Dtexec ISSERVER returns is not a valid server package path

I am executing a SSIS package via master..xp_cmdshell from a stored procedure and I am always getting the error "Description: '\SSISDB\Main\Projects\ProjectName\Packages\PackageName.dtsx' is not a valid server package path." I tried various…
Arvindakshan
  • 61
  • 5
3
votes
1 answer

Deploying custom SSIS connection manager failing with '...is not recognized as a valid connection manager type'

I have made a custom SSIS Connection Manager (.NET 4.6.2): namespace HelloWorldCm { using Microsoft.SqlServer.Dts.Runtime; [DtsConnection( ConnectionType = "HELLOWORLD", DisplayName = "Hello World Connection Manager", …
Charlotte Skardon
  • 6,075
  • 2
  • 28
  • 40
3
votes
1 answer

The path for 'ISServerExec.exe' cannot be found when deploying a project

I am working on jobs currently and when I want to deploy my project I am receiving the following error. I tried to check the DTSPath but I wasn't able to find it under the following path "go to regedit->HKEY_LOCAL_MACHINE->SOFTWARES and under…
Amira Bedhiafi
  • 6,070
  • 6
  • 17
  • 48
3
votes
0 answers

Convert Aliased Paths in TS Declarations Files when Building with Webpack

Why imported modules in generated .dts files are preserving the aliased paths from tsconfig.json in paths option? How to fix it? Actual: @/codes/classes/apollo (which cannot be resolved from my builds folder) Expected: ./classes/apollo (which can be…
geeko
  • 2,278
  • 1
  • 27
  • 44
3
votes
3 answers

Execute an SSIS Package created with VS2008 on SQL Server 2005

Maybe a stupid question but... I created an SSIS package using VS2008 Professional. I want to deploy and execute it on a server running SQL Server 2005. When I try to run it I get an error stating the version of the Execute Package Utility on the…
Wayne Molina
  • 17,811
  • 24
  • 93
  • 156
3
votes
4 answers

Where does SQL Server store the DTS packages?

I have created a few DTS packages and saved them on the server. where I can edit these DTS packages on the server?
Sheehan Alam
  • 57,155
  • 123
  • 348
  • 546
3
votes
1 answer

PCI nodes in Device Tree

Is it necessary that the nodes shown in "lspci" output, have to be defined in device tree ? I have device tree file for P2041RDB. In that only one node is created for pci i.e. bus 0. Now I have customized the reference board and connected one…
Savan
  • 78
  • 1
  • 8
3
votes
3 answers

Does anyone know of a way to migrate DTS to SSIS?

Are there any tools available for this type of package conversion?
wil
  • 31
  • 1
3
votes
2 answers

SSIS XMLSource only seeing null values in XML variable

I have a Data Flow task with an XMLSource that references an XML Variable. The DataFlow task does recognize that there are x number of rows in the variable, but it only sees null values in every row: The xml variable value:
DShultz
  • 3,983
  • 3
  • 24
  • 34
3
votes
1 answer

DTS/SSIS vs. Informatica Power Center

I'm sure that this is a pretty vague question that is difficult to answer but I would be grateful for any general thoughts on the subject. Let me give you a quick background. A decade ago, we used to write data loads reading input flat files from…
Chad
  • 21,566
  • 46
  • 173
  • 299
3
votes
3 answers

Open a .BAS DTS Package in SQL 2000?

You can save a SQL Server 2000 DTS package as a VB .BAS file. Is is possible to open a .BAS file in SQL Server Enterprise Manager (or some other way) to add the DTS package to the server? Initally, it appears that SQL Server only lets you import…
Jim
  • 10,765
  • 17
  • 74
  • 114
3
votes
4 answers

How do I convert DTS packages to SSIS packages?

I'm looking for tutorials or walkthroughs for converting DTS packages into the new SSIS 2005. Any one knows.
Malik Daud Ahmad Khokhar
  • 12,720
  • 24
  • 75
  • 81
1 2
3
…
23 24