I am designing a DTS package instead of SSIS.
I have a text file and already uploaded to tableA, there is a field
named NameID in tableA. The field NameID should match the NameID in
tableB and update other fields of tableA, the non-match records will

I have a DTS package that extracts some data to Excel worksheets Total_Data
and Total_Count then runs ActiveX script to open the Excel workbook and run a
macro to complete formatting the data.  
I receive intermittent errors with the package:

Is there backwards compatability from DTS packages that are created in SQL
Server 2000 in SQL Server 2005?  
Also, is there DTS support in the EXPRESS Edition of SQL Server 2005?
Thank you.

I'm working with the XML Source in data flow and find that when I'm updating
the schema, it won't be aware of the change. I have to re-select the xsd file
which will result to a status that all its sub nodes become invalid. I need
to opend and close all those sub nodes to bring ...

Is it possible that multiple persons can work on the same package at the same
time and merge there changes? I find this will result in huge amounts of
conflict while merging these changes. I also tried another way which is
different developer working with different package. But ...

Will DTS Packages *NOT* import from UNION queries in MS Access?
I have my Access & SQL Server (OLE DB Provider for SQL Server) connections
set up.  I have my Transform Data Task going from Access to SQL Server.  But
in the Source tab of the Transform Data Task Properties, my union ...

DTS Active X script transformation properties box has ActiveX script text
box on the right where you can change Active X script. SQL enterprise mgr is
not showing this box anymore. It looks like that Active x script box is
hidden somewhere but there is not maximize/minimize ...

I have a DTS job which transfers the data i get to excel. However, it always
appends to first worksheet of the file.
I want the data to be transferred to the Active worksheek which i have
created using VBscript.

Good evening,
I have a Lookup Query in a Data Transformation Task, searching a value in a
table.
The transformation script is as following:

I have a package that uses a single global variable for several data pump
tasks. I set the global variable and fire the DTS package. It works fine for
the first data pump but not the second - i get an error message saying no
given value for the global variable.

Can someone explain/help how can I create a schedule at SQL Server 2000 that
exports at X time of the day a SQL database into a access database without
exporting the views that the SQL database has.
Thanks

How does one configure and manage a remote SSIS Service?
When attempting to administer a remote SSIS Service in SQL Server Management
Studio, I get an Access is Denied error (message listed below) when trying to
connect to the service.   How does one set up access to a remote ...

I'm perplexed and in need of a sanity check ...
Instance of SQL2K5-SP1 on Server2003R2.  Created two databases Test1 and
Test2, create single 2-column table (tblTest)in Test1 with one row of data.  
Create SSIS package to transfer the table and its data to database Test2

As I know, although DTS gives graphical view of the data
transformation/conversion work flow, it tend to be slower than BCP and
TSQL scripts. So, keeping all that in mind, can I still use DTS (b'cos
its a good tool to illustrate what's happening inside, easy to

I have a series of 30 stored procedures which extract data from a SQL Server
warehouse.
The procedures extract the data and I can individually create a DTS package
which writes the result set to a .csv text file.  (These files will be