I have a DTS package which imports data from an Excel spreadsheet into an SQL
Server database.  The package works fine, but I would like to take the
package to the next step in automation.  How could I call the package(from VB
.Net or QA) to be executed with only one change in ...

 I have a DTS package which will be called by a front-end application (C#).
The way we are handling it right now is to create a stored procedure to
execute the
Create procedure dtrun as

Hi
I have two packages which are to be executed one after the other, so is
there a possibility of calling a package in another. and also the the
procedure or syntax of calling.

The subject header pretty much says it all, except that the only
views/tables that it seems to have trouble with are ones containing
fields with the text datatype - even if you don't put the text field in
the view.

I have a DTS package that reads two flat files and imports the data into SQL
Server.  Our requirements have changed and the two files I have been
importing are now merged into one file.  Therefore, I would like to modify
my DTS package to only import one file and redirect the DTS ...

Could someone help me.
When I execute my DTS batch with a script ActiveX in VBScript, I have the
following error message :
"ActiveX Scripting Transform (DTSTransformation__5) doesn't succeed to

We have a DTS package that loads VFP data into a SQL Server on a
separate machine on the same network.  This process takes ~12 minutes
and involves many of the records in many VFP tables (1.3GB).  Our CIO
has expressed an interest in moving our SQL server to a remote location

In some cases I get an error when I try export to a file (from another file
or database table) which seems to be related to the amount of columns.
When I export from a file to another file it works for 37 columns but SQL
enterprise manager crashes when I try to export 38 columns.

I have to read an Excel-File into DTS to append data to a SQL database.
Within the Excel file I have my data in columns and not in Rows. Is
there a possibility to read this directly through JET OLEDB?

I have SLQ 2000 Standard SP3a running on a Windows 2003 server.  When I try
to import some tables I get the message:
DTS Import/Export Wizard Error: CoCreateInstance
The specified procedure could not be found.

Anyone know of a way to put DTS packages in source safe and use keywords?

I am using Transform Data Task to transform data from table to text file. I
am using lookup query to get the value of a single column using VBScript in
transform data task. But when I test the particular VBScript task it gives me
the following error

I used DTS to transform data from ORACLE 8.1.7 to SQL Server 2000. an error
message appears while moving data in new table
 DBTYPE_DBTIMESTAMP "Data overflow. Invalid character value for cast
specification".

When using DTS to copy Tables/Views from one SQL to another, some of the
tables/views start to copy but error out.  
Is there anyway to fix/rebuild the existing tables/views before copying or
worst, is there anyway to let as many copy before it fails.  I understand

I need some help with the way I make dts packages that
bring in data from outside data sources.  A typical DTS
Package that I've made Deletes the records of a table
then on success connects and pulls down a new set of