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?
Answers were Sorted based on User's Feedback
Answer / saaron
When you deploy SSIS packages to run from SQL Agent jobs;
you have to specify the Configurations file which should
contain the essential details for executing the package
such as 'Connection Managers', 'Variables', Sources and
Destinations defined and others as per the developed
packages. Also, the underlying tables need to be
subsequently taken care to match the refreshed metadata
from the mappings in the DFT in the package.
This is an open-ended question and you must be prepared to
talk a bit more about the troubleshooting involved in SSIS
Package development and deployment.
All the best,
Hope this helped,
Regards,
SaaroN
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
What is the most common trace flags used with sql server?
Explain transaction isolation levels in sql server?
How to change the system date and time from SQL Plus Terminal ?
Detail about the hardware which is supported by SQL server?
What is purpose of normalization?
What is a primary key?
How to test a dml trigger in ms sql server?
What is the new security features added in sql server 2016? : sql server security
What are the five major components of a dbms?
Do you know spatial data types - geometry and geography in sql server 2008?
In what sequence sql statement is processed?
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply