I would like to write a DMO/vbscript/activex control in DTS to access other
DTS packages' connection objects properties.  It it possible and if so where
can I find a code snippet or example?
Thanks

I have a problem when a DTS is called by a scheduled JOB
The DTS is copying Data from an Accpac dataBase by using a
ODBC Data source Administrator SYSTEM DSN
When I run the DTS manually it works fine

I need to convert a SSIS custom component from SQL Server 2008 to 2005.
In particular, I need to solve an error about
IDTSExternalMetadataColumn90.MappedColumnId: it exists for 2008 version but
not for 2005.

I am very new to DTS and am currently still working with SQL Server 2000.
I have two problems:
1. I need to copy a file with a daily changing name from one server to
another. The file is date stamped. However, the first part of the file is

I have the following in a dts package which picks a certain xml file and
reads it into the database. It does this successfully when the path and
filename is specified, but  I want the xml file to be read dynamically and so
I've used objFSOFolder & objFSOFile.name below ...

I am trying performing a migration some data of an Oracle database to
another Oracle database using the DTS, but when something occurs wrong
my script stop.
Looking at ActiveX Script I am try:

As far as I can tell there is no way to do a fastload or bulk insert if you
need to use the EncryptByKey function on a field that is being inserted.
Is there a way to do it via a script component?  Either in the script itself
or have it call an external EXE?

I created a datapump task in SQL SERVER 2000 DTS. The source for the task is
stored procedure and destination is a tab delimited text file. The SP
contains 34 columns. So in the destination column if I click define columns,
no columns were populated. If I remove any 3 columns out ...

I have a DTS package containing several SQL Tasks.
I would like to get all the SQL commands in a single file to edit them in an
easy way.
Is there a way to do this?

A DTS package that inputs a flat file.  The file's name is set using dynamic
properties task.  I need a task to detect if the file is empty and then
control execution of subsequent task(s).  An example would be much
appreciated.

Can I read each individual row in a flat file using integrated services, each
row is fixed position and some rows contain a different amount of fields,
which is why I need to read each row so I can determine which rows I can skip.

Can I read each individual row in a flat file using integrated services, each
row is fixed position and some rows contain a different amount of fields,
which is why I need to read each row so I can determine which rows I can skip.

I have some DBFs that i created from foxpro.  How can I DTS them into a sql
table?  Ive never done dts before so a walk through would be nice.  Thanks!

When designing an SSIS package data flow, I can see an XML Source but no XML
destination, am I missing something or if this is a limitation of SSIS in SQL
2005?

Could anyone please assist?
I need to have Autofilter on a Protected Excel worksheet, but I can't seem
to get it working.
I know the same thing can be done in Excel itself (Set the Autofilter, then