I am very new to SSIS Packages. I have some requirement that I want to upload data from 1 table regularly to another database over internet. If anything goes wrong it should send mail with error code. Can somebody guide me to do that.

Hello, Please go through the following links.... http://www.mssqltips.com/tutorial.asp?tutorial=208 Once you done with creating a new package, you need data flow task, in Data flow task you need to use OLE DB Source , and then configure connection manger to your source. There are other transformation you can use according to your requirement before you insert data into your destination. When you say you want to load data over internet? What does mean ? Do you have another server and you have created link server or ......? there is Error Handler Table , you will see, Click on that and then select the level on which you want to send error message . Select the level like Package or transformation and then select event e.g ONERROR You can drag different transformations according to your requirement. You can send an eamil by using SEND EMAIL Task , you can write some information by using EXECUTE SQL TASK and anything you would like to do if error occured during the package execution. http://technet.microsoft.com/en-us/library/ms139744(SQL.90).aspx Pleaes do search on google, you will find video tutorials and blog post related with each of the component you have in ssis. Good luck. Thanks