Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
0
Answer
How to get Flat File Error column Name in SSIS Packages
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Anand MR
9y
672
1
Reply
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
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
Count each character occurrence in a given string
searching in mvc