Newbie: Import and Export SSIS

[meguia1030]

Hi,

I've created a package with the import and export wizard. This is great, I was developing validation with the data flow so no duplicated data upload but how to Integrate this data flow with the I&E package. If not, there is another way to insert data from one instance to another, selecting the necessary tables.

Thank's in advance.

 

[MDXer]

If you need to do data cleansing as plart of your ETL process your best bet is to just build the package manually and not use any wizards. Your export you do using a Datasource and the import you use a data destination.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck