Is there a way to query the contents of your DTS packages?  For example, if
you are looking for the string 'MAILINGS' in your ACCOUNT database how would
you go about doing that?  Please post example if you know.
-Toco-

Since we have applied sp3a to the sql servers we have been experiencing
problems with dts packages importing/exporting text files. (Used to work fine
on SP1, not sure about sp2) The issue is with the number of columns being
imported/export.  Here is the scenario:  Exporting data ...

  I cannot open "DTS transformation" tasks in DTS Designer.
When I try to edit one, enterprise manager simply seems to enter into an
infinie loop. (But I can edit "Execute SQL tasks" work)
  I've "resolved" this problem when I rebooted the server but I do not

Hi to everybody, I am a newbie who is trying to import data from and
XML file into a table in SQL Server 2000. I've reading all the MS
information about the SQLXML's 'XML Bulk Load' and it seems that this
feature can only be accesible through the 'DTS Designer' in the

I am having a problem with Data Transform task
What I want to do is to transfer the records from an Oracle Database to a
delimited text file. The Table has 24 columns and around 5 million records.
The problem is that when I click the 'Define Columns' button in the

I have a DTS package that copies data from a SQL Server table to a
corresponding DB2 table and am getting the following error:
DATA TRANSFORMATION SERVICES: Data Pump Exception Log
Package Name: db2 Staging DTS Test

I have used dts, but have not had to write any Activx scripts. I am trying
to update table A from table B if the vendor_number field matches, if it
does not match,  I want to insert a new record into table A. Following is
the script I created, it fails with a dup key error.

How to close/clear unused connections in DTS. once a transformation or
execute sql step is over i want to close the connection used in DTS step.
Many Thanks in advance.

I am querying a table and outputting data to a text file where each field is
separated by a tilda (~) .  It works great.   I notice that sometimes when
the fields have no data in them I get two tildas in a row (~~) which is what
I want.  However, sometimes I get a field of blanks ...

Hi to everybody!
I'm trying to make the Bulk Load of an XML file with some tables and I
want to make SQL Server 2000 to assign a PK to a column determined in
the XSD file (I expecto to find an option that allows me to see the

I have made a DTS package with several tasks included. When I run it through
the designer on my working computer where I have SQL Server Developer edition
installed, the package is executed successfully. When I use DTSRun.exe to run
the package on the server (where the database ...

Hi,
  Thanks for taking the time to read this.
I am trying to set a global variable equal to a rs. I loop through the
values and insert a comma, so my global variable value looks like

I am using the following logic:
Step1--on success-->step2--on success-->step3---on success--->Success Email
                                    -
IF ANY step (1, 2 and 3) fails then...

I have a datapump which transfers records from CSV file into a Table(same
scenario:-)).I just wondered if before inserting the row in the destination
,I can copy the eigth field in the row which is being tranfered from source
into a global variable.this process should happen for ...

I am using DTS to import data into SQL2000 via an Excel spreadsheet.
My first problem that was that a leading zero was dropped from zip codes
using a simple "Copy Column" transformation.  Additionally Zips with hypens
were imported as NULL.