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
How to connect sql server management studio express to sql server 2005 express?
How many types of database relationship in sql server?
If a table does not have a unique index, can a cursor be opened on it?
What is an index. What are the types?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How to update multiple rows with one update statement in ms sql server?
How to convert numeric expression data types by assignment operations?
What is the difference function and stored procedure?
How many types of functions are there in sql server?
What is the sql server agent?
What is data set in report?
Working with TLogs
whats the maximum size of view state??
What is transact-sql ddl trigger?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?