Is there a way to execute the DTS packages from ASP.NET (preferably
asynchronously) ? what kind of permission should I give the web user ? from
all those packages there I want to only list some them ,how should I control
this?

I'm trying to change the datasource for a dts package inside of a loop.
I've created a dyanmic proprety that is housed inside the looping steps
that has the datasource = value of a global variable.  In the workflow
active x for the dynamic properties i add a

I am runnig a job which executes a DTS pkg name "TMP" which is stored as
dts file in the C drive of server.
declare    @dtsrun varchar(1000)
set     @dtsrun = 'dtsrun /F d:\CM_DTS\TMP.dts /N TMP /E /AServerName:8='

I have a job set up to execute a local package automatically daily at a
scheduled time.  After the job fires, the status indicates it ran
successfully but when you verify what it was supposed to do, it shows nothing
happened.  The job history step details show:

I have an input file with date & time data in this
format:
yy mm dd hhmm..........
99 12  7 1400

Hi,  I am still new to DTS and can't figure out how to do this.
I have a two tables, Game and Game Detail joined by Game_ID, I need to set
up a DTS package where I can export to different text files the Game Detail
information for each game in the Game table.  Each Text file will ...

Is it possible to change the owner of a DTS package?
The reason I ask is that I am trying to tighten security on our SQL Servers
and have a problem with DTS.
Our developers have a development SQL Server (2000) that they construct

I would like to use the FileSystemObject in ActiveX Script Task as in Visual
Basic 6. But I think that the syntax is slightly different. Can someone
advise me how to do the declaration of the object and the program syntax in
ActiveX Script Task?

I have a DTS job that is giving me fits wehn run from a scheduled job.
Access denied to server.  The DTS runs fine if executed directly, so I
don't believe it's the connection in DTS (using SA account on both SQL
Servers), the job fails on the first step which is the connection to

I have 2 tables
DistinctVend and NonRefvend.  Both of them have the VendorID column.
The DistinctVend has 25000 records
The NonRefvend table has 26000 records.

I am moving a DTS package from one server to the other. In the DTS package, I
am exporting data from some tables to text files. On the new server, I have
to modify the text file destination and the database name.
When I modify these two connection properties, some of them OK. but ...

I'm making a datawarehouse, and I wrote DTS packages which includes several
SQL execution tasks ; each of them include many SQL commands (insert, delete
and update commands). There can be, let's say, between 10 and 40 SQL commands
in a single task.

i would like to change the DTS-AtiveX template:
If i create a new Data-Tranform with ActiveX, so i get ever this template:
'**********************************************************************
'  Visual Basic Transformation Script

We've created an specific user with Sysadmin role and after that, with that
same user we build a DTS but once saved in the server, appeared as 'owner'
the NT
user.

I am working with OLE DB from IBM (iSeries Access V5R3 - I tried all the 3
different provider) and SQL Server 2005.
When I try to get Data from an AS400 Table from an OLE DB Source with SQL
Command (also simple SELECTS) I get the error as listed below. Although in