Will anyone plz give me the intro about the DTS nd Sql Batch Jobs.
Thnx & Regards
(M. Nedu . .)1.Go to SQL Server Enterprise Manager
2.In desired database find Data Transformation Services
3.Find Local Packages. Right-Click and select New Package.
4.Play with different options for example you can execute some stored procedures or scripts or do multiple tasks one after another (you need some skills to make it work).
5.After work is done and saved you can right click on the package and Schedule Package to run. It will create server job for you.
I am sure it is very little help but jump into the water and swim. Your question is too broad to have definitive answer.
No comments:
Post a Comment