<div>
And what is happening when you run the code?
</div>


<div>
If you're using Visual Basic, the syntax would be:<br />
<br />
Dts.Variables(&quot;User::Varia<wbr />ble_Name&quot;)<wbr />.Value<br />
<br />
Sorry.
</div>


<div>
<div class="content wysiwyg-content">
I am new to visual Basic and am having trouble getting this to work propery <br />
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$\LicensePr<wbr />od\BrokerF<wbr />eed\ and if a .xls file exists then return success else return failure &nbsp;- I am doing this script task in Microsoft visual studio 2005 <br />
<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Public Sub Main()<br />
<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim filecount As Integer<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; filecount = System.IO.Directory.GetFil<wbr />es(&quot;\\\\cu<wbr />stomer100\<wbr />c$\License<wbr />Prod\Broke<wbr />rFeed\\&quot;, &quot;*.xls&quot;).Length;<br />
&nbsp; &nbsp; &nbsp; &nbsp; <br />
<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dts.TaskResult = Dts.Results.Success<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;End Sub<br />
<br />
End Class
</div>
</div>


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

And what is happening when you run the code?

If you&#39;re using Visual Basic, the syntax would be:

Dts.Variables(&quot;User::Variable_Name&quot;).Value

Sorry.

Visual Basic Script Task Not Working Correctly

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(&quot;\\\\customer100\c$\LicenseProd\BrokerFeed\\&quot;, &quot;*.xls&quot;).Length;
        


        Dts.TaskResult = Dts.Results.Success
	End Sub

End Class

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.