Hope you are doing well I have a table as you can see below :
I have a variable "ExcelPath" in "SSIS" in which I keep "FilePath" column .
If you compare the sql query with the table you find out that I need to retrieve "DestinationTable" column where the "Filepath" column is equal to what is in my variable "ExcelPath"
I think everything is fine , I have no idea why I'm getting this error : "The type of the value (DBNull) being assigned to variable "User::TableName" differs from the current variable type (String)"
I was wondering if you could help me up with this issue. Thanks in advance