Hi,
The requirement is I have a bunch of t-sql statements. These t-sql statements include tables from different servers and different databases. Some of them take 5 min to execute, while some take upto 30 min to execute when executed from SSMS. My question is can I put one execute SQL task in my package for each t-sql statement and schedule it as a job. Kindly reply as it is urgent.