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
- 4997 Views
- Sapient, I also Faced
- E-Mail Answers
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
In what sequence sql statement is processed?
What is sql server query analyzer?
Is sql server implemented as a service or an application? : Sql server database administration
What are the benefits of normalization?
What is format parameter in ssrs?
Who developed sql server?
What are the properties of the relational tables?
What will be the maximum number of index per table?
Explain collation?
What are the authentication modes in sql server? How can it be changed?
How to convert a unicode strings to non-unicode strings?
Are resultset updatable?
What happens when converting big values to integers?
What are the hotfixes and patches in sql server?
How to test subquery results with the exists operator?
