Running a DFT Based on a condition in SSIS?

Posted by Sivanagamahesh under MSBI (SSIS, SSRS, SSAS) on 12/22/2017 | Points: 10 | Views : 201 | Status : [Member] | Replies : 0
I have a bundle where I have to recover information from a MySQL table and embed it into SQL server table. I have a circumstance wherein old information frequently gets changed and the customer needs to dump all information which is too vast and time-consuming...So I've thought of a recommendation that we'd stack just yesterday's information on weekdays and do finish dump on weekend...Is there a probability of Enable/Disabling a DFT Based on an articulation? I've Tried utilizing Expressions->Disable in view of DATEPART(WeekDAY, GETDATE()) yet it keeps running for a total load regardless of articulation's esteem

Kosmiktechnologies.com




Responses

(No response found.)

Login to post response