March 19, 2012 at 7:10 pm
hello every one,
In my latest interview i was asked by interviewer what type of errors do i get in ssis and what to do when package fails.
.
.
. I could only tell them that i had faced unicode to nonunicode conversion error while i am trying to move data from .txt file to other destinations.
I need some standard (commonly faced) errors in ssis and ways to resolve them ?
I need some real time errors
thanks.
March 20, 2012 at 12:42 am
Just read some of the forum topics here. Plenty of errors.
Don't forget to do research on how to solve those issues.
Maybe you can create a test solution in BIDS and try to reproduce the errors and see if you can fix them.
After all, it's quite useless without any actual experience.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 20, 2012 at 1:26 am
To agree and add to what Koen said.
Build a solution, and write down any error you can think of, from Data Source, Data Source View, Data Flow Source, Destination, Fuzzy Lookup, Column Split etc...
There are hundreds of issues you can encounter.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 20, 2012 at 1:55 pm
really makes sense to create things, run them, and find all the problems you will encounter over and over. Probably it would not help to recite problems that I ran into.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply