December 10, 2008 at 11:29 am
Hello Everyone..
I have an SSIS package created and executing without any errors
the Package is password encripted.
Now I created a Job in SQL Server and scheduled it as a Daily Job.
but when I execute the job its failing with the following error
Message
Executed as user: THIRDWAVE\sqlserver. 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:04:28 PM Error: 2008-12-10 12:04:34.71 Code: 0x00000001 Source: Script Task System.Object[] ReadResponse(System.Web.Services.Protocols.SoapClientMessage, System.Net.WebResponse, System.IO.Stream, Boolean) Description: The request failed with HTTP status 401: Unauthorized. End Error Error: 2008-12-10 12:04:34.71 Code: 0x00000004 Source: Script Task Description: The Script returned a failure result. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:04:28 PM Finished: 12:04:34 PM Elapsed: 6.359 seconds. The package execution failed. The step failed.
can some tell me why I am getting the above error.
I new to this kind of tasks
December 13, 2008 at 2:21 pm
Chck:
The message is displayed only in two situations:
SSIS was not installed, only Tools was installed on the machine where package is running
You have Standard edition of SQL Server, and use a component that requires Enterprise edition (e.g. fuzzy lookup) - data conversion is not an enterprise component.
MJ
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply