Unable to create a linked server.
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server with these:
Provider: Microsoft Jet 4.0 OLEDB
Product Name: Microsoft Office Access 2003
Data Source: C:\Documents and Settings\Jay\My Documents\nwind.mdb
Provider string: [copied from a Datalink file Acc.udl which tests OK for connectivity
with Microsoft Jet 4.0 OLEDB]
What is the problem
Unable to link except to SQLClient
Singing in the Rain
This is a SSIS forum. You're more likely to get an answer elsewhere.
-Jamie