March 14, 2011 at 10:23 pm
Hi,
i have requirement i need to load the flat file data in to DW.
before loading i need to check whether flat file has got data or not.
is there any option so that i can check out the file size before loading it?
March 15, 2011 at 1:04 am
You can use a script task. Inside the script task, use the FileInfo class. It will contain the information that you need.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2011 at 2:07 am
koen,thanks it was a great help!
but i am bit confused now like which file class i need to use in script component is it FILEGET or FILEGETOBJECT.
March 15, 2011 at 2:16 am
I would use the script task rather than the script component.
The FileInfo class should be sufficient:
http://msdn.microsoft.com/en-us/library/system.io.fileinfo.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2011 at 2:23 am
Koen,
got it:cool:
Thanks for the great support!
March 15, 2011 at 2:27 am
subramani.rudrappa 78855 (3/15/2011)
Thanks for the great support!
No problem, glad to help.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply