SSIS Interview Questions and Answers Part 6

SSIS_InterviewQuestions_6

SSIS – Part 6

SSIS Interview Questions and Answers for Experienced and Fresher’s

SSIS – Links to SSIS questions

SSIS Interview Questions and Answers  Part 6

We usually do go through various blogs and community forums as a part of analysis and problem solving. Here with we are posting little informative stuff from various blogs.

Q. SSIS slowdown issue

Ans:
​​ http://stackoverflow.com/questions/2678119/is-there-a-reason-why-ssis-significantly-slows-down-after-a-few-minutes

Q. Issues with SSIS service in cluster environment.

Ans:

http://www.mytechmantra.com/forums/index.php?topic=22.0

Q. How to handle date columns in flat file while loading?

Ans:

http://social.technet.microsoft.com/wiki/contents/articles/18943.ssis-flat-file-source-datetime-column-format-issue-solution.aspx

​Q. Common requirements and solutions in SSIS?

Ans:
​​ http://ssisjunkie.blogspot.com/2012/09/common-ssis-problems-and-solutions-we.html

Q. how to attach configuration files to SSIS packages?

Ans:
http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server-2012-part-1-of-2/
http://sqlscape.wordpress.com/2010/06/29/deploying-ssis-packages-with-xml-configurations/

Q. Have you ever tried logging in SSIS? What are the tables on which log information stored? Can we enable logging for only selected items from SSIS package? if yes how?

Ans:

http://stackoverflow.com/questions/15004109/can-you-monitor-the-execution-of-an-ssis-package-in-bids-as-it-runs-on-the-ser

Q. How to load a list of files from a folder to sql server using ssis?

Ans:

​Explain how to load a list of files from a specific folder to sql server

http://simonlv.blogspot.in/2012/06/ssis-step-by-step-003-load-multiple.html

Q. Design a package to load .xlsx files from a folder. File names must include either “Finance_” or “Local_” and load files only from the last week.

​Ans:

http://stackoverflow.com/questions/8360117/loading-last-7-days-files-with-specific-names-in-ssis

http://www.mssqltips.com/sqlservertip/2874/loop-through-flat-files-in-sql-server-integration-services/

http://stackoverflow.com/questions/8831060/import-most-recent-csv-file-to-sql-server-in-ssis

 

Q. How to capture column name and row number when something failed in dataflow?

Ans:

http://informatics.northwestern.edu/blog/edw/2012/01/etl-assistant-getting-error-row-description-and-column-dynamically/

http://blogs.msdn.com/b/helloworld/archive/2008/08/01/how-to-find-out-which-column-caused-ssis-to-fail.aspx

Q. How to schedule a job in SQL agent to execute SSIS package?
Ans:
http://www.codeproject.com/Articles/14401/How-to-Schedule-and-Run-a-SSIS-package-DTS-Job-in

Q. What are the common problems in SSIS?

Ans:
http://www.rodcolledge.com/rod_colledge/2010/02/fun-with-ssis-part-1-troubleshooting.html

Q. Demonstrate SSIS Solutions for requirements?
Ans:
http://ssisjunkie.blogspot.in/2012/09/common-ssis-problems-and-solutions-we.html

Q. How to create a template for SSIS packages
Ans:
http://www.mssqltips.com/sqlservertip/2841/creating-ssis-package-templates-for-reusability/

Q. SQL Server Integration Services (SSIS) Top 10 best practices:
Ans:

http://sqlcat.com/sqlcat/b/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx
http://sqlmag.com/sql-server-integration-services/designing-ssis-packages-high-performance

Q. What are the SSIS performance issues and possible solutions?

Ans:
http://consultingblogs.emc.com/jamiethomson/archive/2007/12/18/SSIS_3A00_-A-performance-tuning-success-story.aspx
http://www.mssqltips.com/sqlservertip/1867/sql-server-integration-services-ssis-performance-best-practices/
http://stackoverflow.com/questions/2678119/is-there-a-reason-why-ssis-significantly-slows-down-after-a-few-minutes
http://stackoverflow.com/questions/1093021/tracking-down-data-load-performance-issues-in-ssis-package

Q. How to import multiple test files from a folder?

Ans:

http://codejotter.wordpress.com/2010/04/06/importing-multiple-text-files-using-ssis/
http://simonlv.blogspot.in/2012/06/ssis-step-by-step-003-load-multiple.html

​Q. How to speed up the bulk insert in SSIS?
Ans:
http://henkvandervalk.com/speeding-up-ssis-bulk-inserts-into-sql-server

Q. How to use profiler to capture the trace from SSIS?
Ans:
http://henkvandervalk.com/speeding-up-reading-from-a-sql-ole-db-or-ado-net-data-source

Q. What is the fast parse option?
Ans:
http://msdn.microsoft.com/en-us/library/ms139833.aspx

​​

References:

For more MSBI stuff please have a look at below references:

http://blogs.msdn.com/b/business-intelligence

https://sreenivasmsbi.wordpress.com

http://www.msbiguide.com

http://msbiravindranathreddy.blogspot.in

http://sqlschool.com/MSBI-Interview-Questions.html

https://www.katieandemil.com

http://www.venkateswarlu.co.in

http://www.sqlserverquest.com

http://www.msbiguide.com

 

SSIS Interview Questions and Answers  Part 6

Posted in Interview Q&A, MSBI, SSIS | Tagged , , , , , , , , , , , , , , , | 5 Comments
Subscribe
Notify of
guest
5 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Murthy M.N
Murthy M.N
8 years ago

Hi Uday,

Thank you for Sharing A Good Stuff,Very Help full

chinmayesri
chinmayesri
7 years ago

nice post thank you!

Madison Quinn
6 years ago

Hello, you have shared good stuff helps us a lot. While am prepping for interview I have got some detailed technical questions over TekSlate.com