Okay, here's a fun one.
Anyway, I've got a Script Task object where I'm trying to verify if a file exists. Here's the code:
When I do Debug -> Build within the Script designer, I get no errors, but I get 7 warnings. Here they are:
Any thoughts on what these warnings could mean?
Thanks,
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
BTW, be VERY CAREFUL if you google these errors. The only things I found appear to be a lot of "downloadable" sites out there that have these errors as keywords and have the appearance of virus files. I didn't go to those websites as I didn't want to take a chance on killing my PC.
Anyway, I've got a Script Task object where I'm trying to verify if a file exists. Here's the code:
Code:
Imports System
Imports System.Data
Imports System.Math
Imports System.IO
Imports Microsoft.SqlServer.Dts.Runtime
Public Class ScriptMain
Public Sub Main()
'
' This checks to see if the file is where it is supposed to be
'
Dim TotFileName As String
TotFileName = CStr(Dts.Variables.Item("gsFilePathName").Value)
'NOTE: the names in quotes are the names of the global variables.
If File.Exists("gsFilePathName") Then
Dts.ExecutionValue = 1
Else
Dts.ExecutionValue = 0
End If
'Dts.TaskResult = Dts.Results.Success
End Sub
End Class
When I do Debug -> Build within the Script designer, I get no errors, but I get 7 warnings. Here they are:
Warnings said:The dependency 'EnvDTE' could not be found.
The dependency 'Microsoft.SqlServer.VSAHosting' could not be found.
The dependency 'Microsoft.SqlServer.DTSRuntimeWrap' could not be found.
The dependency 'Microsoft.SqlServer.PipelineHost' could not be found.
The dependency 'Microsoft.SqlServer.msxml6_interop' could not be found.
The dependency 'Microsoft.SqlServer.SqlTDiagM' could not be found.
The dependency 'Microsoft.SqlServer.VSAHostingDT' could not be found.
Any thoughts on what these warnings could mean?
Thanks,
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"