The following error occurred but did not provide any additional info.
[DTS.Pipeline] Error: The PrimeOutput method on component "Pgrs - tr_hist" (14596) returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
For this package I am trying to use DataDirect's ODBC driver for a Progress OpenEdge Database version 9.1E to move data to SQL Server 2005 in order to make use of SQL's BI suite. I have consulted the DataDirect and have that the driver is functioning properly. The driver works perfectly from another application. They suggest that the problem is in the the datareader's or the connection manager's implementation of the driver.
Please tell me what is the cause of this or at least how to troubleshoot this problem.
Currently I have an event handler on my package that executes a script task on the "OnError" event (at the package level).
One of the error handler's script task's job is to capture the "System::ErrorDescription" and store it to a user variable which is then later sent in an email. That part works fine.
But what I am wondering is, there a way to make the error description more descriptive?? I would like to send a custom error message from one of the tasks in my package, if possible. The task is a script task.
Currently, the "System::ErrorDescription" is just: The Script returned a failure result.
Which isn't too terribly descriptive! But this is the default error description.
Is there something I can do to change the default error message for my script task?? Is there a way I can set the "System::ErrorDescription" on this script task, perhaps? Or is there another way?
I have a SQL server scheduled to replication. This works fine if it has to do that one the sever on the same mechine. If it has to be done to another server, the replication fails with the following error message.
08001[Microsoft][ODBC SQL Server Driver][dbnmpntw]Connectionopen(Createfile())
We have changed the Network Domain name of a SQL server and restarted before changing any of the settings in SQL server. When we now try to start the SQL server service manager we get the following error
Your SQL server is either corrupt or has been tampered with. Unknown package id please rerun setup
Any suggestions on how to get the SQL server back on line without having to take the server down and changing the Netowrk Domain Name back ??
This is my first posting and actually I have big problem which I need to resolve immediately:
I have a 38 GB Database on my SQL Server which I want to full-backup. Until now backup was created on the same volume where the database resides. But now the volume is out of disk space. So what we did is that we connected an external USB disk drive with 500 GB to the SQL Server and try to backup there.
But our first and all consecutive backup attemps failed with error SQL-DMO (ODBC SQLState: 42000). It's working fine the first few minutes as we can see that the backup file is continously growing. But then it abruptly aborts with above error message.
Can anyone figure out why ? Any help is appreciated.
I hope I'm posting this in the right section but I have a few SSIS packages that run as SQL Agent jobs that bomb out and does not give me much of a description as why it did. I only get a message that the package failed.
On a different machine, a sql cluster more specific, the job history use to be more elaborate and told me exactly which component errored out.
Is there a setting that I must set somewhere to get a more descriptive error message in the job history?
hi all, I am developing an application in C# which creates SSIS package programatically.These packages perform various activities like transfering data from one server to another,extract data from table,transfering data from sql to msaccess etc.Here I am using the following code to get the description of the SSIS errorcode.
For example if the error code is 0xC0204018,the application shows its equivalent description as "The "%1!s!" has a precision that is not valid. The precision must be between %2!ld! and %3!ld! "
But the actual error message is "The Output column "fund" has a precision that is not valid. The precision must be between 1 and 18"
My question is how to show more descriptive error message..like how to replace "%1!s!" to the actual field.
I have a bundling package that runs about 20 other packages. It has been working fine for a while but a couple of days ago it fail with the following message,
Error 0x800706BE while loading package file "D:PackagesToradSales.dtsx". The remote procedure call failed.
Iīm running the SSIS packages in an 64-bit environment.
Hi I am trying to import a excel file into a table but when i run it i am getting this error and i am not sure what this eror is - Copying to [ICCStatements].[dbo].[Sheet1$] (Error)
Messages Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unspecified error".(SQL Server Import and Export Wizard) Error 0xc020901c: Data Flow Task: There was an error with input column "AdminShowInKit" (148) on input "Destination Input" (102). The column status returned was: "The value violated the integrity constraints for the column.".(SQL Server Import and Export Wizard) Error 0xc0209029: Data Flow Task: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (102)" failed because error code 0xC020907D occurred, and the error row disposition on "input "Destination Input" (102)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.(SQL Server Import and Export Wizard) Error 0xc0047022: Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - Sheet1$" (89) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.(SQL Server Import and Export Wizard) Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited.(SQL Server Import and Export Wizard)
I'm having problems when I try to run a package from a job in SQL Server Agent. I have the same package in a server and it works fine,but when I try to install it in a different server I keep getting this error:
Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 01:19:10 p.m. Progress: 2007-01-30 13:19:10.40 Source: Delete scripts Execute Process Task Operation Complete: 0% complete End Progress Error: 2007-01-30 13:19:10.57 Code: 0xC0029151 Source: Delete scripts Execute Process Task Description: In Executing "C:Project_SSISDelete_Items.bat" "" at "", The process exit code was "1" while the expected was "0". End Error Progress: 2007-01-30 13:19:10.57 Source: Delete scripts Execute Process Task Operation Complete: 100% complete End Progress Warning: 2007-01-30 13:19:10.57 Code: 0x80019002 Source: Upload data Description: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning DTExec: The package execution returned DTSER_FAILURE (1). Started: 01:19:10 p.m. Finished: 01:19:10 p.m. Elapsed: 0.5 seconds
I can run it from Integration services Server, from BI, and I tried modifying the ProtectionLevel property to DontSaveSensitive and ServerStorage. I have other packages that run in jobs, and they work fine...but i donīt know what else to do....By the way, I'm using an administrator user to run the package.
When I want to execute my package as a job in a SQL Server 2005, I get this Message:
Executed as user: EDAsvcSQLServerPMS. ....00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 09:46:00 Error: 2008-05-16 09:46:01.41 Code: 0xC0048020 Source: Data Flow Task Data Flow Task (DTS.Pipeline) Description: The version of component "Excel Source" (1) is not compatible with this version of the DataFlow. End Error Error: 2008-05-16 09:46:01.54 Code: 0xC0048020 Source: Data Flow Task DTS.Pipeline Description: The version of component "Excel Source" (1) is not compatible with this version of the DataFlow. End Error Error: 2008-05-16 09:46:01.54 Code: 0xC0048021 Source: Data Flow Task Excel Source [1] Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Excel Source;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://ww... The package execution fa... The step failed.
The package works fine on the developed server but when I try it out on our integration server it won't go through without these errors. The protection level is set on DontSaveSensitiv and allready I had an error less.
I hope someone can help me, because I can't find anything with google. Thanx!
I'm at a loss as to why i am getting the following error:
Retrieving the COM class factory for component CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E}failed due to the following error: 80040154
I am calling the package from a C# application which i have installed within a citrix environment. The application works without any trouble on my development machine but as soon as i run the code that executes the SSIS pacakge i get the error. Can anyone enlighten me as to what is causing this?
When I try to load an SSIS package via C# code I get the following error message:-
"The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails. "
The code is pretty straightforward:-
Application app = new Application();
PackageEvents evts = new PackageEvents();
Package pkg = new Package();
Package pkg = app.LoadPackage("C:\Documents and Settings\dominic_s\My Documents\Visual Studio 2005\Projects\SSIS_Util\bin\Debug\DTS\Cleanup_Staging.dtsx",evts,true);
return pkg;
What's interesting is this error message only appear's when I Start Debugging (F5 in VS 2005). If I Start without Debuggging (CTRL+F5) I dont get this error message. I've tried almost everthing suggested by other posts in this forum related to the same issue but nothing seems to work.
I am having an interesting SSIS problem where the package fails to load with the following error message:
Code: 0xC0010018 Source: {BE86A659-AB44-403A-9C89-3524821879E0} Description: Error loading value "" DTS:Name="SqlStatementSource">"Select dbo.fnGetLastOpenExtract('" + @[User::in_ExtractName] + "') as eh_ID"" from node "DTS: PropertyExpression".
This very same package runs on our test server, but fails to even load on UAT server.
SSIS packages are the same on both Test and UAT servers (I compared not just dates and sizes - they are literally the same: byte-to-byte) DTExec version is 9.00.3042.00 on both servers. HKLMSOFTWAREMicrosoftMicrosoft SQL Server90DTSSetupVersion = 9.2.3042.00 on both machines.
This started to happen when the UAT machine was upgraded to Service Pack 2 of SQL Server 2005. Please note that the UAT server only runs SSIS packages and does not have SQL 2005 database engine installed. There is, however, an older installation of SQL Server 2000 on UAT machine (I am not sure if Test machine has it - will check tomorrow).
Any help is greatly appreciated.
Thanks,
Alex
Here is the compete output from DTExec:
Code Snippet
D:AM5Jobs>"C:Program FilesMicrosoft SQL Server90DTSBinnDTExec.exe" /File "D:ExtractsGBG_ExtractSSISImport_ExtractStartComplete_03.dtsx" /Checkp OFF /Cons MT /Set Package.Variables[User::in_ExtractName].Properties[Value];SagittaMapping_Replication /Set Package.Variables[User::in_StartComplete].Properties[Value];Start Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 12:33:21 PM Error: 2007-07-17 12:34:52.98 Code: 0xC0010018 Source: {BE86A659-AB44-403A-9C89-3524821879E0} Description: Error loading value "<DTS:PropertyExpression xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:Name="SqlStatementSource">"Select dbo.fnGetLastOpenExtract('" + @[User::in_ExtractName] + "') as eh_ID"</DTS:PropertyExpression>" from node "DTS:PropertyExpression". End Error Error: 2007-07-17 12:34:52.98 Code: 0xC0010018 Source: {BE86A659-AB44-403A-9C89-3524821879E0} Description: Error loading a task. The contact information for the task is "Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. End Error Error: 2007-07-17 12:34:52.98 Code: 0xC0010021 Source: Description: Element "{1c66489c-2a3f-4c8a-b9e7-0161875427a2}" does not exist in collection "Executables". End Error Error: 2007-07-17 12:34:52.98 Code: 0xC0010018 Source: Description: Error loading value "<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" IDREF="{1c66489c-2a3f-4c8a-b9e7-0161875427a2}" DTS:IsFrom="-1"/>" from node "DTS:Executable". End Error Error: 2007-07-17 12:34:52.98 Code: 0xC0010018 Source: Description: Error loading value "<DTS:PrecedenceConstraint xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Property DTS:Name="Value">0</DTS:Property><DTS:Property DTS:Name="EvalOp">2</DTS:Property><DTS:Property DTS:Name="LogicalAnd">-1</DTS:Property><DTS:Property DTS:Name="Expression"></" from node "DTS:PrecedenceConstraint". End Error Could not load package "D:ExtractsGBG_ExtractSSISImport_ExtractStartComplete_03.dtsx" because of error 0xC0010014. Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails. Source: Started: 12:33:21 PM Finished: 12:34:53 PM Elapsed: 91.938 seconds
I try to make SSSIS packages made on my pc accesible to an other user of SSIS (both running on Windows 2000). The packages are on a shared drive in our LAN.. Some configurationfiles are use to configure the Oracle DBconnection.The same files are on the same location on both PC's
The other user can open and run the packages but from the moment the lookup buffers are loaded, we get the following errors:
Error: 0xC0202009 at AB_ADDRESS_DF, LOOKUP_POST_ID [22801]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "".
Error: 0xC020824E at AB_ADDRESS_DF, LOOKUP_POST_ID [22801]: OLE DB error occurred while populating internal cache. Check SQLCommand and SqlCommandParam properties.
Error: 0xC004701A at AB_ADDRESS_DF, DTS.Pipeline: component "LOOKUP_POST_ID" (22801) failed the pre-execute phase and returned error code 0xC020824E.
I did a small package with only one ODBC connection (Merant 3.70 32-Bit Progess). This package runs well in Visual Studio and fails when runs by SQL Server Agent.
Configuration:
SQL Server Agent on a 32Bit server.
The ODBC connection configuration in available on System DSN on this server.
The user of Server Agent have full access (Admin).
Connect Manager Provider: ".Net ProvidersOdbc Data Provider"
SQL Server version: 9.0.3042
Error Message:
Executed as user: TEKCON cadmin. ...ion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 16:50:33 Error: 2007-06-11 16:50:33.62 Code: 0xC0047062 Source: Data Flow Task DataReader Source [1] Description: System.Data.Odbc.OdbcException: ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcCon... The package execution fa... The step failed.
I created a .bat file with this instruction and It's run well:
I have developed an SSIS package that includes a Script Task on a 32-bit machine. The PrecompileScriptIntoBinaryCode property is set to True. After I build the package, the .dtsx file includes a <BinaryItem> element for that Task. Package runs fine on the dev machine, both in BIDS and as SQL Server Agent job.
When I deploy the package to a 64-bit server, it runs fine when I execute the package ad hoc from SQL Server Management Studio. However, when I schedule the package for execution as a SQL Server Agent job, the package fails with the message: "the script files failed to load."
I have reviewed posts on this error from late 2005, but the solutions don't work in this case. Specifically:
1. The Precompile property is already set to True.
2. I have already verified that the script was compiled.
I have developed a SQL Server 2005 Integration Services (SSIS) package that includes a Script Task on a 32-bit machine. The PrecompileScriptIntoBinaryCode property is set to True. After I build the package, the .dtsx file includes a <BinaryItem> element for that Task. Package runs fine on the dev machine, both in BIDS and as SQL Server Agent job. When I deploy the package to a 64-bit server, it runs fine when I execute the package ad hoc from SQL Server Management Studio. However, when I schedule the package for execution as a SQL Server Agent job, the package fails with the message: "the script files failed to load." I have reviewed posts on this error from late 2005, but the solutions don't work in this case. Specifically: 1. The Precompile property is already set to True. 2. I have already verified that the script was compiled. Any further suggestions?
I've got a merge replication set up between boxes. They're on separate sites both behind an ADSL Nat modem router. The publisher connects to the subscriber via a port forward / Nat translation at the router. This replication set up has been running for some months now. This morning I got this failure message from the merge agent on the publisher.
"the specified remote server name may not be the network name of the remote server or the remote server is unreachable due to network problems. The step failed"
Currently the Enterprise Mgr at the publisher can see the subscriber as can query analyzer running on the publisher.
The host name of the subscriber is the same name used in the server registration at the publisher. The registration uses a Client Network Utility alias to resolve the name.
If I run a ping command at the publisher using the subscribers name I get replies (the resolution of that name is done via a hosts file entry)
Both machines are Win2k Server boxes running SQL Server 2000 Standard.
Any ideas why the agent can't see the subscriber despite the fact its usual communications channel is working just fine?
Hi All, I am trying to restore a DB from my production to Standby server..it gives me a mesage "Msg 3105, Level 16, State 1 Data on dump will not fit into current database. Need 6500 Mbyte database."
The production server DB size is 5000MB and I have increased the size of standby DB to 6500MB but still the same message...
There is an execute package task that calls the child package. Both parent and child packages have the same password and the passwork is entered into the execute package task. Both packages reside in the same directory path.
Error: Error 0xC0012050 while loading package file "C:Documents and SettingsuserMy DocumentsVisual Studio 2005ProjectsExecutePackageTestExecutePackageTestExtractandWrite.dtsx". Package failed validation from the ExecutePackage task. The package cannot run.
When ExtractandWrite.dtsx is executed by right-clicking on package, the package executes without any errors.
DelayValidation = True for the Execute Package Task tasks is set and DelayValidation for the connection manager is set to True.
Does anyone have any thoughts as to what might be causing this error?
I'm converting a replication script from SQL 2000 to SQL 2005.
I am getting an error with push merge with no way to figure out what is wrong.
I've configured replication on a single XP server in SQL 2005 RTM version.
I have a push merge set up between A and B and between B and C. All 3 databases are 9.0 compatibility.
The snapshot and merge jobs for the A to B run fine with no errors, and merge replicates ok.
The snapshot for B to C fails with this message: Message 2006-03-09 17:30:35.94 --------------------------------------------- 2006-03-09 17:30:35.94 -BcpBatchSize 100000 2006-03-09 17:30:35.94 -HistoryVerboseLevel 2 2006-03-09 17:30:35.94 -LoginTimeout 15 2006-03-09 17:30:35.94 -QueryTimeout 1800 2006-03-09 17:30:35.94 --------------------------------------------- 2006-03-09 17:30:35.95 Connecting to Publisher 'MyInstance' 2006-03-09 17:30:35.97 Publisher database compatibility level is set to 90. 2006-03-09 17:30:35.97 Retrieving publication and article information from the publisher database 'MyInstance.MyDB' 2006-03-09 17:30:36.22 [0%] The replication agent had encountered an exception. 2006-03-09 17:30:36.22 Source: Replication 2006-03-09 17:30:36.22 Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException 2006-03-09 17:30:36.22 Exception Message: Data is Null. This method or property cannot be called on Null values. 2006-03-09 17:30:36.22 Message Code: 52006 2006-03-09 17:30:36.22
Love that exception message: "Data is Null" - very helpful to someone who is clairvoyant perhaps. I checked the snapshot bcp files. The tables being merged all have data.
If you have any ideas on how to fix this, I'd be most grateful. As it is after 6pm I probably won't read this again until morning. Thanks for any suggestions.
CREATE PROCEDURE CraigSource2Dest AS INSERT INTO TCraigDest( MyCertN ,MyResult ,MySpec) SELECT TOP 10 dbo.TCertResults.ICertResultsN ,dbo.TCertResults.ICertValue ,dbo.fx_source2dest(dbo.TCertResults.ICertValue) FROM dbo.TCertResults GO
As you can see theres a function in the middle of select statement, that returns a value based on what passed into it. The procedure above works fine.
The problem I have is this, can I use the value that the function returns later in the SELECT statement. As an example lets say the table had 4 columns and in the fourth column I wanted to insert the value that the function returned + the word 'TEST'.
I've tried 2 methods of doing this the first : CREATE PROCEDURE CraigSource2Dest AS INSERT INTO TCraigDest ( MyCertN, MyResult, MySpec, MyDerivedColumn ) SELECT TOP 10 dbo.TCertResults.ICertResultsN ,dbo.TCertResults.ICertValue ,dbo.fx_source2dest(dbo.TCertResults.ICertValue) AS MyNewValue ,MyNewValue + 'TEST' FROM dbo.TCertResults GO
When I try this I get the error that MyNewValue is not a valid column name.
And the 2nd method was to try to assign the value returned from the function to a variable. Something like this
CREATE PROCEDURE CraigSource2Dest AS DECLARE @MyNewValue AS VARCHAR(65) INSERT INTO TCraigDest ( MyCertN ,MyResult ,MySpec ,MyDerivedColumn) SELECT TOP 10 dbo.TCertResults.ICertResultsN ,dbo.TCertResults.ICertValue ,@MyNewValue = dbo.fx_source2dest(dbo.TCertResults.ICertValue) ,@MyNewValue + 'TEST' FROM dbo.TCertResults GO
This way gives me ERROR 141 : A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.
Bit stumped really up to the point that I don't even know what to search for to look for help.
I had just installed SQL 2005 dev on my laptop and got an error message when I tried to create a package using the BI IDE. I received the same error using VS2005 IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again, but with an option to view the error details.
Following is the text of the error details:
TITLE: Microsoft Visual Studio ------------------------------
I have an File System Task that copies a file from one directory ot another. When I hard code the target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:
[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".
I'm trying to use an XML Task to do a simple XSLT operation, but it fails with this error message:
[XML Task] Error: An error occurred with the following error message: "There are multiple root elements. Line 5, position 2.".
The source XML file validates fine and I've successfully used it as the XML Source in a data flow task to load some SQL Server tables. It has very few line breaks, so the first 5 lines are pretty long: almost 4000 characters, including 34 start-tags, 19 end-tags, and 2 empty element tags. Here's the very beginning of it:
<?xml version="1.0" encoding="UTF-8"?> <ESDU releaselevel="2006-02" createdate="26 May 2006"><package id="1" title="_standard" shorttitle="_standard" filename="pk_stan" supplementdate="01/05/2005" supplementlevel="1"><abstract><![CDATA[This package contains the standard ESDU Series.]]></abstract>
There is only 1 ESDU root element and only 1 package element.
Of course, the XSLT stylesheet is also an XML document in its own right. I specify it directly in the XML Task:
I set up a DTS package to run every night on my SQL 7 Server. It is supposed to write a text file of modified rows every night. It was working fine until I changed the password for sa, now it fails. Also in Enterprise Manager, when I try to look a the package properties, I get a "login failed for user sa" package error.
I have stored procedure that uses the xp_cmdshell procedure to use the dts run to run some dts packages. This package exports data into an Access 97 database. When I run it I get this error: Error: -2147467259 (80004005); Provider Error: -533791822 (E02EFBB2)
Error string: Could not update; currently locked by user '(unknown)' on machine ''.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003218
If I right click on the local package and select execute it runs with no problem. Any ideas what is going on?
I have a DTS package set up to push data out to several sites. When I execute the package it runs perfectly. When I schedule it as a job it fails. I checked the proxy account in the SQLAGent properties and there is a check mark there. But the job still fails.
