Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• DTS Skipping Last Record Missing {CR}{LF}

  I am trying to load a text file into a table with multiple records ending with {CR}{LF} except…

  David Bird

  1 replies

  20 years ago

  By: Erik Kutzler

• String to Decimal Conversion

  I am trying to load a text file using DTS and I am having problem with one of the decimal fields. T…

  bunmiog

  3 replies

  20 years ago

  By: bunmiog

• DB2 timestamp format

  Hi, I have been asked to convert a DB2 TIMESTAMP (ISO FORMAT) to YYYY-MM-DD hh:mm:ss.nnn.  I h…

  Charlene Moore

  2 replies

  20 years ago

  By: Charlene Moore

• Execute Sybase Stored Procedure

  Does anyone know of an example of executing a Sybase stored procedure from DTS?   I need to pr…

  WebTechie

  3 replies

  20 years ago

  By: WebTechie

• "Invalid Pointer" error

  I have a DataPump Task inside of which I need to make a decision which table records to transfer. …

  JMI

  1 replies

  20 years ago

  By: Andrey-320088

• best way to insert else update records using dts

  I have used dts to import records and usually truncate the target table first; thus all records are…

  Richard Cranston

  5 replies

  20 years ago

  By: Richard Cranston

• Error when executing DTS

  Executed as user: CACI\svcPM2SQL. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_D…

  sqlstar2011

  1 replies

  20 years ago

  By: JKSQL

• Dynamically exporting text file from SQL table using DTS

  Hi, Currently I have two SQL tables with different structure I have to transfer the records from e…

  Kumaravel-229312

  8 replies

  20 years ago

  By: Kumaravel-229312

• DTS MySQL to SQL Server

  Hello all, I am in the process of migrating a MySQL database to SQL Server.  I am using DTS an…

  Mike Clousing

  1 replies

  20 years ago

  By: sqlemail@yahoo.com

• DTS Package running in a job

  I created a DTS package.  It was a simple one - transfer data from a table to a text file.&nbs…

  Loner

  3 replies

  20 years ago

  By: Dennis Link

• DTS updates

  I am connecting to a DB2 on a Unix and trying to update some data in one table. I have verified the…

  SA-1

  4 replies

  20 years ago

  By: SA-1

• Dynamically Populate data from Source

  Dear SQLServerCentral members, Is anybody knows a way in the DTS Package to create a script to dyna…

  AER

  3 replies

  20 years ago

  By: AER

• DTS PACKAGE TO CONVERT DATA INTO XML AND FTP it

  Hi I need urgent help with this. Convert an CSV into XML format and FTP the file If anybody has don…

  Vishal-311615

  1 replies

  20 years ago

  By: Tim Cullen

• Transforming varchar to datetime

  I have a table (designed a long time ago by a computer illiterate) which stores datetime field…

  Ham

  3 replies

  20 years ago

  By: Bill Scott

• DTS Scheduled package HANGS sporadically

  Hi, I am running a dozen or so of DTS Scheduled jobs which call a DTS package each. The packages b…

  Kishore-299616

  10 replies

  20 years ago

  By: Mike Chappell