Re: DTS object model
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 05/04/04
- Next message: Allan Mitchell: "Re: DTS connection & BulkInsertTask"
- Previous message: Steven Wong: "BCP a sectional bulk of data from Table1 (in db1) to Table2 (in db2)"
- In reply to: RK: "DTS object model"
- Next in thread: RK: "Re: DTS object model"
- Reply: RK: "Re: DTS object model"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 4 May 2004 19:40:46 +0100
You want to create one or manipulate one.
Whilst it is possible to build one completely from scratch I would probably
go with manipulating it.
So Say I have a Package called MyPackage and in there I have a
TextFileConnection. i can do this to grab a ref to the connection
Dim p As New DTS.Package
Dim cn As DTS.Connection
p.LoadFromSQLServer(".", , ,
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , ,
"MyPackage")
For Each cn In p.Connections
If cn.ProviderID = "DTSFlatFile" Then 'text File
'ideally you would know the name of the connection
End If
Next
p.UnInitialize()
-- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "RK" <anonymous@discussions.microsoft.com> wrote in message news:123ED7F8-9268-4575-82EB-2303ADAF3629@microsoft.com... > Hi, > > Can anyone tell me how to do: Text File connection to DTS in DTS object model in vb.net? > > Thanks, > RK
- Next message: Allan Mitchell: "Re: DTS connection & BulkInsertTask"
- Previous message: Steven Wong: "BCP a sectional bulk of data from Table1 (in db1) to Table2 (in db2)"
- In reply to: RK: "DTS object model"
- Next in thread: RK: "Re: DTS object model"
- Reply: RK: "Re: DTS object model"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
