Update Table with SSIS

Last Post 30 Jun 2008 10:58 PM by SQLUSA. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
chokachi
New Member
New Member

--
26 Jun 2008 06:30 AM
Good Morning to all, Im new at SSIS, i would like to know if somebody can help me with this... I have a big table A, that have lots of transformation along the day (Insert's, Delete's, Update's). I would love to know, the best way to have a Table B (with the same columns that Tab A) , always updated at evening.. Can someone help me?

Somebody know same url with an example ?
jak8989
New Member
New Member

--
26 Jun 2008 01:42 PM
You could use a SSIS execute sql task and have it run your sql insert statement for copying data from A to B directly in the database. This will most likely be one of the faster ways to copy the data but it still depends on the specifics of your envirionment
SQLUSA
New Member
New Member

--
30 Jun 2008 10:58 PM
As indicated in previous posts, we would have to know more....

You can just do this ( same db assumption) extremely simple operation in T-SQL:

SELECT * INTO TableBeta FROM TableAlpha

This is the FASTEST of all.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
chokachi
New Member
New Member

--
09 Oct 2008 08:40 AM
an if i have UPDATE or DELETE statements in original table ? how i can replicate this operation to destination table ?
You are not authorized to post a reply.

Acceptable Use Policy