|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Problem executing a DTS from a VB6 application after installing thI have a process in my VB6 application which executes a DTS. It works fine
in the development workstation, but when I make the deployment Package and installed on the end users PC, I get an error when the DTS process is executed. This is the code I have inside the application: Dim dtsp As New DTS.Package dtsp.LoadFromSQLServer _ ServerName:="gdb03sql", _ ServerUserName:="ctms", _ ServerPassword:="ctms", _ PackageName:="DTS_JV667_CTMS" dtsp.Execute
Show quote
Hide quote
"Eduardo78" <Eduard***@discussions.microsoft.com> wrote in message And the error is....?news:086B2C9A-02C3-4DF5-AE57-03D06A705FCC@microsoft.com... > I have a process in my VB6 application which executes a DTS. It works fine > in the development workstation, but when I make the deployment Package and > installed on the end users PC, I get an error when the DTS process is > executed. > > This is the code I have inside the application: > > Dim dtsp As New DTS.Package > dtsp.LoadFromSQLServer _ > ServerName:="gdb03sql", _ > ServerUserName:="ctms", _ > ServerPassword:="ctms", _ > PackageName:="DTS_JV667_CTMS" > dtsp.Execute <envelope please> -ralph Thanks,
The message says : Run-time error '429': ActiveX component can't create object Thanks for any suggestions. One guy at my company told me that I can not execute DTS from client PCs without having the Enterprise Manager Installed. Could that be the cause? Show quoteHide quote "Ralph" wrote: > > "Eduardo78" <Eduard***@discussions.microsoft.com> wrote in message > news:086B2C9A-02C3-4DF5-AE57-03D06A705FCC@microsoft.com... > > I have a process in my VB6 application which executes a DTS. It works > fine > > in the development workstation, but when I make the deployment Package and > > installed on the end users PC, I get an error when the DTS process is > > executed. > > > > This is the code I have inside the application: > > > > Dim dtsp As New DTS.Package > > dtsp.LoadFromSQLServer _ > > ServerName:="gdb03sql", _ > > ServerUserName:="ctms", _ > > ServerPassword:="ctms", _ > > PackageName:="DTS_JV667_CTMS" > > dtsp.Execute > > And the error is....? > > <envelope please> > -ralph > > > "Eduardo78" <Eduard***@discussions.microsoft.com> wrote in message You don't have to have Enterprise Manager installed but the client PC will news:7741FCF5-0E03-49BA-B660-8B6B39272E8C@microsoft.com... > The message says : Run-time error '429': > ActiveX component can't create object > > Thanks for any suggestions. > One guy at my company told me that I can not execute DTS from client PCs > without having the Enterprise Manager Installed. Could that be the cause? need to have various DTS libraries installed. Creating a setup package might do what you need, but I recall having to manually copy and register these DLLs onto a machine once (but maybe that was because it was Win95). Moral: ALWAYS create setup packages.
Show quote
Hide quote
"Eduardo78" <Eduard***@discussions.microsoft.com> wrote in message Yes. Sort of. <g>news:7741FCF5-0E03-49BA-B660-8B6B39272E8C@microsoft.com... > Thanks, > > The message says : Run-time error '429': > ActiveX component can't create object > > Thanks for any suggestions. > One guy at my company told me that I can not execute DTS from client PCs > without having the Enterprise Manager Installed. Could that be the cause? > > > "Ralph" wrote: > > > > > "Eduardo78" <Eduard***@discussions.microsoft.com> wrote in message > > news:086B2C9A-02C3-4DF5-AE57-03D06A705FCC@microsoft.com... > > > I have a process in my VB6 application which executes a DTS. It works > > fine > > > in the development workstation, but when I make the deployment Package and > > > installed on the end users PC, I get an error when the DTS process is > > > executed. > > > > > > This is the code I have inside the application: > > > > > > Dim dtsp As New DTS.Package > > > dtsp.LoadFromSQLServer _ > > > ServerName:="gdb03sql", _ > > > ServerUserName:="ctms", _ > > > ServerPassword:="ctms", _ > > > PackageName:="DTS_JV667_CTMS" > > > dtsp.Execute > > > > And the error is....? > > > > <envelope please> > > -ralph > > There are various ways to do what you are trying to do. You may not need VB to do it. (I have always used SQL Server itself to invoke and run the package.) Check this site as a good place to start... http://www.databasejournal.com/features/mssql/article.php/1486471 -ralph Thanks,
I did create a setup package and Iam having that error message. I know it can be run directly from sql, but the thing is that in this case is a process that the user has to execute during a process that he makes. I didnt understand the part of having the DTS libraries installed. How do i do that? Thanks for any suggestions. Show quoteHide quote "Ralph" wrote: > > "Eduardo78" <Eduard***@discussions.microsoft.com> wrote in message > news:7741FCF5-0E03-49BA-B660-8B6B39272E8C@microsoft.com... > > Thanks, > > > > The message says : Run-time error '429': > > ActiveX component can't create object > > > > Thanks for any suggestions. > > One guy at my company told me that I can not execute DTS from client PCs > > without having the Enterprise Manager Installed. Could that be the cause? > > > > > > "Ralph" wrote: > > > > > > > > "Eduardo78" <Eduard***@discussions.microsoft.com> wrote in message > > > news:086B2C9A-02C3-4DF5-AE57-03D06A705FCC@microsoft.com... > > > > I have a process in my VB6 application which executes a DTS. It works > > > fine > > > > in the development workstation, but when I make the deployment Package > and > > > > installed on the end users PC, I get an error when the DTS process is > > > > executed. > > > > > > > > This is the code I have inside the application: > > > > > > > > Dim dtsp As New DTS.Package > > > > dtsp.LoadFromSQLServer _ > > > > ServerName:="gdb03sql", _ > > > > ServerUserName:="ctms", _ > > > > ServerPassword:="ctms", _ > > > > PackageName:="DTS_JV667_CTMS" > > > > dtsp.Execute > > > > > > And the error is....? > > > > > > <envelope please> > > > -ralph > > > > > Yes. Sort of. <g> > > There are various ways to do what you are trying to do. You may not need VB > to do it. (I have always used SQL Server itself to invoke and run the > package.) > > Check this site as a good place to start... > http://www.databasejournal.com/features/mssql/article.php/1486471 > > -ralph > > > > > "Eduardo78" <Eduard***@discussions.microsoft.com> wrote in message SOMEWHERE (don't ask me where) in the folders that got installed on your news:375B9B79-1C3D-49C2-A51C-B77407F25E94@microsoft.com... > I didnt understand the part of having the DTS libraries installed. How do > i > do that? machine when you installed Enterprise Manager is a text file that outlines what libraries are needed for what. (For example, if you don't have custom tasks in your package you don't need to distribute the custom tasks DLL.) Identify the DLLs you'll need and either manually add them to the setup package or copy them to the client PC and regsvr32 them. "Eduardo78" <Eduard***@discussions.microsoft.com> wrote in message Here are some KB articles that may be helpful. Not all of them deal news:086B2C9A-02C3-4DF5-AE57-03D06A705FCC@microsoft.com... >I have a process in my VB6 application which executes a DTS. It works fine > in the development workstation, but when I make the deployment Package and > installed on the end users PC, I get an error when the DTS process is > executed. strictly with running a DTS package from VB, but they may still provide useful information. How to run a SQL Server Data Transformation Services package from Visual Basic http://support.microsoft.com/kb/315661/EN-US/ HOW TO: Troubleshoot DTS Packages That You Run from Visual Basic Applications http://support.microsoft.com/default.aspx?scid=kb;en-us;323685 PRB: Error Message: "Exception Access Violation 2147221499.Need to run the object to perform this operation" Occurs When You Run a DTS Package in Microsoft Visual Basic Code http://support.microsoft.com/kb/271889/EN-US/ INF: How to Run a DTS Package as a Scheduled Job http://support.microsoft.com/default.aspx?scid=kb;en-us;269074 INF: DTS Package Development, Deployment and Performance http://support.microsoft.com/kb/242391/ HOW TO: Install Data Transformation Services (DTS) Event Handlers in Visual Basic http://support.microsoft.com/kb/221193/ SQL Server Books Online also contains information about running DTS packages from VB. -- Mike Microsoft MVP Visual Basic |
|||||||||||||||||||||||
Other interesting topics