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
- 5707 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
What is the difference function and stored procedure?
What is side by side migration in sql server?
What do you understand by SQL*Net?
Define union, union all, minus, intersect?
How to choose all records from the table?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
how to create a scrollable cursor with the scroll option? : Sql server database administration
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
how you can get the list of largest tables in a database? : Sql server administration
Why the trigger fires multiple times in single login?
Explain the usage of floor function in sql server.
when would you go for denormalization? : Sql server database administration
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What do you understand by a view? What does the with check option clause for a view do?
Is sql server a database?
