Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• Running dts packages as Legacy Code in SQL 2k5

  We have recently had an sql server upgrade and server upgrade at work with. I transferred Old Dts …

  eseosaoregie

  2 replies

  15 years, 6 months ago

  By: Steve Jones - SSC Editor

• DTS PACKAGE ERROR

  I currently have 2 dts packages that are used to send output to various Excel spreadsheets. In the …

  eseosaoregie

  1 replies

  15 years, 6 months ago

  By: WebTechie

• DTS Error --- Error string: The file exists

  I have developed a DTS job which is running fine if execute it by right clicking on it. But wheneve…

  Rajarshi Mukherjee

  22 replies

  15 years, 7 months ago

  By: Jeffrey.Simmons

• Step at intersection of different paths in DTS does not execute

  Hi, I have a simple scenario (shown in the attached file). Basically the execution path of my DTS r…

  Elias Mouchantaf

  2 replies

  15 years, 7 months ago

  By: Elias Mouchantaf

• DTS- Incorrect syntax near Insert

  This is kind of weird. There is Execute SQL Task in the first step inside the package which creates…

  SqlSavvy

  2 replies

  15 years, 7 months ago

  By: Lowell

• Failed to initialize the Common Language Runtime (CLR)

  I am having difficulties creating an Assembly for a vb.net project I have written. I am getting the…

  Matthew Radford-1043891

  2 replies

  15 years, 7 months ago

  By: Matthew Radford-1043891

• Change Path of Files (.mdb, .xls, .txt)

  Hi, (sorry for my english, I'm from Switzerland) I need to change the DataSource of several files i…

  hund123

  1 replies

  15 years, 7 months ago

  By: hund123

• Moving DTS packages from one SQL server 2000 to another SQL 2000 server

  Hi Anyone have an idea how to move all the DTS package from one server to another. i.e. I have more…

  r_prasanna82

  2 replies

  15 years, 7 months ago

  By: r_prasanna82

• Migration of DTS to SSIS

  Hi All, I have 500DTS Package from SQLServer 2000 and i want to migrate it to SQLServer 2005.Is the…

  jayasree.lingala

  1 replies

  15 years, 7 months ago

  By: Greg Charles

• DTS Copy Objects Task - Dynamic Destination

  I have a DTS package that contains a 'Copy SQL Server Objects' task. The source database is remote …

  crimsonie

  1 replies

  15 years, 8 months ago

  By: Steve Jones - SSC Editor

• DTS Package hangs and run for ever when Schedule as a JOB

  I havea simple DTS package which execute a .bat file on local server EXECUTE PROCESS TASK has the c…

  Redmond01

  1 replies

  15 years, 8 months ago

  By: John H Marsh

• Automated E-Mail

  Can anyone provide me with a really simple example of a DTS package, that sends an automated email …

  dave-dj

  8 replies

  15 years, 8 months ago

  By: dave-dj

• DTS to load huge data into table

  Hi, I am using DTS package for loading data from text file into a table where it loads huge number …

  NS-442483

  7 replies

  15 years, 8 months ago

  By: Ray M

• Running & Maintaining DTS on SS 2005?

  OK, so now the managers have decided that in order to get from SQL Server 2000 to 2005 faster, we w…

  Angry Boy

  3 replies

  15 years, 8 months ago

  By: saravanan_venkatesan

• Microsoft Script Debugger

  Hi i'm very much a newbie to this but i've been having problems with Microsoft Script Debugger whil…

  matthew_perry

  2 replies

  15 years, 8 months ago

  By: matthew_perry