Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• DTS to Excel Error

  Hi all, I am trying to use DTS to export a table to an excel spread sheet however somewhere durin…

  mayflower1230

  1 replies

  23 years ago

  By: vambati

• DTS - Source

  I have an input text file connection. I started to mark my columns but when I reach a specific numb…

  CarlosBenito

  1 replies

  23 years ago

  By: vambati

• FTP Task

  I searched the site and BOL for the answer I am seeking and found none. Probably it is so obvious …

  Robert W Marda

  4 replies

  23 years ago

  By: ipTomN

• Import from Excel Problem

  Hi All, I am trying Import data from Excel and i get this error Data for source column is too large…

  maffan76

  3 replies

  23 years ago

  By: Hans Lindgren

• Migration of Access 2000 to SQL Server 2000

  All, I am supposed to migrate Access 2000 DB to SQL Server 2000 DB. I tried Upsizing Wizard of Acce…

  gurukg

  16 replies

  23 years ago

  By: lawrencek

• How to get the number of records exported

  Just created a DTS package to export data to text files. I would like to add the following function…

  Frans Tromp

  5 replies

  23 years ago

  By: mhweiss

• 3rd party tools for managing dts packages?

  Are there any good tools to help manage dts packages? Currently if a dts package calls another dts …

  richcoulson

  1 replies

  23 years ago

  By: ipTomN

• Capturing Error in DTS package

  Are there any recommendations or examples of catching errors within sql dts packages. My example w…

  Ivy

  3 replies

  23 years ago

  By: ewilson10

• Using local as the server name

  We have recently upgraded from SQL 7 to 2000 and noticed that all the DTS packages that use local a…

  kennis

  1 replies

  23 years ago

  By: kennis

• Replacing blanks with Null through a transfer

  I am bringing over some data from an AS400 file and there data contains one char as a blank when it…

  jG

  3 replies

  23 years ago

  By: AnzioBake

• ActiveX Scripting was not able to initialize

  When I attempt to run my DTS Pkg that contains ActiveX task, I get following error: "ActiveX Script…

  mcinmx01

  1 replies

  23 years ago

  By: jfb

• Transfering ownership of DTS packages

  I have created a bunch of packages for developers ( to copy prod data to their individual databases…

  srini_kris

  3 replies

  23 years ago

  By: jfb

• DTS and Lotus NotesSQL

  Hi: I'm wondering if anyone might be able to help me... I am working with Lotus Domino and have bu…

  Sbrady

  7 replies

  23 years ago

  By: BruceKenitzer

• Import relational data into SQL using DTS

  Is there an easy way to import relational tables using DTS. I can't use identity insert as the PK's…

  KeithDavies

  1 replies

  23 years ago

  By: Andy Jones, DBA

• Multiple Destinations for Source Data

  I am creating a new database for a company. They have an existing database in FoxPro, and the data …

  taffy

  1 replies

  23 years ago

  By: KeithDavies