A bit of a variation on the exporting text files with header & footer info
theme. I currently have a package that exports data from a sql table to a
text file and an ActiveX script that renames the Text File destination
connection at run-time to include the date so that it gets ...

I'm using the winzip cmdline tool through the Execute Process task to zip
files when I'm finished loading them through DTS.  I will have this situation
that complicates things.  
When I bring the flat file into the DTS process I strip out part of the file

I have a DTS package that is called by a VB.NET program.  This DTS
package uses a text file connection as it's source and the file this
source is based on is created by the VB program.
It seems that the DTS package is using a cached version of the text

Can a SQL Server 2000 DTS Package be run from a Web application?  If so, what
permissions, SQL Server roles, etc. are required?
I’ve been only able to find examples of Windows and VB applications.  I
would like an example of a Web application (written in C#).

I don't do much DTS but his should be real simple.  I'm using the data import wizard to import an
Excel spreadsheet into a table.  I need to concatinate the first and last name fields in the source
into the NAME field in the destination.  So, chose to use an ActiveX script ...

Is there a way of exporting database as well as the relationships of the
tables? I am trying to export data to Access or Excel.
Thanks
Yuelin

Is there any option in the DTS through which I can tell the SQL Execute task
to commit transaction after every 1000 records.

Today I received an "Arithabort" error in some DTS packages, but not all.
I have changed the arithabort option of my target database and all works
fine.
But I want to know what's append

I am somewhat of a newbie to DTS, but was wondering if there is a way
to have DTS insert new data into a SQLServer table:
CREATE TABLE SecMonthTbl (
    [SecMonth] [datetime] NOT NULL

I have implementet a koncept in SQLserver to import data
from an Access-database using DTS-package. There is no
problem starting the package from SQLserver Enterprise
mangager.

I am trying to use a send mail task in a DTS job, when I add the task to the
designer the following error dialog appears:
Title  = DTS Designer Error
Msg = Unable to get MAPI profiles.  

Is it possible to have a VB application that allows a user to created a DTS
package from selection made on the VB form.  The developer is creating
timesheet exports for different clients.  There are many to create.  The DTS
package includes connections to dattabases, excel ...

I' ve created a dts package to import some data from another data source.
I've created an SQL connection and specify the provider 'Microsoft OLE DB
Provider for SQL Server'. I parameterize the ServerName, User, Pwd and DBName
and set their values using an activex script. When I ...

I have a SQL Task which simply selects a row from a table based on an input
parameter.  The result of this is then assigned to a global varaiable.
How do I then run another task based on the result of the global variable
i.e. if variable has a value then run task else if 0 then skip ...

How can I be shure to execute the last version of a dts1 using the task
execute package included in dts2? If I modify dts1, dts2 execute the
previous version of dts1. Can I use an ActiveX code in dts2?
Thnx