_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › SSIS-FileExists
Describe SSIS-FileExists here

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.IO

Public Class ScriptMain

	' The execution engine calls this method when the task executes.
	' To access the object model, use the Dts object. Connections, variables, events,
	' and logging features are available as static members of the Dts class.
	' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.
	' 
	' To open Code and Text Editor Help, press F1.
	' To open Object Browser, press Ctrl+Alt+J.

	Public Sub Main()
		'
		' Add your code here
        '
        Dim FileName As String
        FileName = Dts.Variables("FileName").Value.ToString()

        If File.Exists(FileName) Then
            Dts.Variables("FileExistsYN").Value = "Y"
        Else
            Dts.Variables("FileExistsYN").Value = "N"
        End If


		Dts.TaskResult = Dts.Results.Success
	End Sub

End Class
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:53

語 蟠 豈螻 螳. 企Μ 企 蠏瑚 襷蟲 蟆 覯襴讌襷 覈 企 伎 暑. 語 覯襷 曙 る 蟆 蠍 覓語企. ( )