We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SSIS Package Data Load Issue

SeTech
SeTech asked
on
Medium Priority
357 Views
Last Modified: 2013-11-10
I have a data load from a csv file to a database via an SSIS package. When I run the package it fails. My question is that on the Control Flow panel the data source is green (i.e. success) and the data destination is red (i.e. failure). Then on the data flow page the data souce and data destination boxes are both yellow (i.e. in process). Additionally on the data flow page the next to the detination arrow it reports a number that must be the number of rows that have flowed from the source to destination. So to me it must mean that the next row is where the error occurs? Specifically I am trying to load 1450 records and the data flow page shows the number of 748. Unfortunatalty when I check the data I can not find any issues with row 748 and for that matter any row.
Any ideas?
Comment
Watch Question

No It is not. SSIS Package will load your data in batches (For Ex: 600 records per sec) and that too in a transaction. You can't predict the error record in this way.

Enable Error data redirect, so that it will redirect your error records to another destination (Like a flat file) and loaded the good records.

Enable logging in your package and write the info to your log file.

http://msdn.microsoft.com/en-us/library/ms141679.aspx
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Jason YousefSr. BI  Developer

Commented:
Hello,

As @radcaesar said it process in batches. Also steps to redirect error rows are mentioned here

http://msdn.microsoft.com/en-us/library/ms166707.aspx


Loot at the "Progress" tab and the problem row will be mentioned, just copy the error lines because you can't see all of it on the screen and paste it in a notepad and you'll find the row number.


Hope that helps.
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
If Arrow in between both boxes shows 748 Records Text then there is a problem in 749. Please check the output/error in Preocess Tab besides Package Explorer.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.