sql server programming: Can SSIS moving data from one SQL 2000 db to another SQL 2000 db? If
so, can anyone tell me what i need to do this?

Execute SQL Task ?
Data Flow Task ?
OLE DB Source ?
OLE DB Destination?

It's a little confusing even after reading for a day. Any examples
great appreciate and will award you double karma points. Thanks.

Specifically I want to move some fields from some tables and even add
fields based on expressions during the transfer.

Thanks

Your subject mentions only SQL 2000 but SSIS was introduced in SQL 2005. I
assume you have a SQL 2005 server with SSIS installed that you plan to use
to copy data between SQL 2000 servers. Data copy/transforms are usually
done from within a Data Flow task. The basic steps to create a new Data
Flow task from a new SSIS package in BI Studio are:

1) From the Control Flow tab, drag a new Data Flow Task from the toolbox
and double-click to configure

2) Create OleDb connections for the source and destination databases
(right-click Connection Managers background)

3) Click the Data Flow tab in the package designer and click the link to
create a new Data Flow task

4) Drag an OLE DB Source from the toolbox onto the DF canvas and configure
for your source connection and table/query

5) Drag a Data Flow Transform Data from the toolbox and connect the OLE DB
source output (green arrow) to the transformation

6) Add additional transforms as needed, connectiong the previous
transform's output to the transformation

7) Drag an OLE DB Destination from the toolbox

8) Connect the output of the last transformation to the OLE DB Destination

9) Configure the OLE DB Destination for the destination OleDb connection.

See the Boos Online and http://www.sqlis.com/ for a number of SSIS examples.


--
Hope this helps.

Dan Guzman
SQL Server MVP

[quoted text, click to view]