Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• DTS failed when schedualed to a job

  platform: Win 2k Server, MSSQL server2k std edition: Log on to SQL server as local admin, create a …

  YuanQiang

  3 replies

  21 years ago

  By: YuanQiang

• Data conversion during import

  I am importing a text file from a legacy system. This file contains a field that is the paid amount…

  Wilfredo Santana

  4 replies

  21 years ago

  By: David Burrows

• Error while running DTS package

  Hi All, I have created a DTS package which copies the data from Ingres table to SQL Server 2000 tab…

  Ansari Asif

  3 replies

  21 years ago

  By: Metra Christofferson

• DTS import text from Oracle truncating at 100 characters

  I need to import an Oracle memo field into a SQL Server text field, and it works just fine... as lo…

  Metra Christofferson

  14 replies

  21 years ago

  By: Metra Christofferson

• Dynamically set the value of the Inner Global Variables

  Hi,   How can I dynamically set the value of the Inner Global Variables?   The idea is to…

  Tiago Rente

  3 replies

  21 years ago

  By: Jonathan Stokes

• Using DTSGlobalVariables directly from T-SQL commands and calls

  I wish to create a global variable either by entering it on the global variable tab or thru a VB Ac…

  Duane Kiser

  4 replies

  21 years ago

  By: jfb

• Use existing connection is activeX script

  Can you use an existing connection used in a transformation in a later activeX script within the sa…

  camlern

  1 replies

  21 years ago

  By: Jonathan Stokes

• DTS default configuration

     I often use DTS tool to refresh databases between the servers. When you choose "Transf…

  alark

  1 replies

  21 years ago

  By: Greg Charles

• bit vs tinyint vs char(1)

  I'm setting up a new database and am wondering if I should use bit, tinyint or char for a field tha…

  Vernon Reeve

  13 replies

  21 years ago

  By: Alex Wilson-148544

• DTS Hanging (in ActiveX Script Task when calling another DTS)

  Our system gets feeds from a number of different vendors.  Most of the files I just grab from …

  Brian Cidern

  3 replies

  21 years ago

  By: Metra Christofferson

• Import string to float error in .csv file

  Hi all: I do not have a lot of experience with DTS and would appreciate some help.  I am havin…

  Vee Dee

  2 replies

  21 years ago

  By: Vee Dee

• Errorcodes in msdb.sysdtssteplog

  Hi, I have a DTS package where I copy the whole database (tables and views) to another. Someti…

  Zoran Urumovic

  2 replies

  21 years ago

  By: philcart

• Retrieve GlobalVariables in an ExecuteSQLTask

  Hello there, How do you retrieve values from your global variables inside an ExecuteSQLTask? someth…

  Rafferty Uy

  7 replies

  21 years ago

  By: Brian Cidern

• Saving DTS Packages

  Hello Everyone! We are going to re-install SQL Server 2000 and I was wondering how I could save my …

  Robert A. Shannon III

  4 replies

  21 years ago

  By: Alamir

• Dynamically set DTSDestination column name from variable

  I need to be able to set the DTSDestination column dynamically using a variable for the column name…

  camlern

  2 replies

  21 years ago

  By: camlern