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?
LVL 1
cheryl9063Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
PedroCGDConnect With a Mentor Commented:
Inside a Data Flow use the OLE DB Command!
In the SQL Statment use the following syntax EXEC MyStoredProcedure ?,?,?,?
Helped?
regards,
Pedro
0
 
x-menConnect With a Mentor IT super heroCommented:
open the "package.dtsx"

insert a "Execute SQL Task" - in properties - General - SQL Statement: write your INSERT T-SQL statement
0
 
SThayaConnect With a Mentor Technical MAnagerCommented:
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
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.