Merge data from two different source until the data is available from both sourc

• komal145

  SSCrazy Eights

  Points: 9920

  More actions

  May 13, 2025 at 8:40 pm

  #4590803

  I have two sources , one coming from datalake and another is file. we need to match date to combine both dates. But , the data from source may not be avilable daily or might be delayed.

  So, we have data from datalake coming daily but data from file comes only from Tuesday - Saturday , as we pull today -1 date (using ssis)

  example on thursday , we pull wednesday data.

  BUT On tuesday we get data from saturday , sunday and Monday.we need to wait untill both dates from datalake and file is available and then process.

  How can i process this combined based on date using SSIS  and SQL ? Any suggestion?

   

   

  • This topic was modified 1 day, 18 hours ago by  komal145.
  • This topic was modified 1 day ago by  komal145.
  • This topic was modified 21 hours, 3 minutes ago by  komal145.
  • This topic was modified 21 hours, 2 minutes ago by  komal145.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 14, 2025 at 9:10 pm

  #4591346

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.