DotNetShoutout - Stories tagged with Script Task

Script Task

atom rss
6
Shouts
spam Shout it Mute it

SSIS - Reading object variable in Script task - Sudeep's Domain
posted by http://rajsudeep.blogspot.com/http://rajsudeep.blogspot.com/ 715 days, 7 hours, 37 minutes ago
Thursday, June 09, 2011 6:12:34 PM GMT
SSIS - Reading object variable in Script task. To know how read on. (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: MSBI, object variable, SSIS, Script Task
5
Shouts
spam Shout it Mute it

SSIS - Managing Control Flow based on the input file name - Sudeep's Domain
posted by http://rajsudeep.blogspot.com/http://rajsudeep.blogspot.com/ 995 days, 11 hours, 3 minutes ago
Thursday, September 02, 2010 2:45:46 PM GMT
Many times during ETL we have a requirement where based on the file name we have to perform certain operations. Normally within a For Each Loop with File enumerator in Control Flow Task there is no direct way of doing this. If the file mask matches, well and good but nothing beyond that. I demonstrate this with a scenario: We have a lot of files in a folder and there is no specific file mask that you can be applied apart from *.txt. So you need to pick up all the files from the folder matching the above... (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: SQL Server, For Each loop, MSBI, Control Flow, SSIS, Script Task, Precedence Constraint