ssis

Source

Table A
column a
column b
column c

Table B
column f
column z
column h

Destination
Table Y
column j
column k
column l

Table e
column o
column n
column r

I would like to move records from multiple tables (tableA & table B) from the source to (table y & Table e) in the destination on a regular basis based on a filter criteria on the source tables. Should I use Import export wizard in ssis and store it as an ssis pacakage and pass parameters to provide filter criteria.

Or

Can we do it in a data flow task in ssis.

Please adviceStart Free Trial