converting vbscript to vb.net

How would I convert the following code to vb.net? Thanks...


'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************

Function Main()

Dim objFSO, objFolder, colFiles, strFilesExists


DTSGlobalVariables("ImportDirectoryPath").Value = DTSGlobalVariables("FileLocation").Value



SET objFSO = CreateObject("Scripting.FileSystemObject")
SET objFolder = objFSO.GetFolder(DTSGlobalVariables("FileLocation").Value)
SET colFiles = objFolder.Files


strFilesExists = "NO"

If colFiles.Count > 0 Then
For Each objFile In colFiles
'Look to see if files exists
IF UCASE(Left(objFile.Name, 3)) = "RCC" THEN

'If atleast one exists move on
DTSGlobalVariables("FileName").Value = objFile.Name
DTSGlobalVariables("FileCreateDate").Value = Mid( DTSGlobalVariables("FileName").Value , 4 , 10 )
DTSGlobalVariables("ConnectionString").Value =DTSGlobalVariables("FileLocation").Value + "" + objFile.Name
strFilesExists = "YES"

Exit For
END IF
Next
End IF

If strFilesExists = "NO" Then
Main = DTSTaskExecResult_Failure
Else
Main = DTSTaskExecResult_Success
End if



End Function

I think with visual studio .net, there is a vb to .net code coversion utility.
Still i feel you will be creating SSIS package for this and there is still option to execute vbscript and also to import visualbasic libraries.

Considering the lines of code, i guess you are better off writing this in .net script on your own instead of running it as vbscipt in SSIS.

Thanks for the fast reply, ranjitjain. Would you know where this tool is in the Microsoft Visual Studio for Applications environment that ships with SQL Server 2005? Or will I have to use visual studio.net?

Hi,
In SSIS you can also add your existing vbscript as activex script task and then select the script language.
Also long time back i had imported my vb code into .net
but i dont remember how i did it

Hi,
I found that option even under visual studio 2005.
Open Visual studio,
click on Open and then you will find convert option.
Click on convert and then use vb upgrade wizard