Forum Post: Using DataDirect ODBC connections in an SSIS Script Task

  • Thread starter Thread starter john_thurgood
  • Start date Start date
Status
Not open for further replies.
J

john_thurgood

Guest
Hello, I'm looking to use an SSIS Script Task to dynamically build an external SSIS package using Data Flows with DataDirect ODBC source and destination connections. What references and syntax need to be applied (non-working e.g. below)? Dim package As New Package () package.Name = "OdbcSourceTest" package.PackageType = DTSPackageType .DTSDesigner100 Dim cmSource As ConnectionManager = package.Connections.Add( "Odbc" ) cmSource.ConnectionString = "DSN=DataDirect_ODBCsource;DB=DBsource;UID=user;pwd=password" cmSource.Name = "OdbcSource"

Continue reading...
 
Status
Not open for further replies.
Back
Top