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?
Answer Posted / abhi
most common place to check for this kind of error is services. by default sql server agent is manual start and is disabled. so we need to start the sql server agent to run the sql server jobs.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Do you know what are the differences between lost updates and uncommitted dependencies?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is a db view?
What is data source view or dsv? : sql server analysis services, ssas
Does table partitioning improve performance?
What is the difference between update lock and exclusive lock?
How do I view a stored procedure in sql server query?
What is a mixed extent?
What do you mean by SQL injection attack?
Define views.
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is a transaction and why is it important?
Explain the categories of stored procedure?
In what version of sql server were synonyms released?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?