October 25, 2011 at 4:57 pm
Hi,
I have a main package which will call 16 more packages.
Source for the data load is SQL Server and Target is Oracle.
My main package (which loads data from SQL server to Oracle) is scheduled to run every day at 1 AM, but it should actually start the source tables are loaded.
Source tables are loaded using SSIS using flat files. I should not add / modify the SSIS packages which are used to load source tables as they are from third party.
I am planning to start my packages once the flat files folder called as INBOX is emptied by source tables SSIS packages. So I need to look for this folder and as and when this folder empties off, my packages should trigger.
Can someone tell me how to go for this logic is SSIS?
Let me know if you want more details.
Thanks for your help.
Regards,
N
October 26, 2011 at 5:41 am
You can easily check the number of files in a directory using .NET in a script task.
Use the GetFiles() method of the DirectoryInfo class.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2011 at 9:17 am
Thanks for your reply.
I am new to this scripts, never tried it. Can you suggest an example or a link which shows working with scripts, should be basic one to understand. Thanks!
October 26, 2011 at 12:37 pm
naresh.elugala (10/26/2011)
Thanks for your reply.I am new to this scripts, never tried it. Can you suggest an example or a link which shows working with scripts, should be basic one to understand. Thanks!
You can find an example here:
http://msdn.microsoft.com/en-us/library/ms143327.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply