I have a DTS package that will run fine in almost every place except when
it's scheduled.  I can right-click on the package and select "Execute" and
it runs ok.  I can open the package in design view and run it, and it's ok.
I can open up a command prompt on the server and run ...

I have created a DTS where owner is the administrator of the SQL server. It
import data from an access database sitting on a different server. When
executed manually it works. When it's executed from an ASP page I get the
following error in the log. How do I give the ASP page the ...

In SQL Server Books Online, there is a great programming example where you
can modify the properties of a data pump task to add new transformations.
My question is how do you remove them when done?  Those transformations stay
saved so you cannot recreate them later.  Here is the ...

I have a DTS package that is schedule to run daily.  The DTS package was
created and made the connection to the SQLServer using Windows
authentication.  When the package runs, it runs under the user/password of
the SQLAgent.  About every 3 months, we go through a security cycle ...

How to copy a excel file to Destination server while copying DTS package to
different server?

I have a scheduled DTS package set up on my SQL Server with the following
properties:
Source: a stored procedure which can take a parameter
Destination: a csv file on disk with a dynamic filename (each time the task

I would like to take the next week's date( for example next Monday)
from an ActiveX in a DTS package. Can I do that and how?
Thanks in Advance
Riri

I tried to copy some tables from another server using DTS
Package Copy SQL Server Objects Task and all tables are
copied over but I noticed that some of the logs has this
error message:

I'm creating a new Transform Data Task in SQL Server 2000.  I have the
option to select a table/view from the source database, or write my own SQL
to select the appropriate data.  I would like to be able to write my own SQL
query, but be able to use the value of a global variable ...

Could someone advise me to the best practice to achive the following
objective? Thank you
Objective: Use a field value of another database and table in the as a
condition in the Data Pump SQL Query

I have over 182 DTS packages that reside on 54 SQL servers each is a diffrent
server, the DTS packages pull data from SQL server databases, sybase &
oracle. The plan is to move the databases to 4 SQL servers, is there an easy
why to find which DTS package uses which databases so ...

I am importing data in the table which has primary key as identity. Data file
doesn't has the data for the column.
I created view which has the column except the identity column trying to
import but getting error

I have created a DTS Packaget that successfully transfers files from an FTP -
sometimes.  If I execute each step manually, the FTP transfer succeeeds.  
When I execute the package, sometimes the FTP package succeeds, and sometimes
it does not.

I have scheduled a DTS package that runs every night and shows in EM that it
was successfull.  I have a query that sums up a key fields to make sure the
two tables are in sync. When I check my verification the totals are not in
sync. If I run the DTS job manually, everything is ...

I have inherited a Sql Server instance that has a lot of DTS packages, and
one of them uses something called WebFileFetcher to download WEB page data
files and parse them.  I searched MSDN and found one article which also
appears on a non-MS web site.  There is also a directory ...