Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 978
  • Last Modified:

How to use SSIS to update a table in SQL Server 2008

What SSIS componite do you use to update a SQL Server 2008 table? How do you? Please dont just say use a sript task.. tell me how?
0
cheryl9063
Asked:
cheryl9063
3 Solutions
 
PedroCGDCommented:
Inside a Data Flow use the OLE DB Command!
In the SQL Statment use the following syntax EXEC MyStoredProcedure ?,?,?,?
Helped?
regards,
Pedro
0
 
x-menIT super heroCommented:
open the "package.dtsx"

insert a "Execute SQL Task" - in properties - General - SQL Statement: write your INSERT T-SQL statement
0
 
SThayaCommented:
Hi ,

  1. you can use update statement in "Execute SQL Task"  
  2. using Slowly changing diamension , you can achive new record insertion /updation in the existing record
 3. use the Look up transfermation , consider unmatching rows as  insert and redirect the matching rows with the update statement in "Execute SQL Task"
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now