Import Data into SQL Table 1

[mekohler]

Hi, I need to bring in data from a proprietary database into a SQL Database. I would like to do this using a SSIS package. My question, is there a way of importing the data into an existing table without re-creating the table in the package? I've created a similar package where every time it runs the table is deleted and re-created. Is it possible to simply delete the data in the table and import the data into this table?
Thanks,
Michael Kohler

 

[fredericofonseca]

yes.

create a package with a execute sql task, followed by a dataflow task. lots of examples both on the manuals and on the net for this.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[mekohler]

Thanks for the help. That worked.