I am new to visual Basic and am having trouble getting this to work propery
All I am trying to do is check to sse if an excel file with the extension .xls exists at this path here \\customer100\c$\LicenseProd\BrokerFeed\ and if a .xls file exists then return success else return failure - I am doing this script task in Microsoft visual studio 2005
Public Sub Main()
Dim filecount As Integer
filecount = System.IO.Directory.GetFiles("\\\\customer100\c$\LicenseProd\BrokerFeed\\", "*.xls").Length;
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
Our community of experts have been thoroughly vetted for their expertise and industry experience.