Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 In SSIS 2008 I get dts error

Author  Topic 

Ats
Starting Member

32 Posts

Posted - 2010-03-12 : 05:50:27
I am creating a script task in Bids and I get the error message name 'dts' is not declared. does anyone have an idea on how to change script


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


Public Class ScriptMain



Public Sub Main()
'
' Set BulkFile connection to gvBulkFile global variable
'

dts.Connections.Item("BulkFile").ConnectionString = dts.Variables.Item("FileName").Value.ToString()

' Success
dts.TaskResult = dts.Results.Success
End Sub

End Class
   

- Advertisement -