SQL Server 2000 3a
DB2 Client tools version 7.2
I have a DTS package created by someone else.  It has a transformation where
a Mainframe db2 database is the source.  I have an odbc connection set up.  

I have an SSIS package/job that spins through a directory of files (a
Foreach loop, which has new files daily) and for each file does a Data
Flow task (call it "Step A") that inserts data to a database.  I am
trying to add a condition within the Foreach (daily file) loop that

I'm "playing" around with SSIS and try to solve the following problem.
I've an import folder which is filled with CSV - files from a legacy app.
There can be up to 50 files in this folder. e.g. customer file, vehicle file
and the corresponding parameter files.

I'm creating a DTS Package that will move data (insert) from a SQL
Server table into a
DB2 (AS400) table. I'm using a data driven query, in the source I'm
selecting a local sql server table, the destination is the db2 (AS400)

I want to do some data transformation from one Database to another.
My source DB is a MS SQLServer to which I can connect using OLEDB/SQLnative.
My destination DB is a different type of database to which I can connect
using Connection Manager. But for data transformation I need a ...

I have dts package that needs to create new excel file and import data from
query to it. the name of the new file is name of report and date/time stamp.
the name of the files is being saved in activeX and send into the
destination connection

I am using the looping code by Allen Mitchell. The web link is below.
http://www.sqldts.com/default.aspx?246
I had a package running last night to load multiple files.  It was
working beautifully.  It uses the filesystem object to get all the

I am importing a table from a mySQL Database. The Database Column is defined
as a numeric(6,2). I am receiving an error the the column is too wide for the
import, the only value I can see in 18 rows (small table) is 22500.00. I have
tried changing the size where I can, it doesn't ...

We are having an issue where SSIS dumps during execution.  It creates a crash
dump file on the  C:\Program Files\Microsoft SQL Server\90\Shared\ErrorDumps
directory.  Is there a way to read this dump or figure out why it is
happening?  It seems to be intermittent.  It happens to ...

My question relates to connections in SQL Server 2000 SP3
I have a number of unused connections in my DTS package, some of which
are causing problems (packages to fail and Enterprise Manager to
crash). I have removed all references to these connections (in SQL

I am using SQL Server 2000, since I dont have OLEDB provider for
Postgres, and SSIS does not support ODBC connection for migartion of
data.
I want to move data from my source tables to other database, for about

I'm designing a DTS package right now to pulls partial data from
several tables in a database on a server which I have limited access to
(read only, for the most part) to a server and database I'm the owner
of.

In have a DTS package involving Batch files, ActiveX vbs scripts, an
Access2000 databases and SQL Server Database.  At the end of the package, I'm
using an 'Execute SQL Task' to create an email using XP_sendmail to notify
users that the access data base has been updated.  ...

I am still using SQL Server 2000. My DTS package runs fine but after last
step dtsrun.exe process doesn't ends/hangs.
We just moved to new domain so all the servers are same but we are in new
network. Same package runs fine in development server, but in test server DTS

I have a DTS package that has several Transform Data Tasks that copy data
from SQL Server to SQL Server in based on a global parameter retrieved from a
query.  The queries are all of a form similar to:
SELECT