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
- 5708 Views
- Sapient, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How ssrs maintain security?
what is a transaction and what are acid properties? : Sql server database administration
What is dknf in normalization form?
can SSRS reports Cache results?
What happens on checkpoint?
What are the different Topologies in which Replication can be configured?
Will count(column) include columns with null values in its count?
What are the purposes and advantages stored procedure?
What is the purpose of floor function?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
Do you know what are the differences between lost updates and uncommitted dependencies?
What is triggers and its types?
How do you create a clustered index?
Difference between Inner vs outer joins?
How to connect to a sql server using odbc_connect()?
