SSIS Help - Error Handling

Question

SSIS Help - Error Handling

gready20

SSC Journeyman

Points: 80
More actions
June 23, 2008 at 12:11 am

#208732

--------------------------------------------------------------------------------
I am new to SSIS . Can somebody please help with the following
1. I need to pass the file name to my SSIS pacakage as a parameter
2. In the destination Table have the following columns. I must add the data from the flat file to my destination table and for each row i have to insert the flatfile name to column 'filename' to know the flat file source from which the data has come.
a. Account number
b. Name
c Amount
d.filename
3. The rows that have bad data must be redirected to a text file with appropriate column name and error and warning, discription and messsages.
4. Must create a log file for each time the ssis package is executed (the information must be similar to the detiails shown in the Progress tab
Please provide illustration so that i can undertand better
Thanks in Advance!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Andrew Gothard-467944 Hall of Fame Points: 3928 More actions · Answer 1

Hi,

for the logging of individual rows containing errors, in your data transformation task use an OLE DB Destination Error Output connection (red arrow) from the destination for the valid input to the destination for invalid input.

For logging the progress of the package, go to the menubar at the top, select SSIS - Logging, and you can configure logging to a destination set up in your package such as a database or a text file

hth

hadush1 SSC Enthusiast Points: 163 More actions · Answer 2

I have exactly the same issue too, let me know if you get the solution for this.

nakkeeran.kannan Mr or Mrs. 500 Points: 503 More actions · Answer 3

I have updated Error Handling in SSIS in the following blog . Please let me know if you find it useful.

http://www.nkannan.com/2012/02/error-handling-in-ssis-dft.html

Thanks,

Nk

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

nakkeeran.kannan (2/7/2012)
I have updated Error Handling in SSIS in the following blog . Please let me know if you find it useful.
http://www.nkannan.com/2012/02/error-handling-in-ssis-dft.html
Thanks,
Nk

I sure hope they solved their error handling problem 4 years ago...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Lowfar Ten Centuries Points: 1005 More actions · Answer 5

In response to your 2nd question.

"2. In the destination Table have the following columns. I must add the data from the flat file to my destination table and for each row i have to insert the flatfile name to column 'filename' to know the flat file source from which the data has come."

Have a look at using a variable to store your file name, you can then add this into your DataFlow by using the [Derived Column] Task. This will add the filename into the pipeline and will alow you to insert this information into your destination.

Cheers

-Matt