Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• Data Tranfer from production to datawarehousing DB

  Dear All, I have to transfer data from production server to datawarehousing server, both are SQL S…

  Innovative

  1 replies

  22 years, 5 months ago

  By: Allen Cui-55137

• Importing Text Files with abnormal characters

  I have to import a text file that is generated by legacy systems. There are abnormal characters, i.…

  YCH

  7 replies

  22 years, 5 months ago

  By: YCH

• Problem with File Transfer Protocol Task

  I am having a problem using the file transfer protocol task in SQL Server 2000. I have set the task…

  msbolton

  3 replies

  22 years, 5 months ago

  By: msbolton

• 2 Server Communication

  I have 2 SQL Servers (Prd and Dev). A SQL DTS Package resides on Dev, and it is a script to copy t…

  race2003

  5 replies

  22 years, 5 months ago

  By: race2003

• DTS with vbscript & Excel Validation Object

  I'm working on a DTS in which we automate the creation of an Excel Spreadsheet. The spreadsheet is…

  Matt Simmons

  2 replies

  22 years, 5 months ago

  By: Matt Simmons

• BULK INSERT in Transaction

  I need to trap errors occuring in BULK INSERT, such as wrong file format, etc. When such an error …

  dbrashear

  2 replies

  22 years, 5 months ago

  By: dbrashear

• reading a Global variable

  Hi There I am currently writing a stored procedure that runs --------------------------------------…

  sammy16v

  1 replies

  22 years, 5 months ago

  By: Rajesh Patavardhan

• Down Load text file from FTP thro' DTS

  I would like to connect and download the text file from FTP thro DTS or any utility on SQL Server w…

  spdhiva

  6 replies

  22 years, 5 months ago

  By: tcartwright

• Send a variable back to DTS from Store Procedure

  HI there. I've been writing a store procedure that needs to return a value to a DTS package. I've c…

  lourem

  4 replies

  22 years, 5 months ago

  By: lourem

• Empty fields and null values

  This should be an easy one, but seems to be stumping me this afternoon. I have a textfile with seve…

  mrfleck

  1 replies

  22 years, 5 months ago

  By: LeopoldNjampa

• DTS Package to Change Object Owner for Excel Impor

  Hi: I have a development project where I'm using an Microsoft Access (ADP) Project file front-end a…

  CherylDixon

  3 replies

  22 years, 5 months ago

  By: David Benoit

• Dynamically Get Path/FileName for DTS Connection

  I have a DTS package that I created that takes an Excel spreadsheet file and imports it into a SQL …

  CherylDixon

  3 replies

  22 years, 5 months ago

  By: mhweiss

• executing a dts package from within a t-sql loop

  I have a DTS package which runs great from the enterprise manager, but I need the DTS package to ru…

  rhandloff

  3 replies

  22 years, 5 months ago

  By: Antares686

• DTS schedule error

  Icreate many jobs. They all can be run under local package but when I schedule them I got error mes…

  jili

  2 replies

  22 years, 5 months ago

  By: rustroot1

• FTP - Get multiple files

  I have seen this all over but I haven't found my answer. I need to setup a DTS package to get multi…

  Ivy

  1 replies

  22 years, 5 months ago

  By: Robert Davis