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

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

How to check if stored procedure is running in sql server?

0 Answers  

plz send every query in sql server2000

1 Answers   Infosys,

What is blocking?

0 Answers  

What are the types of database schema? : sql server analysis services, ssas

0 Answers  

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

What is difference between order by and group by?

0 Answers  

Explain about service Broker functions?

0 Answers  

What is a covering index?

0 Answers  

Why are you getting errors when creating a new odbc dsn?

0 Answers  

What is precedence constraint?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories