Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• DTS ActiveX Scripting Error

  This one has been driving me NUTS!  I have a DTS package with an ActiveX control inside that r…

  Michael Shorkey

  4 replies

  20 years ago

  By: PW-201837

• Changing a DTS package owner

  Hello all, How do you change a DTS package owner in SQL Server 7.0? Jason

  Jason Delaune

  7 replies

  20 years ago

  By: ivans

• Storing Errors for DTS transformation in table

  Hi guys, I was wondering whether there is a way of storing the errors encountered in a Copy Column …

  Saurabh Mathur

  1 replies

  20 years ago

  By: Jonathan Stokes

• Specify Output Excel file name as a parameter

  Hi all,          I have a DTS package which exports data in…

  Del Piero

  3 replies

  20 years ago

  By: Jonathan Stokes

• DTS Package problem

  Hi All i am trying to create a simple DTS package which pulls records from a Excel file netwrok dr…

  ali yakoob

  3 replies

  20 years ago

  By: mike gercevich

• Processing files in order of filedate

  Hi, I'm using DTS to read flat files into the database. If I have 2 files, the oldest file has to b…

  Nils Gruson

  4 replies

  20 years ago

  By: Nils Gruson

• User friendly way to change Server and DataBase Name in the DTS

  Hi,    As we know to change the Server Name and the DataBase Name we need to open the DT…

  VikramMullick

  5 replies

  20 years ago

  By: Jonathan Stokes

• Looping through part of a DTS Package?

  Howzit! Does anyone have any suggestions about how to loop through part of a DTS Package, breaking …

  gex

  6 replies

  20 years ago

  By: T Carnahan

• DTS loop to send each customer''s data into a separate Excel file

  I have a TSQL statement script that performs a query and saves each customer's sales data to a…

  smv929

  2 replies

  20 years ago

  By: smv929

• Copying 3 Million Rows

  Hi All I need to transfer 3 Million rows from Source to Destination SQL Servers. What is the fastes…

  arun-246337

  6 replies

  20 years ago

  By: alexx

• Running WMI scripts in DTS package

  I am working on a WMI script using VBScript and running from a command line to obtain information r…

  Lynn Pettis

  2 replies

  20 years ago

  By: Lynn Pettis

• Excel Files To A CSV

  I have a situation where I need to take a number of excel files and worksheets and combine them int…

  Jody Wood

  2 replies

  20 years ago

  By: Jody Wood

• SQL Server name changed

  Hi, One of my company client has changed there database name.Now the problem is , we have 45 DTS pa…

  raj-247939

  6 replies

  20 years ago

  By: raj-247939

• DTS Package error- Exception Occured error when opening DTS Designer

  All, Anyone know what would cause this error "DTS Designer: Exception Occured" when openi…

  davidsalazar01

  1 replies

  20 years ago

  By: mike gercevich

• DTS Table Data from Oracle to SQL Server.

  Is there a way to use DTS to transfer data from an Oracle table to SQL Server table getting only th…

  DarylAndDaryl

  1 replies

  20 years ago

  By: Ray M