[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Update data with SSIS Using Import and Export Wizard

Posted on 2011-10-27
2
Medium Priority
?
376 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:elanders1
2 Comments
 
LVL 15

Accepted Solution

by:
Anuj earned 150 total points
ID: 37042757
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
 

Author Closing Comment

by:elanders1
ID: 37042902
Thanks anujnb,

Kind regards
Elanders
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question