Update data with SSIS Using Import and Export Wizard

Hi

I wonder if it is possible to UPDATE data in a table where you can match on CompanyID by running the Import and Export Wizard from SQL Management Studio, or do I need to build an SSIS package in BIDS?

I would just updating two fields, Budget and Income in the Company table, the rest will remain untouched and only when i got a match on CompanyID.

Kind Regards
Elanders
elanders1Asked:
Who is Participating?
 
AnujSQL Server DBACommented:
This cannot be done using Import\Export wizard, Your guess is correct and you need to depend SSIS package to do this. There are various SSIS tools available on BIDS like Script Task, SCD etc that makes your task easy.
0
 
elanders1Author Commented:
Thanks anujnb,

Kind regards
Elanders
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.