I am writing an installer for a database driver application. The installer
is supposed to create the DB, tables and populate the tables with sample
data from an excel file.
The excel file containing the sample is generated via the DTS wizard from an

Hi all --
I'm trying to write my own ActiveX transformation script to copy some fields
from an old table using a couple different data types to a new table.  I
seem to be having problems with the different data types and can't get DTS

We have a situation where we having a training database on the same
instance as the live database.  At irregular intervals, a user needs
to copy recent live data over on to the training database.  In the
past, this has been done by the user restoring the latest backup over

I have some .dts files but do know how to open them, anyone knows , thanks a
lot.

I have a script below, when I run it on its own, it is great, but when I run
it as an "Execute SQL" task as part of a DTS package, the step fails with a
"division by zero" error. Shouldn't it ignore this error due to setting
ANSI_WARNINGS and ARITHABORT both to OFF? I get the error ...

I am converting an Access Database to SQL.  My problem is that I have
many different source fields I want to put in to one field
(CaseNotes,Notetext) in the DTSdestination but I want each to create a
new recordset.  Right now the last transformation to take place is the

I am simply trying to run DTSrun.exe from the Job Agent in SQL Server and
everytime it Says that the job failed.
The job failed.  The Job was invoked by User CHQPVUW0806\LenceRM.  The last
step to run was step 1 (cmd).

I'm very new to DTS, but here goes:
I've got a source file with dates stored as YYYYMMDD, and I'd like to move
the data into a datetime field.  I've figured out the basic transformation
steps, but I'm running into a problem with source dates = '00000000' (e.g.

Does anyone have a way to install both a DTS package and/or a DTS Custom
Task via InnoSetup?

We developed a DTS package that would pull records from 12 different source
tables and inserts into 12 different target tables.
For this, we created 12 different "Transform Data Tasks"  that run in
Parellel.

Is there an easy way to change the source path for a DSN using the DTS
object model?  
I have a DTS to import DBFs into SQL.  Because I want to do some complex
join queries with the DBFs while importing I cannot use the native dBase

Does anyone have any tips for debugging a DTS package?
I've enabled JIT debugging.
It launched Visual Interdev for me to step thru code.
Problem is -- I can't change anything.  Guess this is how it works.

I am looking for the dts run time.  Is this information stored anywhere in
the database tables (package name, how many mins etc..) ?  
sql 2k, win 2000
Appreciate the responses.

Hello. I need to import an EDI TS-130 file (that contains academic transcript
information) into SQL Server 2000 via a DTS. Under "Data Source", what should
I indicate? Do I need a third party tool? Thanks.

I'm having a problem running a DTS package in VB. Everthing works fine on our
development PC but when we install on our test PC the package seems to run
(ie we're not getting an error message) but doesn't transfer the data to the
table in SQL Server 2000.