How to get started with this as i would like to implement this in my project.....................can anyone help me regarding this??? Help me out with your ideas. Thanks Sandyz

You can apply Notification Framework from BIDS using BIxPress Addin or Using Standalone Application from Start Menu > BI xPress To apply Notification Framework to existing packages .. Perform the following steps 1. launch BIxPress from Start Menu 2. Click on Notification Framework Option 3. Select "Add" option on the first screen of wizard 4. Specify Alerts Types , Config File Location ... Hit Next and Specify SMTP Settings if you selected Email/SMS Method 5. Hit Next and Click Start to Modify Packages. All settings of Notification framework are stored in external config file by default which includes (To,CC,Bcc,SMTP Settings, Notification Methods, Email Template Location etc ...) http://pragmaticworks.com/help/bixpress/scr/Notification%20Framework%20Wizard.htm SSIS Video Tutorial - Configure SSIS packages to send email, SMS, EventLog Alerts SSIS-Tutorials-FAQs | Convert DTS to SSIS | Document SSIS | SSIS Tasks | Real-time SSIS Monitoring

Test email was sent succesfully but throwing an error for sms alert notification Help me regadring this error...

Hmm, that is interesting. Have you tried entering in the full user name (including domain) for the e-mail address you are attempting to connect to? For example, enter in 'sandhya.kacham@domain.com' where domain.com' is your company's domain that they use. The only reason I'm thinking that might be the issue is due to the error being thrown talks about the domain not being in the list of allowed rcpthosts. since the domain isn't listed, that could possibly be resolved by simply declaring the domain in the user name.

Read all the way bottom on the below link. http://www.bidn.com/forums/microsoft-business-intelligence/integration-services/929/sms-notification#3681 To me it looks like SMTP Configuration issue... It could be Relay Issue on SMTP Server or Some setting which prevents you to send email using SMTP Server. You have to contact your System admin and ask about How to configure SMTP Settings. Below is the simple VB Script to test SMTP Settings Dim objMessage ,strTo,strSmtp,strFrom strFrom=InputBox("Enter [From] email address",,"alerts@mycompany.com") strTo=InputBox("Enter [To] email address",,"xxxxx@mycompany.com") Set objMessage = CreateObject("CDO.Message") objMessage.Subject = "Example CDO Message" objMessage.From = strFrom objMessage.To = strTo 'objMessage.Cc = strTo 'objMessage.Bcc = strTo objMessage.TextBody = "This is some sample message text." strSmtp=InputBox("Enter SMTP server name or IP (i.e. mail.bellsouth.com)",,"localhost") if strSmtp<>"localhost" then '==This section provides the configuration information for the remote SMTP server. '==Normally you will only change the server name or IP. 'objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'Name or IP of Remote SMTP Server objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = strSmtp 'Server port (typically 25) 'objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 ''//If SMTP requires authentication then use below lines 'objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 'objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "username@abc.com" 'objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "mypassword" objMessage.Configuration.Fields.Update '==End remote SMTP server configuration section== end if '//Uncommnet the following lines to test email with attachments '//objMessage.AddAttachment "c:\test1.txt" '//objMessage.AddAttachment "c:\test2.txt" objMessage.Send Msgbox "Message sent to " & strTo SSIS-Tutorials-FAQs | Convert DTS to SSIS | Document SSIS | SSIS Tasks | Real-time SSIS Monitoring

Hi Nayan, thanks for the reply. Am able to send email successfully but failed in sending sms alert notification using BI X press Notification services can anyone help me regarding this.Do i need any connectivity??How it is possible using BI Xpress Notification services. Please Reply me with all the possibilities. Thanks Sandy