问ADO/ODBC连接下的Browse选项是否可以在SSIS中以编程方式完成？

EN

Dim filePath As String
filePath = Cstr(Me.Dts.Variables("scriptPath").Value)

Dim streamReader As New StreamReader(filePath)
Dim StreamText As String = streamReader.ReadToEnd()
Me.Dts.Variables("sqlQuery").Value = StreamText

CREATE TABLE dbo.tRef_Vertica_Transaction_Ids(
    [ID] INT NOT NULL PRIMARY KEY
)
-- Note: Having an index is important! It affects the query plan.
INSERT INTO dbo.tRef_Vertica_Transaction_Ids
SELECT *
FROM (VALUES
(123),(333),(999) -- Insert your ID's here
) Vals(v)

SELECT v.*
FROM OPENQUERY([VerticaDB], 'SELECT * FROM SourceTable') v
WHERE EXISTS (
    SELECT 1
    FROM dbo.tRef_Vertica_Transaction_Ids ref
    WHERE ref.ID = v.ID
)

SELECT v.*
FROM OPENQUERY([VerticaDB], 'SELECT * FROM SourceTable') v
INNER JOIN dbo.tRef_Vertica_Transaction_Ids ref
    ON ref.ID = v.ID

SELECT v.*
FROM OPENQUERY([VerticaDB], 'SELECT * FROM SourceTable') v
INNER REMOTE JOIN dbo.tRef_Vertica_Transaction_Ids ref
    ON ref.ID = v.ID