forum.venkateswarlu.net
      Register      Login
hai

3 replies to this topic

Soujanya Chava #1
Member
32 Points
 Posted on 16 Apr 2012 07:58 PM IST hai i need interview questions of SSIS can you provide me those.. 
SSIS     903 views     Reply to this topic
Harikrishna Sikhakolli #2
Member
108 Points
 Replied on 19 Apr 2012 08:54 AM IST Interview Questions on ssis
1.what is the difference between sql server configuration and xmlconfiguration which one is best?
2.How to debug the controlflow?
3.what is the use of checkpoints?
4.what is the default logprovider?
5.what is the different logproviders available in ssis?
6.we can do each and every thing with the help of stored procedure why we go for ssis?
7.In howmany ways we can execute a pkg?
8.what is the use of configuration in ssis?
9.In flat file 10 rows are there how can we delete top 5 rows?
10.what is the errormsg in ssis?
11.In flat file data is in double Quotes and how can we eliminate the double quotes from the text file?
12.what is the default transaction type?
13.what are the different security modes available in ssis?
14.what is the job scheduling?
15.what are the different types of dataviewers?
16.what are the break points?
17.In howmany ways can we create ssis pkg?
18.what are the evernt handlers and some types of events?
19.what is the difference between script component and scripttask?
20.In dataflow which transformation is used to remove duplicate data from the table?
21.what is the scd?
22.what is the pivot transformation?
23.what is the differnce between fuzzylookup and fuzzy grouping?
24.what are different types of precedence constraints?
25.Error handling in dataflow?
I HOPE THESE QUESTIONS ARE HELPFUL TO YOU
S.HARIKRISHNA.


 
Reply to this topic
Soujanya Chava #3
Member
32 Points
 Replied on 19 Apr 2012 04:33 PM IST Thank Q so much Hari Krishna.! 
Reply to this topic
Jahnavi N #4
Member
164 Points
 Replied on 20 Apr 2012 08:31 AM IST Hi Harishna,

Thanks for providing SSIS faq.
Please try to provide answers also for this question.

Thanks 
Reply to this topic