I had to setup the OLE DB provider for the SQL 2000 server. It seems that the SQL Connector is only for SQL 2005.

I have connected the OLE DB...

Thanks for the informative reply. Would you suggest using OLE DB or SQL Server as the data flow destination when connecting to SQL 2000?

Sorry to bring this thread back from the dead but I'm in the exact same situation.

I realize that this is the SQL 2005 forum so please excuse the off topic...