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
- 5434 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 is relationship? What number of sorts of relationship are there?
What is order of B+tree?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
How to retrieve field values using mssql_result()?
What is unpivot?
How to copy the tables, schema and views from one sql server to another?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Explain what is raid and what are different types of raid levels?
What are points to remember while using the fillfactor argument?
What is sqlservr.exe - process - sql server (sqlex?press)?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
Define ACID properties in a Database?
Do you know spatial data types - geometry and geography in sql server 2008?
What is bit data type?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
