Database

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Usp_Add_AddressCommunication]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
/****************************************************************************************************/
/* NAME     : [Usp_Add_AddressCommunication]                                                                        /
/ PURPOSE  : THIS STORED PROCEDURE Addes address communication /
/ TABLES USED:                                                                                         /
/                  [dbo].[CommunicationTypeLKP]    , AddressCommunication  , Address                                                           /
<h2>/ VERSION HISTORY:-                                                                                    */</h2>

<h2>/* VERSION NUMBER|  DATE        |   AUTHOR                  |   CHANGES                                 */</h2>

/* 1.0           |  09/19/2017  |   aaleti              |   INITIAL VERSION                         */

<hr />

ALTER PROCEDURE [dbo].[Usp_Add_AddressCommunication] 
(

    @AddressId int,
    @CommunicationType varchar(60),
    @CommunicationValue varchar(60),
    @CreatedBy varchar(30)

)

AS
BEGIN
DECLARE @CommTypeId int
SET @CommTypeId = (Select top 1 CT.PKCommunicationTypeLKPId from CommunicationTypeLKP CT where CT.CommunicationTypeDesc = @CommunicationType)

         INSERT INTO [dbo].[AddressCommunication]
           ([FKAddressId]
           ,[FKCommunicationTypeLKPId]
           ,[CommunicationValue]
           ,[ValidFlag]
           ,[CreatedDate]
           ,[CreatedBy]
           ,[ModifiedDate]
           ,[ModifiedBy]
           )
     VALUES
           (@AddressId
           ,@CommTypeId
           ,@CommunicationValue
           ,1
           ,getdate()
           ,@CreatedBy
           ,getdate()
           ,@CreatedBy)
            select SCOPE_IDENTITY() as PkAddrCommId

END
' 
END

$id = 47;
echo 'current id is:'.$id;
//GET PREVIOUS ID
$stmt= $db->prepare("SELECT * FROM blog WHERE article_id<$id LIMIT 0,1");
$stmt->execute();
$row=$stmt->fetch(PDO::FETCH_ASSOC);
echo '<br>';
echo 'Previous ID is:'.$row['article_id'];
//GET NEXT ID
$stmt= $db->prepare("SELECT * FROM blog WHERE article_id>$id LIMIT 0,1");
$stmt->execute();
$row=$stmt->fetch(PDO::FETCH_ASSOC);
echo '<br>';
echo 'Next ID is:'.$row['article_id'];

current id is:47
Previous ID is:24
Next ID is:48

<h2>TITLE: Import Package</h2>

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.

<hr />

ADDITIONAL INFORMATION:

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.

<hr />

BUTTONS:

<h2>OK</h2>

..==================================

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.

Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility  Version 11.0.6020.0 for 64-bit  Copyright (C) Microsoft Corporation. All rights reserved.    Started:  2:11:14 PM  Error: 2018-06-04 14:11:14.23     Code: 0xC0011007     Source: {12A3883D-DB4A-4085-A76A-DFB45C939490}      Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted.  End Error  Error: 2018-06-04 14:11:14.23     Code: 0xC0011002     Source: {12A3883D-DB4A-4085-A76A-DFB45C939490}      Description: Failed to open package file "C:\Users\ssubrama\Desktop\CFRS_Provider_2.dtsx" due to error 0x80070005 "Access is denied.".  This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling LoadPackage or the specified XML file has an incorrect format.  End Error  Could not load package "C:\Users\ssubrama\Desktop\CFRS_Provider_2.dtsx" because of error 0xC0011002.  Description: Failed to open package file "C:\Users\ssubrama\Desktop\CFRS_Provider_2.dtsx" due to error 0x80070005 "Access is denied.".  This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling LoadPackage or the specified XML file has an incorrect format.  Source: {12A3883D-DB4A-4085-A76A-DFB45C939490}  Started:  2:11:14 PM  Finished: 2:11:14 PM  Elapsed:  0.125 seconds.  The package could not be found.  The step failed.
The job failed.  The Job was invoked by User DHSINTRA\SSubrama.  The last step to run was step 1 (OPSExtract).