Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• Scheduling DTS Problem

  Hi Guys, I'm running SQL SERVER STANDERD and i'm trying to schedule dts packages, but with no luck.…

  Schalk van der Merwe

  6 replies

  21 years ago

  By: SQL Draggon

• Transfering data to Oracle via ActiveX

  I have a source MSSQL database and I am pushing it to Oracle -- There are several columsn in the de…

  jG

  1 replies

  21 years ago

  By: Otto Fraunbaum

• ActiveX scipt: Permission denied on Wscript.shell

  Hi,   Windows Server 2003 Enterprise SQLServer 2000     We have a series of dts pack…

  mhanson

  2 replies

  21 years ago

  By: mhanson

• DTS suddenly unable to connect via filesystem object to shared drive

  Hello, I have a DTS ETL package running on SQL Server 2000 Enterprise SP3 on a four processor, 8GB …

  mweissx5

  2 replies

  21 years ago

  By: Angie Field

• Transer DTS to Live Environment

  Good day Everyone I have successfully transferred 50 DTS from development to live/production enviro…

  mmatseke

  2 replies

  21 years ago

  By: fperkins

• Package Fails but Step Succeeds

  Hi, We have a package that reports failure but the step itself considers itself to have succeeded. …

  steven hunt

  1 replies

  21 years ago

  By: bellis

• Importing FoxPro 7.0 into SQL Server 2000 - HOW DO I DO THIS ?

  I have been tring to import FoxPro files into a SQL Server 2000 database.  I was instructed to…

  jim Walker-138179

  12 replies

  21 years ago

  By: Anthony Ordner

• Managing Email Distribution Within DB

  I currently have 2 options for managing changes to email distribution list: (1) Open an AR tic…

  data_czar

  1 replies

  21 years ago

  By: Bob Monahon

• dts imports , records added to table randomly. not sorted as in text file

  I am looking to import 7million rows worth of data from a flat textfile. all the rows seem to be co…

  robert emoghene

  1 replies

  21 years ago

  By: Metra Christofferson

• Perfect way for transfering data

  Hi everybody, I will describe in few words the situation I need help with: We have a production ser…

  DuruG

  4 replies

  21 years ago

  By: DuruG

• DTS Transform/Package Help...

  Hello, all!  I am trying to put together a fairly basic load and transform process and am, for…

  Christopher DiOrio

  4 replies

  21 years ago

  By: Christopher DiOrio

• Prompt for connection details on installing the DTS job

  Hi, The DTS package which I am creating will reside in the destination database. I do not know the …

  rashmi-174205

  4 replies

  21 years ago

  By: rashmi-174205

• Pkg not transferring rows

  I'm using xp_cmdshell/dtsrun to execute a package in a job that (sequentially) modifies data i…

  lenny

  1 replies

  21 years ago

  By: Greg Charles

• Best file type to import from Oracle

  Wondering what file type is best to use for a regular export from Oracle and import to SQL Ser…

  StefanJ

  3 replies

  21 years ago

  By: Greg Charles

• Exporting to .csv file using DTS Designer

  Hi, I'm currently trying to get a DTS to export the results of a SQL query to a .csv file. It use…

  Paulo-176523

  3 replies

  21 years ago

  By: Paulo-176523