Hi,
I'm running a SQL Server 2005 instance and a SQL Server 2000 instance
and I'm looking to transfer data i've played with written in T-SQL
(takes Data from a table, clean it up, and inserts it into a temp
table)
I was wondering if I could do a SSIS transformation using an OLE DB
Source (the 2000 Server) process the SQL and then map and insert the
results into a table in my 2005 DB?

Otherwise I will have to use DTS to put the data into a file.

(No i cannot detach and attach the DB, etc etc etc) hehe hence why i'm
asking.