Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• DTS Lookup vs. ActiveX ADO connection

  In general, which will perform better? I'm dealing with several thousand records and creating summ…

  sbeal

  2 replies

  23 years ago

  By: sbeal

• DTS Job Failure

  Hello, I have SQLServer7.0 on Win2K platform. When I'm running a manual process from one DTS packag…

  AER

  2 replies

  23 years ago

  By: AER

• VB Script not completing Active X Script

  I have the following VB Script in an ActiveX step for DTS. The script simply uses FSO to move a bak…

  jG

  3 replies

  23 years ago

  By: jG

• How to migrate DTS from a prod to test server?

  I'm getting the below error when trying to update a job after restoring msdb from a backup on my pr…

  jsqldba

  5 replies

  23 years ago

  By: jsqldba

• Data extraction and purging

  I need to purge 3 related history tables on regular basis. I want to extract the data to flat file …

  ASHOKSKUMAR

  3 replies

  23 years ago

  By: mhweiss

• Cleaning Data files before running DTS

  I have a DTS package that takes a text file and inserts it into a table. The problem that is occurr…

  kbrady

  8 replies

  23 years ago

  By: kbrady

• DTS Load Speeds

  Hi All Just wondering if anyone can give some idea on DTS speeds given different execution methods.…

  philcart

  4 replies

  23 years ago

  By: scotttr

• "InsertSuccessFunctionEntry" ? Where Is It ?

  I have a package that exports data from the database into text files. At the bottom of the file it …

  Crafty

  1 replies

  23 years ago

  By: mhweiss

• Changing the Source File in DTS

  I am desperately trying to create a DTS package that imports an Excel spreadsheet (that has 5 works…

  jdoering

  9 replies

  23 years ago

  By: mhweiss

• DTS strips primary keys

  Does this happen to anyone else? Is there a setting I can use (when I HAVE to run DTS) that will m…

  lbethel

  1 replies

  23 years ago

  By: Steve Jones - SSC Editor

• Import file with date-time stamp naming convention

  Hello everyone. I'm new at this and I've been looking for a way to import a delimited text file in…

  ShogoC

  1 replies

  23 years ago

  By: ShogoC

• Change Computer/SQLServer Name

  We have a production server (say, computer name A, and SQL Server name A) that has been giving us b…

  WesJ

  2 replies

  23 years ago

  By: K. Brian Kelley

• Copying DTS Packages to another server

  I can successfully "Save as..." to another server. However, if I try to open the package on the ta…

  anthony dintino

  6 replies

  23 years ago

  By: moakesr

• DTS Object Error

  I am having a problem with one of my packages. I have a package that runs fine on my machine, but …

  kpowers

  4 replies

  23 years ago

  By: kpowers

• DTS FTP Task from Mainframe

  I am trying to use the FTP Task within a DTS Package to copy a file from the Mainframe (OS390). We …

  HookSQLDBA7

  2 replies

  23 years ago

  By: AnzioBake