Fixed it as following:

(DT_WSTR,2)DATEPART("MM",[Transactin Date]) + "/15/" + (DT_WSTR,4)DATEPART("YYYY",[Transactin Date])

I have tried that but I get the message "Could not find installable ISAM"

Thank you for your help. I changed the fail to ignore and worked.

Thank you. That worked.

Aside issue on lookup.

My lookup table (reference table) has code 1, 2, 3, 4.

My main table has cod 1, 2, 3. ...

I have one source doing a select of table xyz.

This is linked to one lookup.

I have one destination. All data with value from lookup is...

I am trying to do more than one lookup on one table.

Yes. You are correct. They can all run at the same time. I was thinking in terms of maintance. If I have...

I'm doing more than just loading a table.

I was trying to see if I can add a variable to the ole souce and a variable to an ole...

Thank you. This is very helpful.

thank you. I had resolved it by creating the temp_table.

I am executing a stored procedure (sp) from SSIS and because the sp did not return any results, I could not map the columns from the sp to my destination...

All set with this. I had to create an environment variable on my workstation.

Thank you. I still need help with this expression.

Great. Thank you.

Thank you very much. This expression did work.

In the expression, instead of using xDate, I needed to use Column 2.

RIGHT("00" + (DT_WSTR, 10) DATEPART(...