I am trying to programatically create an SSIS package containing a simple data flow from table A to table B in the same database. I am using the example given here. The package gets created and saved to a dtsx file, but when I open it in visual studio I see that the source and destination tables have not been selected.
I also want to insert a transformation task in between before it reaches the destination. Any clues, pointers?
Thanks.
EDIT
Well I have managed to get the source and destination tables selected and the task even ran successfully. Turns out I needed to
(a) use one oleDB connection each for the source and detination [I dont like this way; I want to use one connection only]
(b) set the Accessmode to 3 in the destination SetComponentProperty("AccessMode", 3) which equates to Table or View - fast load.
Is there some documentation on this somewhere. All I can find is what SetComponentProperty does, and not what all parameters it can take to do that. eg. what else can I put there besides "AccessMode"?, what does the second parameter 3 or 2 or 1 stand for?
Still trying to map the monikers. STOCK:PipelineTask means DataFlow Task. What is the moniker for say... copy column?