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
- 4588 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 Transparent Data Encryption?
What is the difference between row_number and dense_rank?
What are audit control procedures?
Does full backup break log chain?
Explain unique key in sql server?
What is partition, how will you implement it? : sql server analysis services, ssas
How do I setup a local sql server database?
What are the advantages of user defined function?
In what version of sql server were synonyms released?
what are candidate key, alternate key and composite key? : Sql server database administration
When a primary key constraint is included in a table, what other constraints does this imply?
Explain sql server service broker?
plss anybody specify tha constrian management system in dbms
Give a example to search fr a string in all stored procedure in sql server.
What are advantages of ssrs or why we should use ssrs?
