| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| Hi I have the code below in a dts package to read any file from a particular directory - I get error with My.Computer.FileSystem.... - How can I sort this out. Thanks Function Main() Dim file As String file = My.Computer.FileSystem.GetFiles "\\Directory\Inbox\EAF1NL*.xml" Set objBulkLoad = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload") objBulkLoad.ConnectionString = "provider=SQLOLEDB;data source=localhost;initial catalog=myDB; integrated security=SSPI" objBulkLoad.ErrorLogFile = "\\Directory\Inbox\EAF1errorfile.txt" objBulkLoad.Execute "\\Directory\Inbox\EAF1NL.xsd", "file" My.Computer.FileSystem.MoveFile "file","\\Directory\Inbox\Archive\" Set objBulkLoad = Nothing Main = DTSTaskExecResult_Success End Function |
![]() |
| Thread Tools | |
| Display Modes | |