0

I want to ask something about SSIS, that have an SSIS solution that has TASK Source Azure Data Lake, and Destination Azure SQL Database

In Azure SQL Database, I have added column DATEMODIFIED from Last Modified Azure Data Lake ...

The question is "can I get the last modified data CSV Azure Data Lake into Azure SQL DB table."?

Thanks in advance

Dale K
  • 25,246
  • 15
  • 42
  • 71
Oki Kuswanda
  • 73
  • 6

1 Answers1

0

You will need a script task in your package and use the System.IO.FileInfo object in the script task to get the file properties including the file's last modified date.

You could also use REST API call or SDK as suggested in this SO thread.

NiharikaMoola-MT
  • 4,700
  • 1
  • 3
  • 15