When I tried to convert the yyyymmdd (DT_Wtsr, string, len 8) to DATE datatype (yyyy-mm-hh) using the below expression: (DB_DATE)(SUBSTRING([Column],1,4) + "-"
In SSIS, I have a data flow task which uses a data flow task to get data from SQL and save it in CSV file( using flat file connection manager). In this, I have
When I am trying to execute a SSIS package from the SQL Server Agent Job, I get this error: Executed as user: WEATRUST\Prod_SSIS_Service. Microsoft (R) SQL Ser