I am working on a project that has hundreds of DTS packages in use.
The company plans to convert the database engine to SQL Server 2005
next month. We do not have time to convert all of the DTS packages to
SSIS.

I'm trying to run an SSIS package via a web service on my sql server.  The
following code is generating error DtsPipelineException -2147221005 "Invalid
class String".
I can't seem to find anything searching for this error.  What I'm doing is

This problem is taken from an earlier post of min ebut I felt it
needed to be in its own post.
Is it possible to use a Global parameter passed in via DTSRUN, to set
up another Global parameter?

I received the following error on a failed DTS package 'The number of failing
rows exceeds the maximum specified. Unspecified error'.
I found the following error in the package log:
'Step Error Source: Microsoft OLE DB Provider for SQL Server

I am trying to run an SSIS package from SQL Server 2005 Standard Edition with
SP2 and I am getting the following error: 'SQLServer Error: 536, Invalid
length parameter passed to the SUBSTRING function. [SQLSTATE 42000]'. I am
storing the packages in the SQL Server database and I ...

I am writing a package that is dynamic based on a parameter passed in
via the DTSRUN command.
This needs to do the following, where the package parameter amend the
global parameter DataType before execution :

Newbie question. What is the easiest method of transfering DTS
packages between servers that cannot see eachother?

I'm writing a custom log provider that needs a connection manager to record to.
The connection manager's ConnectionString is set via an expression and that
expression is not satisfied until a sccript task can retrieve the connection
string and plug it in.

I am tring to convert an existing ActiveX task to a Script Task using VB.net.
Below is the code from ActiveXScript (SQL 2000)? What will be the equivlant
in SSIS (Script task)?
Dim FSO

From a new SQL DB 'admin' trying to use SQL 2005's BI features,
As a small-company 'SQL DB administrator' (still climbing up the SQL2005
learning curve), I am trying to find resources that would allow me to:
1) Perform an initial import of a .csv / .xls to create a table in SQL ...

I have an SQL Server 2005 SSIS Package which users can initiate using
when the use my IIS website.
I kick the package off from code in a separate thread.
It is used to import data and it makes repeated calls to the Look Up

I am moving data from Access to SQL Server.
I have a term date field (datetime) whose source values in Access are
'1/1/1700'
I am using an Active X Transformation task to change those values to

I have an existing dts package that exports some data to an excel file.
In the transform task, I had "created" the destination table structure (it
creates it as tablename$).
Now I want to change it.   But when I try to change it by Creating it again.

I'm trying to import data from a Lotus Notes database (*.nsf). In the middle
of importing I got this error:
Error at Source for Row number 3333. Error encountered so far in this task:
1. [Lotus][ODBC Lotus Notes]Data value is not a valid date, time or timestamp.

I am just learning about SQL Server so please excuse what may be a silly
question.  I am importing the data from an Access 2000 back end database into
SQL Server 2000 using the DTS Wizard.  
The SQL Server database I created through the Access Upsizing Wizard is fine