Data Transformation Services
in VB.NET
I have an exsisting DTS on a server that I want to be able to run from the new vb.net application that I am creating now. All I have been able to do is connect to the databases on that server. I have read that .net does not have this feature yet, and I am really hoping that is not true. Anyone know how to pull it off?
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- 140.8K All Categories
- 103.6K Programming Languages
- 6.4K Assembler Developer
- 401 Assembly Code Share
- 239 Getting started in assembly
- 4.6K x86 Assembly
- 1.9K Basic
- 97 Qbasic
- 39.9K C and C++
- 5.6K Beginner C/C++
- 330 C/C++ on Linux/Unix
- 450 C/C++ Windows API
- 522 C++ Builder
- 253 C++ Game Development
- 3.3K C++ MFC
- 103 C++.NET
- 404 Visual C++
- 2.9K C#
- 7.9K Delphi and Kylix
- 334 Advanced Delphi
- 360 Delphi beginners
- 4 Haskell
- 9.7K Java
- 56 Enterprise JavaBeans
- 1.3K Java Beginners
- 304 Java Server Pages
- 4.1K Pascal
- 1.3K Perl
- 11 Perl 6
- 2K PHP
- 546 Python
- 37 Ruby
- 4.4K VB.NET
- 258 Advanced VB.Net
- 1.6K VBA
- 20.9K Visual Basic
- 767 Access databases and VB
- 831 Advance Visual Basic
- 1.2K Beginner VB
- 2.6K Game programming
- 315 Console programming
- 90 DirectX Game dev
- 1 Minecraft
- 112 Newbie Game Programmers
- 2 Oculus Rift
- 9K Applications
- 1.8K Computer Graphics
- 279 3D Graphics
- 129 DirectX
- 125 OpenGL
- 740 Computer Hardware
- 9 Cooling & Overclocking
- 3.4K Database & SQL
- 1.1K Access
- 91 ADO Programming
- 288 MySQL
- 358 Oracle
- 440 SQL-Server
- 535 Electronics development
- 1.6K Matlab
- 628 Sound & Music
- 25 DirectSound
- 257 XML Development
- 3.3K Classifieds
- 200 Co-operative Projects
- 198 For sale
- 190 FreeLance Software City
- 1.9K Jobs Available
- 603 Jobs Wanted
- 209 Wanted
- 2.9K Microsoft .NET
- 1.8K ASP.NET
- 1.1K .NET General
- 22 .NET WEB-Services
- 129 .NET WinForms
- 14 .NET XML
- 50 ADO.NET
- 144 C# & VB.NET School Support
- 3.4K Miscellaneous
- 4 Join the Team
- 354 Comments on this site
- 69 Computer Emulators
- 2.1K General programming
- 187 New programming languages
- 621 Off topic board
- 200 Mobile & Wireless
- 72 Android
- 126 Palm Pilot
- 338 Multimedia
- 154 Demo programming
- 184 MP3 programming
- 0 Bash scripts
- 27 Cloud Computing
- 1 Witsbits Go Cloud
- 53 FreeBSD
- 1.7K LINUX programming
- 1 Awk scripting
- 332 Linux Support
- 0 Sed scripting
- 370 MS-DOS
- 0 Shell scripting
- 321 Windows CE & Pocket PC
- 4.1K Windows programming
- 177 COM/DCOM
- 61 Networking And Security
- 17 Windows 2003 Server
- 6 Windows Vista
- 176 Windows XP
- 941 Software Development
- 417 Algorithms
- 68 Object Orientation
- 24 RUP & UML
- 92 Project Management
- 95 Quality & Testing
- 268 Security
- 63 Evil Scripting
- 81 Hacking
- 7.7K WEB-Development
- 1.8K Active Server Pages
- 61 AJAX
- 4 Bootstrap Themes
- 55 CGI Development
- 28 ColdFusion
- 224 Flash development
- 1.4K HTML & WEB-Design
- 1.4K Internet Development
- 131 Mobile Internet & Messaging
- 211 Wireless development
- 2.2K JavaScript
- 37 JQuery
- 304 WEB Servers
- 153 Apache
- 79 IIS
- 150 WEB-Services / SOAP
Comments
:
.NET can still use COM components, but COM components will not be protected by the runtime.
: :
:
: .NET can still use COM components, but COM components will not be protected by the runtime.
:
Ok. But how do I use that to link to my DTS? Maybe I am not totally understandind what you are saying. Thanks.
: : :
: :
: : .NET can still use COM components, but COM components will not be protected by the runtime.
: :
:
:
: Ok. But how do I use that to link to my DTS? Maybe I am not totally understandind what you are saying. Thanks.
:
:
I guess Im assuming you have connected to a DTS using VB6 before. Im not sure how to connect to a DTS, however if .NET has no support for it, COM (supported by all prior versions of Visual Basic) will. The good news is that you can still use COM objects under .NET.
When you add a reference to a project (in Visual Studios.NET as least) you have a list of .NET objects or a list of COM components to choose from. If the library that accesses the DTS is listed under the COM components, adding a reference to it will automatically create a .NET wrapper object for it. Visual Studios will automatically create a dll and place it in the BIN folder of the project.
If you are not using Visual Studios.NET then you need to look into the .NET Interop Services section in the .NET SDK. .NET comes with a program that will do the COM to .NET conversion for you. It will create that DLL for you to to place in the BIN directory of your project.
I am sorry that I dont have a direct solution, but I believe Im leading you in the right direction.
: : : :
: : :
: : : .NET can still use COM components, but COM components will not be protected by the runtime.
: : :
: :
: :
: : Ok. But how do I use that to link to my DTS? Maybe I am not totally understandind what you are saying. Thanks.
: :
I have had very little experiance with vb6 because I am pretty young and I have been using .net since I started. I see what you are saying and I think that is the right path. Thanks for the help.
: :
:
: I guess Im assuming you have connected to a DTS using VB6 before. Im not sure how to connect to a DTS, however if .NET has no support for it, COM (supported by all prior versions of Visual Basic) will. The good news is that you can still use COM objects under .NET.
:
: When you add a reference to a project (in Visual Studios.NET as least) you have a list of .NET objects or a list of COM components to choose from. If the library that accesses the DTS is listed under the COM components, adding a reference to it will automatically create a .NET wrapper object for it. Visual Studios will automatically create a dll and place it in the BIN folder of the project.
:
: If you are not using Visual Studios.NET then you need to look into the .NET Interop Services section in the .NET SDK. .NET comes with a program that will do the COM to .NET conversion for you. It will create that DLL for you to to place in the BIN directory of your project.
:
: I am sorry that I dont have a direct solution, but I believe Im leading you in the right direction.
:
:
: : : :
: : :
: : : .NET can still use COM components, but COM components will not be protected by the runtime.
: : :
: :
: :
: : Ok. But how do I use that to link to my DTS? Maybe I am not totally understandind what you are saying. Thanks.
: :
: :
:
: I guess Im assuming you have connected to a DTS using VB6 before. Im not sure how to connect to a DTS, however if .NET has no support for it, COM (supported by all prior versions of Visual Basic) will. The good news is that you can still use COM objects under .NET.
:
: When you add a reference to a project (in Visual Studios.NET as least) you have a list of .NET objects or a list of COM components to choose from. If the library that accesses the DTS is listed under the COM components, adding a reference to it will automatically create a .NET wrapper object for it. Visual Studios will automatically create a dll and place it in the BIN folder of the project.
:
: If you are not using Visual Studios.NET then you need to look into the .NET Interop Services section in the .NET SDK. .NET comes with a program that will do the COM to .NET conversion for you. It will create that DLL for you to to place in the BIN directory of your project.
:
: I am sorry that I dont have a direct solution, but I believe Im leading you in the right direction.
:
: A final question I hope...How do I know which library accesses the DTS?
: : : : :
: : : :
: : : : .NET can still use COM components, but COM components will not be protected by the runtime.
: : : :
: : :
: : :
: : : Ok. But how do I use that to link to my DTS? Maybe I am not totally understandind what you are saying. Thanks.
: : :
: : :
: :
: : I guess Im assuming you have connected to a DTS using VB6 before. Im not sure how to connect to a DTS, however if .NET has no support for it, COM (supported by all prior versions of Visual Basic) will. The good news is that you can still use COM objects under .NET.
: :
: : When you add a reference to a project (in Visual Studios.NET as least) you have a list of .NET objects or a list of COM components to choose from. If the library that accesses the DTS is listed under the COM components, adding a reference to it will automatically create a .NET wrapper object for it. Visual Studios will automatically create a dll and place it in the BIN folder of the project.
: :
: : If you are not using Visual Studios.NET then you need to look into the .NET Interop Services section in the .NET SDK. .NET comes with a program that will do the COM to .NET conversion for you. It will create that DLL for you to to place in the BIN directory of your project.
: :
: : I am sorry that I dont have a direct solution, but I believe Im leading you in the right direction.
: :
: : A final question I hope...How do I know which library accesses the DTS?
:
:
It will have the word DTS in the reference name. Like the "Microsoft DTS Custom Task Object Library." I am not positive what you are trying to do but it quite possible that classic ADO is needed to access the DTS. That would be the "Microsoft Data Active Objects" the most current version on your computer.
: : : : : :
: : : : :
: : : : : .NET can still use COM components, but COM components will not be protected by the runtime.
: : : : :
: : : :
: : : :
: : : : Ok. But how do I use that to link to my DTS? Maybe I am not totally understandind what you are saying. Thanks.
: : : :
: : : :
: : :
: : : I guess Im assuming you have connected to a DTS using VB6 before. Im not sure how to connect to a DTS, however if .NET has no support for it, COM (supported by all prior versions of Visual Basic) will. The good news is that you can still use COM objects under .NET.
: : :
: : : When you add a reference to a project (in Visual Studios.NET as least) you have a list of .NET objects or a list of COM components to choose from. If the library that accesses the DTS is listed under the COM components, adding a reference to it will automatically create a .NET wrapper object for it. Visual Studios will automatically create a dll and place it in the BIN folder of the project.
: : :
: : : If you are not using Visual Studios.NET then you need to look into the .NET Interop Services section in the .NET SDK. .NET comes with a program that will do the COM to .NET conversion for you. It will create that DLL for you to to place in the BIN directory of your project.
: : :
: : : I am sorry that I dont have a direct solution, but I believe Im leading you in the right direction.
: : :
: : : A final question I hope...How do I know which library accesses the DTS?
: :
: :
:
: It will have the word DTS in the reference name. Like the "Microsoft DTS Custom Task Object Library." I am not positive what you are trying to do but it quite possible that classic ADO is needed to access the DTS. That would be the "Microsoft Data Active Objects" the most current version on your computer.
:
I want to have a simple button that the user can click and it would run this DTS that is on a SQL server we have. Thanks for your help seeing how I am a rookie programmer...
: : : : : :
: : : : :
: : : : : .NET can still use COM components, but COM components will not be protected by the runtime.
: : : : :
: : : :
: : : :
: : : : Ok. But how do I use that to link to my DTS? Maybe I am not totally understandind what you are saying. Thanks.
: : : :
: : : :
: : :
: : : I guess Im assuming you have connected to a DTS using VB6 before. Im not sure how to connect to a DTS, however if .NET has no support for it, COM (supported by all prior versions of Visual Basic) will. The good news is that you can still use COM objects under .NET.
: : :
: : : When you add a reference to a project (in Visual Studios.NET as least) you have a list of .NET objects or a list of COM components to choose from. If the library that accesses the DTS is listed under the COM components, adding a reference to it will automatically create a .NET wrapper object for it. Visual Studios will automatically create a dll and place it in the BIN folder of the project.
: : :
: : : If you are not using Visual Studios.NET then you need to look into the .NET Interop Services section in the .NET SDK. .NET comes with a program that will do the COM to .NET conversion for you. It will create that DLL for you to to place in the BIN directory of your project.
: : :
: : : I am sorry that I dont have a direct solution, but I believe Im leading you in the right direction.
: : :
: : : A final question I hope...How do I know which library accesses the DTS?
: :
: :
:
: It will have the word DTS in the reference name. Like the "Microsoft DTS Custom Task Object Library." I am not positive what you are trying to do but it quite possible that classic ADO is needed to access the DTS. That would be the "Microsoft Data Active Objects" the most current version on your computer.
:
I added it as a reference and I don't know what to do after that.
: : : : : : :
: : : : : :
: : : : : : .NET can still use COM components, but COM components will not be protected by the runtime.
: : : : : :
: : : : :
: : : : :
: : : : : Ok. But how do I use that to link to my DTS? Maybe I am not totally understandind what you are saying. Thanks.
: : : : :
: : : : :
: : : :
: : : : I guess Im assuming you have connected to a DTS using VB6 before. Im not sure how to connect to a DTS, however if .NET has no support for it, COM (supported by all prior versions of Visual Basic) will. The good news is that you can still use COM objects under .NET.
: : : :
: : : : When you add a reference to a project (in Visual Studios.NET as least) you have a list of .NET objects or a list of COM components to choose from. If the library that accesses the DTS is listed under the COM components, adding a reference to it will automatically create a .NET wrapper object for it. Visual Studios will automatically create a dll and place it in the BIN folder of the project.
: : : :
: : : : If you are not using Visual Studios.NET then you need to look into the .NET Interop Services section in the .NET SDK. .NET comes with a program that will do the COM to .NET conversion for you. It will create that DLL for you to to place in the BIN directory of your project.
: : : :
: : : : I am sorry that I dont have a direct solution, but I believe Im leading you in the right direction.
: : : :
: : : : A final question I hope...How do I know which library accesses the DTS?
: : :
: : :
: :
: : It will have the word DTS in the reference name. Like the "Microsoft DTS Custom Task Object Library." I am not positive what you are trying to do but it quite possible that classic ADO is needed to access the DTS. That would be the "Microsoft Data Active Objects" the most current version on your computer.
: :
: I added it as a reference and I don't know what to do after that.
:
Do u have MSDN library ... if not go to msdn.microsoft.com and you should be able to find anything micorsoft related (programming ect...) Unfortunately I never worked with a DTS so this is the best I can give u
If u need help, i can figure pretty much anything visual basic-wise out. E-mail me code snippets if necessary. michaelferrini@yahoo.com
I would need to see more of what ur trying to accomplish.