When the package is executed, you will come up with a execution progress bar; barring errors, you will get a success in the status window as shown. As shown previously you will also see a similar message in the Event Log as well as the error file you created earlier (both of them are not shown here).
It is relatively easy to declare and assign values to global variables in the definition of the package. It is also possible to assign and declare in the Execute SQL Task while specifying the parameters. In this tutorial, the global variables were defined in the definition of the package and later associated with the parameters of parameterized queries. It may be noted that, although datetime is the SQL data type, the drop-down in the global variables window of the package is just date.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 13 
