What is wrong with the following Statement?

I need to delete from PrismData.dbo.tblCall .

This is so simple; I can't recall the syntax.

I had a rough Holiday.

DELETE

FROM PrismData.dbo.tblCall AS Call_Prod

INNER JOIN...

I just need to convert the following into a Delete Statement for the records in Database PrismDsta.

Thank you.

SELECT *

--INTO ZZZ_tblCall_ArchivedSafe

FROM PrismData.dbo.tblCall AS Call_Prod

INNER JOIN PrismDataArchive.dbo.tblCallArchive AS arc ON Call_Prod.Call_ID = arc.Call_ID

I need a *.arc or something.

Happy holidays.

Operator error.:crazy:

Basically I am missing the Data Flow Source and Data Flow Destination task.

What action do I need to take?

INSERT INTO PrismData.dbo.tblcall

SELECT * -- TOP 5000 arc.*

FROM PrismDataArchive.dbo.tblcallArchive AS arc

WHERE YEAR(arc.Call_Date) IN (1998)

COMMIT TRANSACTION

-- ROLLBACK TRANSACTION

Msg 213, Level 16, State 1, Line 12

Column name or number of...

Eric M Russell (12/24/2015)

---

The easiest thing to do would be to disable trigger, insert in one shot, and then re-enable trigger.

I cant believe they've got you doing this b.s....

To bypass triggers can I do it in SSIS?

Is there not an option or do I have to do it from the command line?

There are triggers on the tables so I was told that I have to do the insert using a Bulk Insert from the command line.

How do you do that?

There are...

Now I get the following error:

BEGIN TRANSACTION

INSERT INTO PrismData.dbo.tblcall

SELECT TOP 5000 arc.*

FROM PrismDataArchive.dbo.tblcallArchive AS arc

LEFT JOIN PrismData.dbo.tblcall AS Pri ON arc.Call_ID = Pri.Call_ID

WHERE Pri.Call_ID IS NULL

--AND ...

Phil Parkin (12/24/2015)

---

Welsh Corgi (12/24/2015)

---

Totally screwed up.

SELECT *

FROM PrismDataArchive.dbo.tblcallArchive AS arc

LEFT JOIN PrismData.dbo.tblcall AS Pri ON arc.Call.ID = Pri.Call_ID

WHERE PrismData.dbo.tblcall Pri.Call_ID IS NULL

Msg 4145, Level 15, State 1, Line...

Totally screwed up.

SELECT *

FROM PrismDataArchive.dbo.tblcallArchive AS arc

LEFT JOIN PrismData.dbo.tblcall AS Pri ON arc.Call.ID = Pri.Call_ID

WHERE PrismData.dbo.tblcall Pri.Call_ID IS NULL

Msg 4145, Level 15, State 1, Line 13

An expression of non-boolean...

I can't get it to work.

I have done this numerous time without difficulty.

INSERT INTO PrismData.dbo.tblcall

(Call_ID,

Call_Date,

Call_Time,

Operator_ID,

Reviewer_ID,

Insurer_ID,

DivisionID,

Insurer_Name,

Insurer_Approval_Comments,

Insurer_Daily_Comments,

Adjuster,

CSR_ID,

CSR_Name,

CSR_Phone,

CSR_Ext,

CSR_Conf,

CSR_Conf_Date,

CSR_Conf_Time,

Insured_Full_NM,

Insured_FName,

Insured_LName,

Insured_Address,

Insured_City,

Insured_State,

Insured_Zip,

Insured_HPhone,

Insured_WPhone,

Insured_CellPhone,

Insured_Pager,

Insured_Email,

Insured_AltPhone,

Insured_Comments,

ThirdParty_Claimant,

ThirdParty_Phone,

ThirdParty_AccessName,

ThirdParty_AccessPhone,

Policy,

Claim,

Deductible_Amt,

Loss_Date,

Loss_Location,

Loss_Address,

Loss_City,

Loss_State,

Loss_Zip,

Loss_Descr,

Loss_Comments,

CONTR_ID,

Contractor_Name,

Contr_Rep,

Contr_Fax_Date,

Contr_Fax_Rec_Date,

Contr_Fax_Rec_Time,

Contr_Insured_Date,

Contr_Insured_Time,

Contr_Appt_Date,

Contr_Appt_Time,

Contr_Comments,

Contr_GetJob,

Contr_Cancellation,

Contr_Assigned_Date,

PRISM_Just_Dev,

PRISM_Frst_Est_Date,

PRISM_Frst_RevReq_Date,

PRISM_Received_Date,

PRISM_Closed_Date,

PRISM_Inspection_Date,

PRISM_FollowUp_Date,

PRISM_Comments,

PRISM_Frst_Review_Date,

PRISM_ClaimClosed_Date,

Owner_ID,

DateRec_ID,

Creator_ID,

CALL_LST_REV_ID_NB,

CALL_LST_REV_SER_NB,

CALL_LOCK_ID_NB,

CALL_BIX_FILE_NM,

CALL_LST_SENT_DT,

CALL_RCV_EN_IN,

Est_System,

CALL_STAT_CD,

Contr_WorkAuthorization,

Contr_EMail,

PRISM_ClaimCancellation,

Loss_Location_Same,

Nexus_ID,

Loss_Cause,

CommitDate_Con,

CommitDate_Ins,

CommitDate_Est,

Insured_Company,

PRISM_Frst_RevRec_Date,

CommitDate_Rev,

Type_ID,

Has_Been_Cancelled,

Claim_Cancelled_Reason,

Program_Option_ID,

ClientAdminResource,

CustSurveyTag,

ReinspectTag,

RandomNum,

BilledClient,

BilledContractor,

billedContrDate,

billedAssign,

billedAssignDate,

USAAregionName,

singleTradeListID,

IsDirty,

custSurveyPendDate,

callDateFull,

roofInspectionFlg,

USAAprogramArea,

xactTransactionIDValue,

profileCode,

contrEmailSentFlg,

Reinforcement_FLG,

JobStartOverrideDate,

THDSentFlg,

AddlEstNeeded,

CheckPointPriceList,

PriceList,

ReferralFlg,

MRPSupplementDate,

CATAssignment,

RvwFlg,

CMS_NextFollowUpDate,

TestFlg,

CatCode,

PendingCancellationFlg,

PendingNCFFlg,

ReferralId,

CallCenterRepAssigned,

isBeingHeld,

XADataSet,

CC_CATCode,

SymbilityClaimId,

SymbilityClaimAssignmentId,

SymbilityIntermediateClaimAssignmentId,

Loss_BuildYear,

Target_Followup_Date,

AssignmentReceiptMethodID,

TermsAndConditionsFlg

)

