Error running SSIS from SQL Agent
I created a SSIS package that loops through a table with two columns filename and data. The data is
written out to the associated filename. I imported the package to SQL 2005 sp2 with "rely on server" protection level. I can right click the package and execute without any problem. I created a SQL job to execute the package nightly and receive the
error:
Executed as user: xxxxx\sqlacct3. ...n 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:45:43 AM Error: 2010-11-21 11:45:44.63 Code: 0xC004706C Source: Data Flow Task DTS.Pipeline Description: Component "component
"Recordset Destination" (37)" could not be created and returned error code 0x80070005. Make sure that the component is registered correctly. End Error Error: 2010-11-21 11:45:44.65 Code: 0xC0048021 Source: Data Flow Task Recordset Destination
[37] Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Recordset Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation;
All Rights Reserved; http://www.microsoft.com/sql/support;0". End Error Error: 2010-11-21 11:45:44.65 Code: 0xC0047017 Source: Data Flow Task DTS.Pipeline Descript... The package execution fa... The step failed.
Recordset Destination 37 takes an OLEDB source and writes the record to a variable. I have a ForEach loop after that that loops through each record in the table, writes to the variable, then creates the file. The only reason I can think this wouldn't work is
the sqlacct3 doesn't have rights to the SSIS dll's. Any idea what's wrong? I've tried everything I can think of.
Thanks
Ben
November 21st, 2010 9:54pm