elanders1
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Kind regards
Elanders