when loading the transformed data into OLE DB destination, there is no options to truncate destination table first. Have to insert a middle step to run script to truncate the destination table first.
I'm very confused. We even has the options of keeping or deleting the data in destination table in SQL2000 DTS package. Why we don't have this option in SQL2005?
That's correct. You should use an Execute SQL task in the control flow before the data flow containing the OLE DB Destination.|||Phil,
is there any component in SSIS package that can let us run flexible SQL Script again the input dataset just like the input dataset is a table?
|||Jeff_LIU wrote:
Phil,
is there any component in SSIS package that can let us run flexible SQL Script again the input dataset just like the input dataset is a table?
Well, in the control flow, you have the Execute SQL task. In the data flow, you have the OLE DB Command transformation, but beware with that one as it will execute the contained SQL for every row in the input data source.|||
those two components can only use the input dataset as parameters, but can't update the data in input data source.
What I want to know is if we can run SQLScript to directly update the columns in input dataset
|||those two components can only use the input dataset as parameters, but can't update the data in input data source.
What I want to know is if we can run SQLScript to directly update the columns in input dataset
No. As I said in your other thread, you can update the columns in the data flow via a lookup transformation and a derived column transformation.
No comments:
Post a Comment