What will you do if a package runs fine in BIDS but fails while runnin

1.	What will you do if a package runs fine in BIDS but fails while running from the SQL agent job?
Answer» A PACKAGE that runs SUCCESSFULLY in BIDS and fails from the SQL agent job can mean that the SQL Agent jobs do not have the necessary permission for some connections of the package. We can either create a proxy account that allows SQL Agent jobs to run the package or elevate the current account permissions. Conclusion: SSIS is a PLATFORM for integration services that provide automated tasks and various transformation components for cleaning, transforming, and validating data throughout the process of data loading from source to DESTINATION. In this article, we have seen what are the most commonly asked SSIS interview questions and the answers to them. References and Resources: SSIS Documentation Database SQL Interview Guide

What will you do if a package runs fine in BIDS but fails while running from the SQL agent job?

Answer»

A PACKAGE that runs SUCCESSFULLY in BIDS and fails from the SQL agent job can mean that the SQL Agent jobs do not have the necessary permission for some connections of the package. We can either create a proxy account that allows SQL Agent jobs to run the package or elevate the current account permissions.

Conclusion:

SSIS is a PLATFORM for integration services that provide automated tasks and various transformation components for cleaning, transforming, and validating data throughout the process of data loading from source to DESTINATION. In this article, we have seen what are the most commonly asked SSIS interview questions and the answers to them.

References and Resources:

SSIS Documentation

Database

SQL Interview Guide

Discussion

No Comment Found

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?