I am trying to create and run the "Creating a Simple ETL Package" Tutorial
from the SQL2005 EVAL kit. I have deleted and restarted multiple times in
case I was missing something but I am getting stuck on the lookup for the
Currency date. It keeps failing and I am unsure why. I have checked to make
sure that it is of the dbdatetime type and it is. I am wondering if it has
something to do with me being in New Zealand and the date format might be
different.
When trying to debug I have changed the type of this filed in the flat file
connection and checked the preview but it always looks the same (is it meant
to).

Any idea how I can debug this at a lower level?

Cheers