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
- 5600 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 are views in ms sql server?
What is the function of inner join?
what is checksum in sql server.........???
What are the hotfixes and patches in sql server?
In which files does sql server actually store data?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
How to change parameter value inside the report?
How to list all objects in a given schema?
What is the command used to recompile the stored procedure at run time?
How do you create a data source?
What the class forname () does?
How to verify a user name with sqlcmd tool?
What is set nocount on?
optimization techinques
Do you know what are various aggregate functions that are available?
