Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bizarre warnings in Script Task Object

Status
Not open for further replies.

Catadmin

Programmer
Oct 26, 2001
3,097
US
Okay, here's a fun one.

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"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top