Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• Error while doing a DTS as job

  I select rows from a table an export that to an txt file. this txt file is saved on an other server…

  markuss21

  1 replies

  20 years ago

  By: allen davidson

• Text File (Destination) is only reporting 256 characters

  I have created a DTS package that exports data from my database to a text file. The column that is …

  Keith Tate

  2 replies

  20 years ago

  By: Keith Tate

• Oulook Locks Up

  Im adding an send mail task into my DTS packages everything works fine. But it looks like sometimes…

  JM-92548

  1 replies

  20 years ago

  By: philcart

• SQL Server 2000 DTS

  I need to insert data from server a into a table on server b, but only if the table on b is empty. …

  Darren Taylor

  3 replies

  20 years ago

  By: Greg Charles

• Can DTS be used to invoke .bat file?

  Hi, I have a job to be scheduled each month. But the task is java dependent also. Is it possible to…

  pradeepa kannan

  4 replies

  20 years ago

  By: bledu

• DTS Fails reports failure when scheduled, but does what it is supposed to do

  I have a DTS package that runs a VBscript that uses DMO to script out all our non system stored pro…

  Adam Angelini

  3 replies

  20 years ago

  By: Adam Angelini

• Err found in job history and event viewer?????

  Hello friends..I need some help regarding error..... I have DTS package scheduled to run...whenever…

  Papillon

  3 replies

  20 years ago

  By: Paul Rubel

• Cant find the not function in dts vbscript!

  Hi I am writing some vbscript tasks in a dts package and want to use the NOT function. However it d…

  AlfredEnewman

  3 replies

  20 years ago

  By: Russell Shilling

• Enabling and Disabling task using Activex Ecript

  Hi Will any one please tell em how top enable or Disable particular task using Activex script

  aditya mandlekar

  3 replies

  20 years ago

  By: aditya mandlekar

• DTSLookups - Performance question?

  I am looking at a DTS package that imports a text file and performs 3 separate DTSLookups as the re…

  David.Poole

  4 replies

  20 years ago

  By: PW-201837

• Format string before loading data

  Hi experts, I want to load a text file into a SQL Server 2000 table by DTS. One column in the text …

  jenniferhu46

  2 replies

  20 years ago

  By: Peter Schott

• How t0 ----Data Driven query tasks to update columns

  Does anyone know where I could find an article detailing the steps needed to use the data driven qu…

  mngong

  1 replies

  20 years ago

  By: mngong

• MANUAL RUN OF SAVED DTS

  I want to save a DTS (text to Microsoft ODBC driver for SQL SERVER) and be able to run int manually…

  Homero Muñoz

  4 replies

  20 years ago

  By: Homero Muñoz

• connecting access database from sql query analyser

  Hi All, i do have a the data in the microsoft access database that needs to be accessed on the dail…

  suresh-216682

  3 replies

  20 years ago

  By: k-293946

• passing in a stored proc parameter at runtime

  I have an Execute SQL task which calls a stored procedure.  The sp has one input parameter tha…

  Alee-235113

  1 replies

  20 years ago

  By: philcart