Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Help - Error Handling Expand / Collapse
Author
Message
Posted Monday, June 23, 2008 12:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 16, 2008 1:53 PM
Points: 2, Visits: 9
--------------------------------------------------------------------------------
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!
Post #521539
Posted Monday, June 23, 2008 10:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 29, 2010 5:23 AM
Points: 194, Visits: 2,357
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
Post #521986
Posted Monday, June 30, 2008 4:05 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 12, 2012 12:09 PM
Points: 57, Visits: 134
I have exactly the same issue too, let me know if you get the solution for this.
Post #526269
Posted Tuesday, February 7, 2012 10:52 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 24, 2014 3:56 AM
Points: 13, Visits: 129
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
Post #1248345
Posted Wednesday, February 8, 2012 12:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:52 PM
Points: 13,636, Visits: 11,509
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...




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1248746
Posted Wednesday, February 8, 2012 3:00 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 3:46 AM
Points: 367, Visits: 877
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
Post #1248807
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse