I have loaded a test system with win 2003 sp1 RC2.  When I edit a dts
package on that server I can no longer edit the package from any other
location.  I get a message about the designer failing to load or save the
package.

I am running DTS as schedule jobs and many times it fails with error Catastrophics or some time memory error codes
I am pulling data from AS400 using ODBC connectivity. many times jobs just gets hang with any error message.
any one can give some idea what can be reason ...
Thanks a ...

I have a DTS that uses global variables to got to the network, get a file,
unzip the file, import the files into sql and then move the file to an
archive.
It works great as a DTS.

Enterprise 8.00.818
DTS package on an Active/Passive cluster with a transform data task
that loads data from some Excel spreadsheets.
The package works fine when one node of the cluster is active but

In DTS, Can we use  temporary  or global temporary created table in DATA
PUMP TASK for Exporting data from Server1.DB1 to Server2.DB1 ?
Here is case :
In DTS Package.

I have a DTS package the does an FTP --> Text File Data Source -->>>
Multiple Tasks -->>> SQL Server database.
The input source file has one row that has12 fields.
The multiple tasks basically read 3 columns from the source record and

I have data in text file , delimited with Pipe and with help of DTS package
pump data to SQL server.
The issue is, the text file some rows can have 32 columns  and some can be
33 columns and so on. Number of columns range from 32 - 40. How do i tell

H!
I need to export Excel worksheet data into a SQL Server table. The Excel
worksheet has 5 cells in it and I need to insert 5 cells data into a
text field of a table. Is that possible? All I am looking for is ActiveX

I want to use DTS to add records to a Lotus Notes Address
book from a SQL Server table.  I have downloaded the
NotesSQL 3.02g ODBC driver and installed it successfully.  
I am able to view the Notes address book data and delete

Is there a switch that can be used with bcp to include the column names as
part of the resulting file from a queryout command ?
Thanks in advance

What is the best way to import different flat files that are in the same
directory using one package?

sorry in advance for the newbie question.
i need to insert into a table using a global variable in a "where"
clause. so something like
insert into datasourceA.table1 (field1, field2)

I've a minimal SQL Server installation in my desktop PC and a source text
file containig my orders.
From my desktop is it possible in DTS to channel data from my single source
text file to a remote destination table in a remote SQL Server?

I'm trying to import an ms access database into SQL server using DTS. I
have read all the postings and tried all the suggestions and I keep
getting errors.
I'm getting:

I have written several DTS tasks in EM that run nightly.  I am moving my data
from one SQL Server 2000 installation to another SQL Server 2000
installation.  Is it possible to copy my DTS tasks from EM on one machine to
EM on another machine?