Related InterviewSolutions

• What will you do if a package runs fine in BIDS but fails while running from the SQL agent job?
• How will you add a recordset variable inside Script Task?
• How do you store SQL passwords? Does the SSIS connection manager of the package store SQL password?
• Explain the importance of config files in SSIS.
• What is SSIS event logging property?
• What are the components that would be used to send data from the access database to the SQL database on the off chance?
• What is SSIS breakpoint?
• Is it possible to schedule packages for a specific time period of a day?
• Is it possible to log SSIS execution?
• How many lookup cache modes are present in SSIS?