i'm using the dts wizard that is provided via the additional tools for sql server 2005 express. i can connect to my server, select a db and select the table/view that i would like to export. likewise i can configure the target for the export to access, another sql server db, or xl. however - upon executing i get the following in the report when it fails.
i have tried both sql native and oledb for sql server. when using ole i can export a table/view to txt. this is an ok soln but i really need to be able to use the dts for exporting multiple tables to an access db periodically.
i've spent a good amt of time reading every post that i can find relating to this topic and error number.
any help is greatly appreciated!!!
the answer may be here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/2ea031b0-b79f-4b1f-9f2a-d5f980f5b1b0 - a dll to unregister...
Or there is a suggestion here http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic24315.aspx that the error relates to SQL Agent not running. Are you running the package as a job or manually?