This one has bugged me for the longest time and a great question to ask the Stackoverflow users I think.

I have a rather large SSIS flow that uses a string variable to store the datetime. I would now like to dynamically read the datetime value from the database, but how would you construct the SSIS to do this?

My first obvious thought would be to simply execute a SQL task to get the datetime and store it in the variable, but got the "differs from the current variable type" error.

Is there a simple way to convert the database datetime into a String variable?

Any help from the community would be appreciated,