title: find the day example saturday from date in ssis
body: <p>I want to find out the day of the week from date in ssis.</p>
  
  <p>Actually i want to move the data from one server to another,</p>
  
  <p>In the source server there is one cloumn reportdate having the previous date,so while i wan to copy in to the destination server  wan to insert todays date,but there is one case like there is no data comes on sunday in the source server in that case i will  have the data of saturday so in this case i want to update the date in the destination server with 2 days plus,please let me know how can i reslove this using ssis.i'm using derived column for manipulating the date column <code>DATEADD("day",2,reportdate) : DATEADD("day",1,reportdate)</code>,</p>
  
  <p>so first part will update the date plus 2 of the sourcedate into the detsination table date but how will i find the day of week means when the saturday comes...please let me know how can i reslove this using ssis.</p>
  
  <p>Thanks is advance..</p>