Newbee...SSIS

Hi guys,

I am a newbee withh SSIS, I used DTS in SQL 2000 way back to migrate data from AS/400 DB2UDB iSeries to SQL 2000. It was easy to use DTS just specify Source and Destination and do some mapping and bingo. But now how do I do the same things with SSIS?

Is there some sort of tutorial out there? Any nice books? Any help is greatly appriciated.

T.I.A.

The simplest way to achieve it is to run the import/export data wizard (right click the Packages node and select Import/Export Data; or run DtsWizard.exe).

It is rather simple to do it without wizard as well - you'll need to create Data Flow task, and inside it create OLEDB Source and Destination, connect them and do the mapping in the destination.|||

I am having trouble using OLEDB providor, is it possible i can use ADO.NET ODBC provider that comes with AS/400 client? If I can how do i do that? I dont see any option of using ODBC provider.

TIA

|||Yes, use the DataReader Source (it should be called ADO.NET source really), it uses ADO.NET providers, including ADO.NET provider for ODBC.