Browse by Tags

• Expressions
• File Properties Task
• SSIS

• Setting Variables in the Script Task in SSIS

  One of the key reasons that you use the script task is to change the value of a variable at runtime. There is a lot of real-world scenarios that you would use this for. If you're reading this you have already probably thought of a few. To set a variable... Posted Nov 28 2008, 08:40 PM by Brian Knight with | with 1 comment(s) Filed under: SSIS, scripting

• Detecting if a File is in Use in a SSIS Script Task

  When mainframes or partners are uploading a file, you don't want to process the file until you're certain the file is fully uploaded. One way to do this is with a Script Task in SSIS. There is no magic property to determine in the operating system... Posted Oct 15 2008, 09:26 AM by Brian Knight with | with no comments Filed under: SSIS, Expressions, File Properties Task, scripting