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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-03-12 : 09:20:55
|
| Addi writes "Hello to allI need to create a DTS Package with VB source code having following specifications:1) Source Provider : WINCCOLEDBPROVIDER.1 Data Source : ( Source Pcname) DSN : ( The database which is to be read at source)2) Destination Provider: MICROSOFT OLEDBPROVIDER Data Source : (Destination Pcname) Database : The data base which is used for insertion3) Transform Data Task pointing From Source to Destination. With the SQL Query " select ....." on Source tab."Create Table..." statement on Destination tab."Transformation_1" as Transformation.I have done this successfully in the DTS Designer but want to do it with code, Can someone help?thanks in advance Regards" |
|
|
JohnH
Starting Member
13 Posts |
Posted - 2007-03-12 : 12:56:29
|
| Open the package in the Designer. Select Package -> Save As ... and set the Location to "Visual Basic File". Open the file and have a look. IIRC, this is VB6 file and will need considerable work to translate to VB.Net.John Hopkins |
 |
|
|
|
|
|
Programming Complex SQL SERVER 2000 DTS Package in VB 6.0