Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• how to put file to FTP using DTS(activate X script)

  Can any body tell me how to push the local file to FTP. I tried using WScript but its throwing an e…

  Manoj-172436

  2 replies

  20 years ago

  By: philcart

• DTS - How to report success

  I have a DTS package that is scheduled to run every half hour to pick up a csv file on the network.…

  Hak

  3 replies

  20 years ago

  By: Hak

• It''s back again - runs in Enterprise manager, but not when scheduled

  I know that this issue has came up on this forum a couple of times, but here's the error that I get…

  Will1922

  7 replies

  20 years ago

  By: Will1922

• Transforming Into Multiple Rows

  Hi, I'm building a DTS package and one of the tasks it needs to do is to transform an existing orde…

  ywb

  3 replies

  20 years ago

  By: ywb

• DTS : activeX script problem

  Hi all, I have a small problem with DTS packages. I have several databases, and write DTS package f…

  annequin

  3 replies

  20 years ago

  By: annequin

• Import Text file Question

  I have a text file which is delimited. I want to used an ACtiveX script in a DTS package to im…

  runelords

  4 replies

  20 years ago

  By: Mark Harr

• Incremental Data Transfer using DTS

  Hi Friends, An issue which has been nagging me since few days is pertaining to Data Transfer using …

  venu menon

  4 replies

  20 years ago

  By: Johnson J Mampoozhil

• DTS Truncates Trainling zero''s when importing fixed width text

  Hi all Im havin a problem with Dts truncating my trailing zero's Eg. DEB0100 Will display as Deb01…

  Kashief

  4 replies

  20 years ago

  By: Archie Ogden

• DTS: Data Transformation w/ ActiveX Problem

  I have a process that queries an external API for data that is in a "flat file" format. Unfortunate…

  Tom Carnahan

  1 replies

  20 years ago

  By: Don Staten

• Unable to access the Analysis Services Processing task

  I'm an Analysis Services newbie, and I've just installed Analysis Services on my SQL Server 2000 (s…

  Anthony Dixon

  2 replies

  20 years ago

  By: Anthony Dixon

• using dts to create .txt file on a different server

  I want to use dts to create a text file on a different server.  It creates it on my sql server…

  kent schultz

  12 replies

  20 years ago

  By: kent schultz

• ExecuteSQLTask SQLStatement Property Name

  I have instantiated an object for an existing ExecuteSQLTask in an ActiveX task.  How do I set…

  Edwin Frydendall

  1 replies

  20 years ago

  By: Don Staten

• Add delay in DTS Package

  Hi,  I have a series of steps in a steps in a DTS package, I want to know how to add a delay o…

  Santhosh Kumar

  1 replies

  20 years ago

  By: Don Staten

• Query error

  Server:Msg 1105,Level 17,State 2,Line9 Coule not allocate space to the object 'Tutorial' on 'Mytest…

  Paris

  3 replies

  20 years ago

  By: David Burrows

• DTS global variable -> DTD Sql Query Problem

  I don't know if this is possible or what im doing wrong. Basically i want to setup a global variabl…

  Richard-227934

  1 replies

  20 years ago

  By: Carl Federl