SELECT Call_ID,

Call_Date,

Call_Time,

Operator_ID,

Reviewer_ID,

Insurer_ID,

DivisionID,

Insurer_Name,

Insurer_Approval_Comments,

Insurer_Daily_Comments,

Adjuster,

CSR_ID,

CSR_Name,

CSR_Phone,

CSR_Ext,

CSR_Conf,

CSR_Conf_Date,

CSR_Conf_Time,

Insured_Full_NM,

Insured_FName,

Insured_LName,

Insured_Address,

Insured_City,

Insured_State,

Insured_Zip,

Insured_HPhone,

Insured_WPhone,

Insured_CellPhone,

Insured_Pager,

Insured_Email,

Insured_AltPhone,

Insured_Comments,

ThirdParty_Claimant,

ThirdParty_Phone,

ThirdParty_AccessName,

ThirdParty_AccessPhone,

Policy,

Claim,

Deductible_Amt,

Loss_Date,

Loss_Location,

Loss_Address,

Loss_City,

Loss_State,

Loss_Zip,

Loss_Descr,

Loss_Comments,

CONTR_ID,

Contractor_Name,

Contr_Rep,

Contr_Fax_Date,

Contr_Fax_Rec_Date,

Contr_Fax_Rec_Time,

Contr_Insured_Date,

Contr_Insured_Time,

Contr_Appt_Date,

Contr_Appt_Time,

Contr_Comments,

Contr_GetJob,

Contr_Cancellation,

Contr_Assigned_Date,

PRISM_Just_Dev,

PRISM_Frst_Est_Date,

PRISM_Frst_RevReq_Date

PRISM_Received_Date,

PRISM_Closed_Date,

PRISM_Inspection_Date,

PRISM_FollowUp_Date,

PRISM_Comments,

PRISM_Frst_Review_Date,

PRISM_ClaimClosed_Date,

Owner_ID,

DateRec_ID,

Creator_ID,

CALL_LST_REV_ID_NB,

CALL_LST_REV_SER_NB,

CALL_LOCK_ID_NB,

CALL_BIX_FILE_NM,

CALL_LST_SENT_DT,

CALL_RCV_EN_IN,

Est_System,

CALL_STAT_CD,

Contr_WorkAuthorization,

Contr_EMail,

PRISM_ClaimCancellation,

Loss_Location_Same,

Nexus_ID,

Loss_Cause,

CommitDate_Con,

CommitDate_Ins,

CommitDate_Est,

Insured_Company,

PRISM_Frst_RevRec_Date,

CommitDate_Rev,

Type_ID,

Has_Been_Cancelled,

Claim_Cancelled_Reason,

Program_Option_ID,

ClientAdminResource,

CustSurveyTag,

ReinspectTag,

RandomNum,

BilledClient,

BilledContractor,

billedContrDate,

billedAssign,

billedAssignDate,

USAAregionName,

singleTradeListID,

IsDirty,

custSurveyPendDate,

callDateFull,

roofInspectionFlg,

USAAprogramArea,

xactTransactionIDValue,

profileCode,

contrEmailSentFlg,

Reinforcement_FLG,

JobStartOverrideDate,

THDSentFlg,

AddlEstNeeded,

CheckPointPriceList,

PriceList,

ReferralFlg,

MRPSupplementDate,

CATAssignment,

RvwFlg,

CMS_NextFollowUpDate,

TestFlg,

CatCode,

PendingCancellationFlg,

PendingNCFFlg,

ReferralId,

CallCenterRepAssigned,

isBeingHeld,

XADataSet,

CC_CATCode,

SymbilityClaimId,

SymbilityClaimAssignmentId,

SymbilityIntermediateClaimAssignmentId,

Loss_BuildYear,

Target_Followup_Date,

AssignmentReceiptMethodID,

TermsAndConditionsFlg

FROM PrismDataArchive.dbo.tblcallArchive AS arc

LEFT JOIN PrismData.dbo.tblcall AS Pri ON arc.Call_ID = Pri.Call_ID

WHERE...

I need to insert records into PrismData tblcall from 2010 that are in the archive table.

Easy no brainer but I got the flu.

Thanks!