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

How and why use sql server?

1004

---

last function used in MS Access to convert sql what function will use in sql

2070

---

How many triggers are possible per table?

1096

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1083

---

What do you understand by recursive stored procedures?

986

---

what is the difference between delete table and truncate table commands? : Sql server database administration

1032

---

Explain how many types of relationship?

1020

---

how can you attach more than 20 ldf files in sql server

1996

---

Name some of the open source software that you can use in alternative to SSR?

161

---

What do you understand by triggers?

922

---

What samples and sample databases are provided by microsoft?

1037

---

What is efficiency data?

950

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2023

---

What is acid mean in sql server?

1113

---

What is a transaction and why is it important?

1086

---