Last post May 04, 2021 12:50 PM by PatriceSc
May 04, 2021 10:16 AM|20141113|LINK
i have added a component into SSIS "Execute SQL Task Editor"
the SQLSourceType as "Direct Input"
SQLStatement as below script
create table ResultData(
,`Expected commission income` Text
,`Actual commission income` Text
,`within 1 month` Text
,`1 month` Text
,`2 months` Text
,`Outstanding Supplier Bank Receipts` Text
what action will this task perform? anyone provide more details about this task in SSIS
May 04, 2021 12:50 PM|PatriceSc|LINK
As ylu can guess it should jusr run the SQL statement you entered ie it will create this table. I assume later you'll copy data to this table?
See for example