TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Anand MR
NA
39
20k
How to get Flat File Error column Name in SSIS Packages
Jun 11 2015 12:06 AM
Hi Friends,
I am using CSV file for uploading data into database.I use Data Conversion control in DataFlow task.If conversion failed i can able to get the error code only. I am not able to get the Error Column name.
I tried the below article to get the error column name. In Step 4. need to add derived column (
The value of this column will be the name of Data Flow it is in.)
here i didn't get the point..How to set the derived column value to name of Data Flow task..
http://sqlage.blogspot.in/2013/12/ssis-how-to-get-error-column-name-in.html
Please anyone help me to get the error column name.If you have any source code please attache for me...
Very urgent...
Thanks
Reply
Answers (
0
)
Count each character occurrence in a given string
Gridview