ssis package for error handling - Integration Services (SSIS) and DTS

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » ssis package for error handling

ssis package for error handling

Options

Previous Topic · Next Topic

dibyant

Posted: Friday, February 01, 2008 12:38:40 AM

Rank: Newbie

Joined: 1/21/2008
Posts: 9
Points: -73
Location: usa

I have an integration task to do. This first step is basically to copy all new rows from a table in one database to a similar table in another database
( how to do that).
I have a reader in my dataflow that pulls out the rows I want ( how to do that in dataflow). Then I use a OLEDB destination to write the data to the correct table.
However, when a write is successful, I need to set a statusflag in my originating table row ( how). I also need to log any errors that occur.

What is the best way to do this data flow implement and write the status when it is successful?

please respond ( if possible) with illustration in the dataflow task

thanks

dibyant

Posted: Saturday, February 02, 2008 5:58:42 PM

Rank: Newbie

Joined: 1/21/2008
Posts: 9
Points: -73
Location: usa

i think i can solve that problem through the way is shown here follow this link for the better explaination--
http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx

also, there is a videos series by Mr. Scott in SSIS (Incremental updates) that will be really very helpful.

dibyant

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.