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 / 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 transfer data from a cursor to variables with a "fetch" statement?
List some case manipulation functions in sql?
What are the purpose of Normalisation?
How to transfer a table from one schema to another?
How does index makes search faster?
What do you understand by replication in sql server?
What language is sql server written in?
What is tempdb database? : SQL Server Architecture
Is null vs coalesce?
How to list all user defined functions in the current database?
Why use view instead of a table?
Do you know what are the reporting services components?
How to link tables in sql server?
What are subquery and its properties?
Explain different forms of normalization?