How do I join a SSIS text field type cast from the Derived Column Transformation Editor with a varchar from an SQL data table in a lookup?
Also, is there any reference on which SSIS data flow datatypes can be JOINed to SQL Server datatypes?
Here's the problem: I have records in a flat file. The flat file name contains the data of the records. When importing, I read the flat file name into a data field using SSIS. Then, I use FINDSTRING to create a derived column that
contains just the file date as YYYYMMDD.
There's a SQL Table that contains Currency Rates, indexed by currency code and date, in DD/MM/YYYY format, but it's stored as a VARCHAR
A.) I tried to convert the string, '07302010' into the following formats, without success:
However, none of these can understand the string '20100730' as a date!
B.) Furthermore, if i convert the field into a DTW_STR, it still doesn't match the varchar(50) in my db.
So, basically, despite using all available typecast date formats, and several string formats as well, I can't find a way to
A.) Parse text out of a field
B.) Convert that text to either a DATE format or a TEXT format
C.) Use that resulting field to
View Complete Post