I hope this blog may help for the people who are looking for real time examples and will continue to update this blog with nice examples !!!!!!
1)Design a package to move the flat file data to table and check the following condition's using script task with having the file-name in a variable before the data flow task run.
a)Check the file is exist or not in the location.
b)Check the file is empty or not.
c)Check the file created date is current date or not.
Task Required : Script Task,Data Flow Task (Precedence Constraint with expression btw Script Task and Data Flow Task)
2)Design a package to find the latest file in the folder ,considering with seconds in time.
Tasks Required: Script Task
3)Loop over list of files and load each one from the folder by following the given conditions in the first point.
a)Move the empty files to any new folder and processed files to archive folder.
1)Design a package to move the flat file data to table and check the following condition's using script task with having the file-name in a variable before the data flow task run.
a)Check the file is exist or not in the location.
b)Check the file is empty or not.
c)Check the file created date is current date or not.
Task Required : Script Task,Data Flow Task (Precedence Constraint with expression btw Script Task and Data Flow Task)
2)Design a package to find the latest file in the folder ,considering with seconds in time.
Tasks Required: Script Task
3)Loop over list of files and load each one from the folder by following the given conditions in the first point.
a)Move the empty files to any new folder and processed files to archive folder.
Tasks Required: Foreach Loop, Data Flow Task ,Script Component
