SSIS - Variables In Detail

With the basics of variables discussed from our previous video we can now give you an example of how this all fits together. This video will show you how to use system and user variable to produce error text for an email. This code is completley dynamics and allows the package to automatically send the reciepent not only the error but specific details on what errored and where! Just one of the fantastic things you can do with variables.

Treat this video as your starting point in scripting with variables and hopefully will get your creative juices flowing!

To get the file shown in this video please goto http://PCTeach.me and register, its free and will give you access to the majority of documents discussed in these videos.

Category:

Education

Tags:

• BI
• Business Intelligence
• Package
• Scope
• SSIS
• Variables
• Training
• teach
• BIDS
• variables
• system variables
• system variable
• system
• User variables
• user
• user variable
• tutorial
• training
• demo
• teach me
• howto
• how to
• tips & tricks
• SQL
• SQL server
• Microsoft SQL
• Microsoft SQL Server
• technology
• tips and tricks
• tips
• instructions
• database
• data
• Software Tutorial
• Information

[prettygirldata]

Thank you so much for sharing your knowledge!  Very helpful and you are excellent at explaining!

[PCTeachME]

@prettygirldata Your most welcome!

[wilwoap]

Te agradezco por este video, me evitaste 5 dias de investigacion, eso es justo lo que necesitaba,

thanks for your help..

Gracias desde Quito- Ecuador

[PCTeachME]

@wilwoap ¡Usted es el más agradable! Gracias por sus comentarios. (apesadumbrado para la mala traducción)

[BludJuice]

Excellent SSIS tutorials. Please do more! Very helpful!

[PCTeachME]

Thanks

[434apt]

thank you..