Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MrKrabs
Starting Member
2 Posts |
 Posted - 2010-11-21 : 21:56:58
|
| 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.ThanksBen |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2010-11-21 : 22:14:29
|
I would presume the user account xxxxx\sqlacct3 is not your windows ID... Does it have the correct permissions on the file system to create the file?Does it work if executed as "sa" or other qualified Agent service account ?This KB article may help http://support.microsoft.com/kb/918760
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
MrKrabs
Starting Member
2 Posts |
Posted - 2010-11-22 : 10:36:04
|
| That is correct sqlacct3 is not my windows login, but does have full control over the directory I'm creating the files in. |
|
|
|
|
|
|
Error running SSIS from SQL Agent