SQL Server 2005 SSIS

SQL 2005, My first Microsoft SQL Server 2005 Integration Services (SSIS) explore with this sample
1. This SSIS will loop each file in the folder, Extract sample data from the file
2. define Lookup transformation to obtain value of current key and time key
3. Write data to destination file.

Control flow


Data flow


This SSIS exercise and detail explanation can get from "Creating a Simple ETL Package Tutorial" in microsoft website
You also can get Hand on Training for SSIS from microsoft.

SQL Sever 2005 Linked Server problem

I create linked server for sql Server 2000 32 bit in SQL Server 2005 64 bit.
When I try to run the query (select * from testserver.northwind.dbo.Customers) in SQL2005 it give me the below message :

OLE DB provider "SQLNCLI" for linked server "testserver" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "testserver" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "testserver". The provider supports the interface, but returns a failure code when it is used.

Check in google for SQL Server 2005 linked server problem and found this in microsoft website
You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server

CAUSE
This problem occurs because the system stored procedures were not upgraded to SQL Server 2000 SP3 or SQL Server 2000 SP4. You must manually upgrade the system stored procedures after you install SQL Server 2000 SP3 or SQL Server 2000 SP4.


RESOLUTION
To resolve this problem, install SQL Server 2000 SP3 or SQL Server 2000 SP4 on the 32-bit SQL Server 2000 server. Then, manually run the Instcat.sql script that is included with SQL Server 2000 SP3 or SP4 on the 32-bit SQL Server 2000 server.

more detail
http://support.microsoft.com/default.aspx?scid=kb;en-us;906954