My SSIS pkg requires a SQL SELECT against a table to select qualified rows based on a date.
The parameter passed from DTEXEC is CHAR(8) format YYYYMMDD (eg. 20090729) and is then stored in SSIS pkg variable pDATE
My SSIS Data Flow data source (a SQL table) needs to extract all rows from the table where table_date_column = pDATE
The SSIS pkg is failing because it is not converting the CHAR(8) format to datetime format.
This SQL will perform the conversion: SELECT convert(datetime, '20090729', 112)
Question is: How do I get the CHAR(8) variable, passed in from the DTEXEC, converted to a DATETIME to be used in my data source SQL selection criteria
BT