I have my dts package as a structured storage file. I plan to save it to my
server for scheduling.  Is there any way that I can remove the previous
versions from the file to make it smaller before I save it on the server?
Thanx

I'm SQL Server developer dbo priviledges to a database.  I have created 10
DTS packages but cannot see them in the SQL Server 2000 Enterprise Manager.  
I deleted and add the SQL Server registration. The old SQL Server had
authentication with SQL Server and Windows. The new ...

I want to make an HTTP request from a DTS task just to produce a log in an IIS
log file.
This I'm sure to have IIS log file processed by my DTS jobs.
How can I make such a task ?

Does anyone have a clue how to pass a global variable in an Alter
Statement.
The following works
ALTER TABLE [Outlets Query_Crosstab3] ADD [10/1/2005]  int

I'm sure there is obvious way of doing this, but I haven't used DTS in
a long, long time.
What I'm trying to do is to import log files from some web servers that
are clustered.  I've had no problem with importing the text file, but I

I'm exporting a SQL table to a text file and want to add a little bit of
header information.  Is the best option ActiveX Script using FSO?
Any thoughts.
Thanks,

I had a working DTS datapump task.
I added columns to the source table.
When I open the datapump task to map the new source columns, the changes are
not reflected in the available source columns.  The changes to the table have

How to set up DTSPackageLog?
I spesify the error log file in package properties however
it is still not working. Any idea why?
DTSPackageLog.WriteStringToLog "File """ & sFilename & _

I have a package in which I have several Data Pump tasks to copy data from a
tables in a Pervasive Database to an SQL Database.
I use a dynamic propertice task to change the destination connection (server
name and database name).  Dynamicall changing the connection works fine for

I have a DTS package, part of which does this:_
select * from database.tablename where ididat = 20050130
What I would like to do is replace the fixed date with a dynamic date, so I
don't have to edit it. I've tried combinations of DateAdd and GetDate() etc,

In an ActiveX VBScript I need to be able to create a
recordset in code.  
Normally, I would use the ExecuteSQLTask, load it into a
Global Variable and set rs = DTSGlobalVariables

Can DTS load data into Hyperion's Essbase?
I know I can output a text file and then call a .bat file that uses an Essbase load command, but I was wondering if DTS
supported a direct connection.

I work for an environmental agency.  I need to import data from a text file
every 30 minutes.  This text file contains weather info which is collected
every minutes by an instrument in the Gulf.  So every minutes a line of data
is added to the text file.  Then every 30 minutes, I ...

I have a DB on SQL Server and I need to create a table that is a link to a
table inside another MsAccess DB. How can I do this?
I'd reply the same behaviour like I do in MsAccess when I run the command
"Link table".

Apparently DTS already keeps count of the rows it processes.  I'll
just bet there's some way of putting in a post-source or pump-complete
handler that accesses that number, rather than keep my own count by
incrementing a global on each row.