title: Changing date time of server stops Execution of SSIS package, How to test time dependency?
body: <p>Changing date time of server stops Execution of SSIS package, How to test time dependency? (Error at the bottom)</p>
  
  <p>I have an SSIS package that uses 3 servers, </p>
  
  <p>1.Server A to get data from</p>
  
  <p>2.Server B to insert data into </p>
  
  <p>3.Server C is where the SSIS package lives and gets executed from.</p>
  
  <p>I have a select logic depending on GetDate() when getting data from server A, </p>
  
  <p>For testing, Changing date on Server C to activate the logic depending on GetDate() does not apply the expected logic.</p>
  
  <p>Changing the Date on all 3 servers or just server A and C, or just C causes error : "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."</p>
  
  <p>The same SSIS package runs as expected when changing the date on dev machine as all 3 database reside on the same server on the dev machine.</p>
  
  <p>Why the hell loading of XML depends on what date it is?? </p>