Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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?

Question Posted / manoj pandey

Answers were Sorted based on User's Feedback



A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Servic..

Answer / 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

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Servic..

Answer / abhi

most common place to check for this kind of error is services. by default sql server agent is manual start and is disabled. so we need to start the sql server agent to run the sql server jobs.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL Server Interview Questions

Can you type more than one query in the query editor screen at the same time?

0 Answers  

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

0 Answers  

What is mean by "fill factor" ? and what is mean by "Index "in sql?

1 Answers   iGate, Logica CMG,

Why I am getting this error when renaming a database in ms sql server?

0 Answers  

what are the types of indexes? : Sql server database administration

0 Answers  

How do I change my passwords (database, LDAP, and so on) without causing an outage?

0 Answers   IBM,

What is the difference between indexing and hashing?

0 Answers  

What are the types of constraints?

1 Answers  

How to get @@error and @@rowcount at the same time?

0 Answers  

two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

For more SQL Server Interview Questions Click Here
Categories