Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2008-02-21 : 08:09:44
|
| Hi, I have been intoduced to SSIS in the past 48 hours and am learning fast.I have managed to go to the BIDS and create a simple import package from a flat file to a Table in the database. I also have learned how to create a job to run this package using the SQL server agent.This worked fine the first time and created my table, subsequently it has failed everytime because it is trying to create the table everytime but the table already exists and i don't want to crop and recreate the tableI need to do 2 things but can't yet figure out where/how1. I need to know how to append to the table NOT create a new one2. I need to know how to edit the query so that i only append if the unique ref doesn't already exist.Currently in BIDS I have a preparation SQL task and a data flow task in the contol flow tab and I have A source, a data conversion and a destination object in the data flow tab...NOT SURE what to edit to achieve my goalThanks a lot |
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2008-02-21 : 11:08:40
|
| To add to table,Drag and drop the SQL Server destination task.Assign the table you want to assignThen do the column mapping2. Use lookup data flow task to check whether the records exsits.Configure error to Redirct when errorPoint the red pipe line to the table---------------------http://dineshasanka.spaces.live.com/ |
 |
|
|
|
|
|
New to SSIS