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
- 5554 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 to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Explain features of analysis services?
How we can compare two database data?
What is extended stored procedures?
How to create indexed view?
What is ms sql server triggers?
What are the differences between local and global temporary tables?
Explain SSRS Architecture?
How many databases can we create in a single server?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What are the difference between primary keys and foreign keys?
Define self join in sql server joins?
What is used to replicate sessions between instances in coldfusion clusters?
What new changes are being made in SQL Server?
How to convert a numeric expression from one data type to another?
