Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• Trigger does not fire during DTS import

  Hi All, When I execute a DTS import the trigger does not fire that's in the table. Is there anybody…

  aldero

  4 replies

  22 years ago

  By: aldero

• Export to Excel

  I have written a DTS Package to export to Excel. This works perfectly except I wish to overwrite th…

  StefanJ

  2 replies

  22 years ago

  By: StefanJ

• DTS - General Network Error

  Getting the following message in the DTS package log when running one specific DTS package out of 4…

  biz2024

  4 replies

  22 years ago

  By: YOGIG

• Excel

  Sorry I stuck this in the wrong forrem before. When I import from Excel into SQL Server 2000 using …

  mcoffey

  2 replies

  22 years ago

  By: rprice

• DTS File Transfer Protocol Task

  Hello, I am trying to put the ftp task on the end of my DTS package, and transfer a file from the l…

  Cyrus.Au

  19 replies

  22 years ago

  By: Cyrus.Au

• DTS / Bulk Copy failed

  I have set up a DTS package with the option to copy all database objects. The core aspects of the p…

  jweyl

  1 replies

  22 years ago

  By: philcart

• "fail package on step failure"

  I'm looking way to find which objects in my DTS packages are with properties "fail package on step …

  mirekg

  5 replies

  22 years ago

  By: MegaDBA

• using a script to move data

  Dear all, Please let me give you a brief history of what is going on and then ask how you can help …

  simflex

  6 replies

  22 years ago

  By: simflex

• Wishlist: Cut&Paste multiple dts objects

  Perhaps it's already been mentioned as a wish list item, but at the top of my list would be the abi…

  Bill Nye

  1 replies

  22 years ago

  By: philcart

• CSV to Oracle Error

  Hi All, im trying to upload a CSV file using DSN connection to Oracle database using DTS. it some…

  thyravi

  3 replies

  22 years ago

  By: philcart

• DTS

  I have a Visual Pro 5 Database. I am trying to connect it to SQL Server using DTS. I have been look…

  sackerdj

  3 replies

  22 years ago

  By: philcart

• Changing SQL Server connection

  I am trying to use a parent package to call many child packages. Purpose is to populate SQL Server …

  StefanJ

  4 replies

  22 years ago

  By: philcart

• DTS Authentication Issue

  Scheduling a DTS package as a job. SQL Server 2000 on Windows 2000 cluster. All activity within t…

  bridgt01

  3 replies

  22 years ago

  By: cmille19

• How to transfer parameters into „nested” packages?

  I use DTS for transferring data in MS SQL SERVER. I would like to transform data in parts (one part…

  mirekg

  2 replies

  22 years ago

  By: mirekg

• SP_Help_Job and SP_StopJob

  Hello, I am looking to check if a particular job is running and if it is running(over a period of…

  prn9974

  2 replies

  22 years ago

  By: prn9974