SSIS Interview Questions and Answers Part 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