Prev | Current Page 61 | Next

Jayaram Krishnaswamy

"Beginners Guide to SQL Server Integration Services Using Visual Studio 2005"

Also
notice that the red dot with white cross has disappeared and a Connection
Manager has been added to the Connection Managers' collection.
Chapter 3
[ 83 ]
12. Click on the Package Explorer and verify that the My Email Task and
the Connection Manager are included in the package.
13. Now click on the Build menu item and click on Build Ch 3.
You get a Build Succeeded message at the bottom-left of the screen.
14. Right-click the Email.dtsx in the Solution Explorer and click on the Execute
Package drop-down menu item.
The program starts to run; the Send Mail Task (in the Control Flow page)
first turns yellow and finally is filled with green color. Green is for success
and red indicates failure. If want to return to the design mode, you should go
to the menu item Debug and choose Stop Debugging from the drop-down
menu.
15. Now, it is time to go to your email client program, such as Outlook Express
or a similar program, to verify if the email message has left (browse the sent
messages) or you may also use a web mail program such as Google or
Yahoo, etc.
It may be noted that the Send Mail Task will not check if the account is correct.
Also, you will be indicating whether or not you are using Windows
authentication. Since the package is developed by the owner of the computer,
the authentication was left blank. Even if this mode of authentication was
implemented, the result would still be the same because the administrator of
the computer created the package object.


Pages:
49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73
Liberty X Drukarnia Miami Sound Machine Mercyful Fate Angela McCluskey