Cannot start Dts designer. Every time I try to create a new package I get
this message: Error in dll with the caption DTS Designer Error:
CoCreateInstance. I am running SQL 7.0 SP4 with post security rollup.
(Version 7.00.1094) Running on Windows 2000 Server, SP4 and all ...

I need to be able to import an excel file that has a dynamic column set.  I
want to import it to a sql table that will be created new each time at the
time of import with the name of the excel file as the table name.  Since the
excel file will always have a different number of ...

I have developed a DTS package.  The package consists of several active X
script tasks, and several transform data tasks.  When all the task suceed, it
works great.
However, If I return _failure from one of the active X scripts, execution

     First when using data Transform task I selected all the columns
(Source and destination) then I Click on new Transformation and choose
ActiveX Script .
     Then I Click on the Properties to see the VBScript Generated

We have a task of generating flat files (.dat) with bcp native fromat by
using DTS.
we have OLTP tables, by applying business rules we have to create flat
files, which are suppose to be in bcp native format.

There are 3 machines involved, the sql server, a file server holding the
access databases and a client installation of sql server.
We have dts packages designed to export data from the sql server to the
access databases.  These were created while the databases were in 97 format

I need to update records in a sql table based on records in an oracle table.
The update needs to be done where OracleTable.C_Ref = SqlTable.C_Ref. I am
unable to get the databases linked and there are 14 million records in the
oracle table and 200,000 records in the sql table. ...

Can a DTS package, developed though a DTS wizard ,be wrapped into a Stored
procedure ? Would it make sense to do so at all , since the DTS itself is a
database object , just like a Stored procedure ?
The reason i am asking is because i have to  update one  table of one SQL

I read import a text file and need to delete it afterwards.  I don't
know any VBScript so I had to look up some code to delete it.  I found
the following:
'**********************************************************************

I am trying to use an ActiveX script in DTS to copy a file from one
drive to another.  Both drives are on the same server as my instance of
SQL2000.
No matter how I run the script (Enterprise Manager, or job) from either

creating FTP task to download file.  The file name is determined by
ActiveX script before since the file name is based on the date.  It
connects, downloads the entire file (you can see file size increasing
if you refresh in explorer), and then the file vanishes after the task

I created a dts package to transfer data from a fixed width text file
located on a sharable folder in a central server. When I run the dts
package from DTS designer the package gets executed successfully where
as when I run the same dts package from query analyzer using xp_CmdShell

We have a DTS package (VBScript) that contains an iterative loop.  Within
this loop, it will instantiate a DLL (VB6), call a method on this DLL and
then set the instance to nothing.
Within the DLL I have studiously tidied up all the in-memory objects;

Hey guys,
      I encountered a problem recently while working in DTS. I am trying to
connect to a remote SQL Server over network. What I did is as below:
      1. In "SQL Server Client Network Utility", and in Alias tab I created

I have a DTS package.  The select for one of the transform data tasks look
like:
SELECT * FROM UDF1('1/1/2005','12/31/2009')
right now the dates are hard coded.  Is there a way to pass parameters to