Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• differiniate quotes as data vs quotes as column identifier

  I need to import (using DTS) some comma delimited text files into sql server 2000. I have discovere…

  BobMcC

  45 replies

  16 years, 9 months ago

  By: Ghanta

• DTS-Excel result-Two decimal places

  Hi, I created the following table and defined this table in DTS-Transform-Data-Task-Properties to i…

  petersobeco

  5 replies

  16 years, 10 months ago

  By: Avijeet

• Union all

  Hi I am supposed to combine the data coming from two different sources in DTS, is there any task s…

  lucky.su

  1 replies

  16 years, 10 months ago

  By: Alvin Ramard

• DTS Active Script Issues..Help Required

  Hello Gentlemen, I have the following piece of simple of DTS Activex Script. Excuse me for my ignor…

  DP-721271

  2 replies

  16 years, 11 months ago

  By: Elliott Whitlow

• Missing parameters in Output Parameters tab

  I have a stored procedure which has one input and two output parameters. I am calling the parameter…

  stopitallready

  1 replies

  16 years, 11 months ago

  By: stopitallready

• Dynamic Connection

  Hi I am new to DTS. I designed package with some ExecuteSQLTask. I have to deploy it in several lo…

  Soundari

  4 replies

  17 years ago

  By: Soundari

• Write all the file names in a folder to a log file and append "END" statement

  Hi , I am using DTS to create files and dump into a folder and at a same time I need to use Active…

  pcq0125

  2 replies

  17 years ago

  By: pcq0125

• VB ActiveX script error "Invalid column name 'True'" in DTS job

  I've written a DTS job that uses vbscript to extract data from an Informix database and then insert…

  mmcardle

  1 replies

  17 years ago

  By: mmcardle

• T-SQL/stored procedure/dtsrun data type error when passing parameters

  I'm having some fun with passing parameters from T-SQL to a stored procedure in SQL 2000 which then…

  mmcardle

  4 replies

  17 years ago

  By: davidlee01

• Move Data

  I am trying to move the data from one table to a new table in a new database. However, the primary …

  bpowers

  4 replies

  17 years ago

  By: Steve Jones - SSC Editor

• Help to Convert DTS code compatible with SQL 2005

  Hi there! Newbie here. We have migrated from SQL 2000 to SQL 2005. However, DTS in SQL 2005 has rea…

  John Mark R. Asi

  1 replies

  17 years ago

  By: John H Marsh

• DTS Package execution fails Error (800403FE)

  I wrote a VBScript to reduce the amount of records in a table with currently 25 Million records (10…

  Andre Beier

  5 replies

  17 years ago

  By: Rao.V

• system cannot find the path specified for a dts scheduled job

  Error opening datafile: The system cannot find the path specified I have a dts package the when sch…

  Pete Peters

  3 replies

  17 years ago

  By: ebenraja

• Excel files with different names into SQLServer2k using DTS

  Hi, I am fairly new to SQL Server 2000 and I am trying to import excel files from a particular fold…

  SQLNewbie-1002660

  3 replies

  17 years ago

  By: manolomalaga

• Can DTS on a 2000 box write to a SQL 2005 database

  Can DTS on a 2000 box write to a SQL 2005 database? Note the DTS package will continue to run on S…

  thecodeguys

  1 replies

  17 years ago

  By: Greg Charles