sql server job agent failed

Question

Hello friends,

I have a task which runs at 8:00 pm every day....everyday it ran well, but yesterday and today the job failed and gave this error.

error Message:

Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility  Version 11.0.2100.60 for 32-bit  Copyright (C) Microsoft Corporation. All rights reserved.    Started:  10:18:57  Error: 2015-08-18 10:19:13.04     Code: 0xC0016016     Source: DDDRetail Import SSIS      Description: Failed to decrypt protected XML node "DTS:Property" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2015-08-18 10:24:46.52     Code: 0xC0029183     Source: Remove Trans File from FTP FTP Task     Description: File represented by "/kde_0155/trans.txt" does not exist.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  10:18:57  Finished: 10:24:47  Elapsed:  350.612 seconds.  The package execution failed.  The step failed.

Please help me out with the solution.

Thanks 

Ranjan DS

Answer 1

See my article Introduction to Web Site Scraping.

Answer 2

hi friend,

Please give more details about it how you want to read. if you want to read HTML file you can read it as XML file  programmatically and if you want to read it using like javascript then you can identify the table by giving it an id. and read the rows.

Please mark as answer if it helps.