469,946 Members | 2,012 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

SSIS Extract fails without much error.

Hi All,
I am a beginner with SSIS. Here I am with a simple extract mapping which extracts data from database (quite a few small tables and 3 big table @ 5million reacords each) simultaneously and puts into staging area. Both source and target database are on SQL server 2005 on Windows XP machine.
Making extract sequential is an option but we do not want to go in that direction.

This mapping seems to be working fine most of the times. Problem is, this mapping fails without much information about error sometimes. And when it is rerun (automatically by scheduled job in SQLAgent to execute again in case of failure), it runs succesfully. Failure is quite random.

Can anyone please guide me, how I can debug this problem?
Please let me know if any more details are required.
Sep 11 '07 #1
0 841

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Eric | last post: by
3 posts views Thread by =?Utf-8?B?TWljaGFlbA==?= | last post: by
reply views Thread by Neff | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.