Interested to Buy Any Domain ? << Click Here >> for more details...
A successfully created SSIS package in SQL Server 2005 runs
fine in MS BIDS and Integration Services. But gives error
when run through an SQL-Job. What are the possible reasons?
- 2 Answers
- 5603 Views
- Sapient, I also Faced
- E-Mail Answers
Answer Posted / saaron
When you deploy SSIS packages to run from SQL Agent jobs;
you have to specify the Configurations file which should
contain the essential details for executing the package
such as 'Connection Managers', 'Variables', Sources and
Destinations defined and others as per the developed
packages. Also, the underlying tables need to be
subsequently taken care to match the refreshed metadata
from the mappings in the DFT in the package.
This is an open-ended question and you must be prepared to
talk a bit more about the troubleshooting involved in SSIS
Package development and deployment.
All the best,
Hope this helped,
Regards,
SaaroN
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the current pricing model of SQL Azure?
Does sql server 2016 have ssms?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What are basics of policy management?
How to recreate an existing index in ms sql server?
How do I find the default sql server instance?
How does index makes search faster?
How to verify the port number of the sql server?
What is a non clustered primary key?
Is mysql better than sql server?
What do you understand by the denormalisation?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is a constant or literal in ms sql server?
How can I check if a view exists in a sql server database?
What is check constraint in sql server?
