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
- 4992 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
What do you understand by triggers and mention the different types of it?
Explain trigger and trigger types?
What is difference between commit and rollback when used in transactions?
How many null values we can have in a unique key field in sql server?
What is query parameter in ssrs?
Does sql server use java?
If a stored procedure is taking a table data type, how it looks?
What is the sql case statement used for?
Can we hide the definition of a stored procedure from a use?
Write SQL queries on Self Join and Inner Join.
How to provide login information for a new odbc dsn?
Why do we need normalization?
List out a number of the wants to setup a SQL Server failover cluster?
how to trace the traffic hitting a sql server? : Sql server database administration
What is a view in sql?
