help with script

This is a discussion on help with script within the sqlserver-dts forums in Microsoft SQL Server category; 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...

Go Back   Database Forum > Microsoft SQL Server > sqlserver-dts

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-21-2008, 11:23 AM
Default help with script

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
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 02:47 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.