When I modify the server connection to change the login ID when I transfer a
DTS package to a different server, the tables I selected for copy on the
original package get de-selected.  How can I preserve the object selection
when changing a connection login?  This is in SQL ...

I am exporting two different views to the same spreadsheet but different
sheets.  The first export works fine but the second creates the second
worksheet with the same headings as the first.  Both exports are created
using the wizard so they are in different packages.

quickly: I want to be able to be able to have a specific task fail, run
a stored procedure to log the error, and then continue processing the
package as if nothing had gone wrong. When it gets to the end, I'd like
the package to act as if it had suceeded.

After I upgraded the sql2000 to sql2005. I see the dts package under legacy.
but i can open it.
WHY?
Thanks

I can't find SSIS in sql2005? the SSIS service is running.
Thanks

I have a stored procedure (FL_LIGenerateNextPkg) which I call to set the
global variables of a DTS Pkg and execute it (Pkg A).  Pkg A then runs a
couple of stored procedures and after they have successfully completed, it
calls FL_LIGenerateNextPkg again, passing different ...

I'm using MS SQL 2K.  I'm trying to design a DTS that uses DDQ that
uses a query as its source from DB1, then using that data it needs to
update a table in a second DB (DB2).  Both DBs are defined in the DTS
as a Connection.  I have the source query completed and tested, I've

I have a DTS package called 'MASTER'  which performs 8 execute DTS package
tasks.
There are no workflows defined for 'MASTER'. The 'MASTER' DTS as well as 7 of
the 8 packages it

I would really appreciate if anyone of you can help me. I am new to the DTS
and working on multiple column lookup under ActiveX script. I am using SQL
Server 2000.
Lookup Query:

I have 100 DTS packages and I am looking for particular text string (for
example:
like '%table_name%').
How can I look for it without opening each DTS and going through every step?

I am using the Copy SQL Server Objects task in DTS on SQL Server 2000 sp4 to
copy a number of specific tables from one database to another on the same
server.  The package fails with the error message "Could not find check
constraint for table 'x', although the table is flagged ...

How do I identify running DTS executions?  We have some DTS's which don't log
to the system (DTS) tables and are absolute resource dogs !!!  So, how do I
identify them?  All I can get from master..sysprocesses is "DTS Designer" and
the enormous I/O being generated.

I'm new to DTS so bear with me.
I have an app that exports several tab-delimited files throughout the day.
I'd like to then schedule a time when these can be imported into an SQL
database. I've got it to work fine on a test server using DTS for one file.

Is there a way to change the owner of a DTS Package. I am running SQL 2000
Enterprise with SP4. Thanks.

Hi Darren,
We're trying to use the Bulk Export Task from sqldts.com
in the log i get: