Visual Basic :: DTS Package

Package && Deployment Hangs At Loading Package Types
Using VB6 on Vista. I haven't used my package and deployment for a while but today I recompiled my application and tried to ceate a new package for deployment. It got as far as "loading package types..." and quit. I reinstalled the program a couple of times without success. I noticed at the top of my 'Add-in Manager' there is an item that says "<MISSING>AFVBAddinConnect" if that makes any difference. Hopefully, someone has a solution or reason why this is occurring. Thanks.

Jim S.

Edited by - jschuchert on 8/17/2008 7:05:58 AM

Oracle Package.Procedure Works But Package.Function() Does Not ?
Hi,

I am trying to call a function in a package in Oracle, from VB. I am using the traditional ADODB with connection, command and parameter objects. The function has 6 input parameters and it returns a string value.

We have no problems reaching the similar Procedure under a package, but when it comes to accessing the function, it gives errors. I got "no descriptor found", after some changes "object stored Procedure does not exist" .

Any suggestions on how differently to access a function within a package as opposed to a procedure ?

Thanks,
Arch

Edited by - Archvile on 9/14/2004 3:07:01 PM

Package And Deployment Wizard Not Generating Package
Hi,

I am trying to generate a package, for a Visual Basic application I wrote, through the Package and Deployment Wizard utility. PDW seems to work great until it gets to the last step. When I click the "Finish" button, instead of generating the package, with its setup and library files, it bombs out/exits without giving any clue/error message why.

I would appreciate any help you could give me on that.

Thanks,

TM

Package && Deployment No Error But Package Not Create
I tried to package my vb program but after i have completed the package and deployment wizard, the wizard just exited without creating the installation package for me. I have check the folder, it only create the setup folder and support folder without files. please advise what could be wrong.

I have tried using the package and deployment for another VB Project without any problem.

Package 'cannot Find File' - L:Package\@test.exe
Hi,

I created a package for my software (written in VB6), but when I try to install, it tells me that a file: L:Package\@test.exe cannot be found (L:Package is the location of the package). Test.exe is supposed to be built into the package, but I get this error. Also, when it tries to remove the installed files, it just gets stuck and crashes.

Anyone got any ideas? - a quick reply would be greatly appreciated.

How Can I Change The Package Size Of Winsock Package.
I have a satellital connection. That´s requieres one maximun package size, the server send a notification of this to the client, but the client forget this.
I need read this notificartion and change the maximun package size!!

TIA

VB Package Using Package And Deployment Wizard
I am trying to create VB Package using Package and Deployment Wizard.
Earlier I have created Package successfully
But recently I have installed .Net in my system. From onwards I am getting
Ã¢â‚¬Å“The exception unknown software exception (0xc06d007e) occurred in the application at location 0x7c59bbf3Ã¢â‚¬Â error while creating VB application package. This is coming at the end of process.

But still I am getting Package. But while installing this package this is giving following error.
Ã¢â‚¬Å“The operating system is not presently configured to run this applicationÃ¢â‚¬Â.

I have created this package on Win 2000 operating system.

Please help me. This very urgent.
Thanks,
Kumar

Calling An Oracle Package.Procedure Works But Calling A Function In The Package Does Not ?
Hi,

I am trying to call a function in a package in Oracle, from VB. I am using the traditional ADODB with connection, command and parameter objects. The function has 6 input parameters and it returns a string value.

We have no problems reaching the similar Procedure under a package, but when it comes to accessing the function, it gives errors. I got "no descriptor found", after some changes "object stored Procedure does not exist" .

Any suggestions on how differently to access a function within a package as opposed to a procedure ?

Thanks,
Arch

Execte DTS Package From VB Doesn't Run "Execute Package"
Hey!

I am executing a DTS package from VB. This DTS package has an Execute Package task which executes a child package. Or it should do!! When running from Enterprise Manager the two packages run successfully. When I try to execute them from VB it appears to run successfully, but it is only running the top package.

Any ideas?

Install An MSI Package In An MSI Package.
I'm using Microsoft Visual Studio Installer 1.1 which I find easy to use. But unfortunately it's limited. It doesn't have something like installing additional features. And by installing additional features, I mean to say like a prompt for users if MDAC would be installed or something else. I found an article in MSDN which encapsulates the installation of MDAC. Or more to say, run the MDAC_TYP.exe from the MSI package. Now I want to know if there's also a way to run an MSI package included in an MSI package. In other words, run an MSI package (mostly third party) then run my MSI package to install my application. Is this possible?

Best Way To Package??
Yippee.. I love an opportunity to sound like a newbie.

I am about to distribute a VB app to an office, and I have been using the standard Package and Deployment plugin to do it. However, I feel this setup process leaves a lot to be desired, like unable to place Shortcuts anywhere, and seemingly no other customization options for the installing party. What options are out there and what is considered the "best way to go"? Any help on this will be greatly appreciated! Thanks in advance!

Package
I have a project that i've finished. I've build the package. the project have an access file withe a jet ole connection.
I install the package sucessfully, but i can't open the game, and show the next message:
run time erro 2706 ADO could not find the specified provider.

What files i have to include in the project??

Why Is The Package So Big?
why when using package and deployment wizard the resulting package files are so big even though the size of the project itself won't exceed 2 mb?

DTS Package From VB
Dim objPkge As New DTS.Package
Dim strPkge As String

strPkge = "a_dts_package"
With objPkge
.LoadFromSQLServer "aserver", , , , , , , strPkge
.Execute
End With

This gives me the error 'my login name' is not associated with a trusted connection.

The Application is already connected to an SQL Db there is a global object available, and there has already been activity on the Db at this point. Is there any way to tell the dts package to use the existing connection rather than try to create a new one. I am using NT authentication.

Any advice would be greatly appreciated.

Package With DLL
Hi.

Is there a trick or something special to do to create good dependency with a DLL added to a project ? I'm using an external DLL and it work really fine on my computer with VB. The problem is to make it work on other computer.

I've tried in the packaging to make it shared or not, registered or not. To save it into the installation directory or in the Windows Systems directory. In all case, the function that use the DLL doesn't work on other computers.

Does the fact that the DLL is written in C affect my VB project ?

The "Depends" tools that come with VB indicate dependency about the dll with Kernel32.dll, user32.dll, crtdll.dll, ntdll.dll and gdi32.dll. Should I add those file into the packaging ? I've tried it too but without success...

Thanks

Package Dll
Hi Guys

Ok at the moment in my vb project im using .bas files but these functions are really handy so i decided i'd try and create a .dll file.
The thing is if i package this project using the "Package and Development Wizard" will it register my .dll on the end user's computer. And if it doesnt is there any easy way of doing it besides going around to each individual computer and typing
"regsvr32 c:windowssystemfilename.dll"

Or should i just stick to my .bas file and include it in each project.

thanx
shane

Package
If i make with package & dep wizzard a install for my database after installing on a other dir as c:program filesooksdb it cannot find the database how can i fix it that
vb automatic finds my db.

Package
I tried to reference "Microsoft VBScript Regular Expressions" which is located in "c:winntsystem32vbscript.dll2" and my code work perfectly with this reference. However, when I package, it complain that the file "2" is missing. Do you have any idea with this?

Package
how do you package up an application to install
on another computer. In particular how do you
resister .ocx files etc
many thanks....

Dts Package
hi people, i have a DTS PACKAGE wich several tasks:

1) Creates a new table (a temporary table)
2) Exports data from a Text File to the new Table created before.
3) Proccess the info stored in the temporary table to do some inserts,
updates and deletes in other tables.
4) Deletes temporary table.

It works great but any time i want to execute it in a different database (same server!)
i have to change some properties (manual):
* Database name in the connection Object.
* The complete table name ([databasename].[dbo].[tablename]) in the destination property in the object 'Transform Data task' (it means where the data from file must be exported to..)

i wanted to know how to set a global variable for DATABASENAME at DTS package in order to not to change that 2 properties manually.

Sorry, my english!
Tanks in advance!

Dts Package
A few questions...
I have a DTS Package:
1) how to execute it from query analyzer?
2) inside package i execute a stored procedure...how could i send parameters to that Stored procedure from outside package?

Thanks in advance!
Bye

Run A DTS Package???
Does anyone know how to run a created SQL DTS package from VB?

Thanx in advance.

Sql Dts Package
Hi people! I have a simple question.... I have a DTS Package and i need to execute it from a stored procedure but i dont know how!
Any help?
Thanks in advance!

Package
hi all, i have created package for my vb project in windows 98. when i try to install that package in another system which does not have Visual Studio. i am encountering en error that "ActiveX component can't create object" error is coming.. plz help me to resolve it

What Is A CRM Package?
read topic

Using DTS Package In VB
hi guys. its been long time away from forum

i have a vb app which created database option . i was using

Code:
ShellandWait "osql -S "
..................

and it works fine but if any error occurs i cannot trap it or handle it
i was looking for alternative.

i am using DTSpackage i saved the package as vbmodule and using it. i need to use the event.

so my code code goes like this...

Code:

Option Explicit
Public WithEvents goPackage As DTS.Package

Private Sub goPackage_OnError(ByVal EventSource As String, _
ByVal ErrorCode As Long, ByVal Source As String, _
ByVal Description As String, ByVal HelpFile As String, _
ByVal HelpContext As Long, _
ByVal IDofInterfaceWithError As String, pbCancel As Boolean)
Dim sMsg As String

sMsg = "EventSource: " & EventSource & vbCrLf & _
"ErrorCode: " & (ErrorCode) & vbCrLf & _
"Source: " & Source & vbCrLf & _
"Description: " & Description & vbCrLf & _
"HelpFile: " & HelpFile & vbCrLf & _
"IDofIFWErr: " & IDofInterfaceWithError
MsgBox sMsg, vbExclamation, "OnError"

End Sub

Private Sub goPackage_OnFinish(ByVal EventSource As String)
MsgBox EventSource, vbInformation, "OnFinish"

End Sub

Private Sub goPackage_OnProgress(ByVal EventSource As String, _
ByVal ProgressDescription As String, _
ByVal PercentComplete As Long, _
ByVal ProgressCountLow As Long, _
ByVal ProgressCountHigh As Long)
Dim sMsg As String

sMsg = "EventSource: " & EventSource & vbCrLf & _
"ProgressDescr: " & ProgressDescription & vbCrLf & _
"PercentComplete: " & (PercentComplete) & vbCrLf & _
"ProgressCountLow: " & (ProgressCountLow) & vbCrLf & _
"ProgressCountHigh: " & (ProgressCountHigh)
MsgBox sMsg, vbExclamation, "OnProgress"
End Sub

Private Sub Command1_Click()
MainSub "khalik"
goPackage.Execute
goPackage.Uninitialize
End Sub

and in module... i am assinging the dts object to form public variable

Code:
Set Form1.goPackage = goPackage

seems there some problem the app get hang it happens all the time i have tried several way but havent found a way out...

in simple terms i need to create database for my app with table and all that stuff and shd be able to handle the errors if any...

shd be a different way out

To Package...
My client vb application uses crystal reports. I store ALL the reports in a seperate folder ironically called "Reports".

My question is..when I package my application do I just add the complete folder of "Reports"? Meaning when the application is installed on the end users pc..in some file say:

C:ProgramFilesMyApp..

Then will the reports be in:

C:ProgramFilesMyAppReports??

Thanks

Jon

Package ....?
i have seen several gurus saying P&D is good.. works well.. i see several threads posting problems with it... mostly i have used P&D and very rarelly i use to get some problem..

but this time my boss what me to work on wise... i am no wise enough to work on it.... did any one worked on it and how diff is it with P&D and can i get some sample stuff to start fast...

things have to be done fast on fly....

DTS Package...
hi

working on telecom project i need to load data from txt file to database and process.. so i have design a DTSpackage to do that work fine on my pc when i create a setup package and install on user side the Activex object cannot be created.

any Idea what all file need to be included

Package
can anyone help me?
how do i package my software into an installer kind of thingy? i know Visual Studio has a tool but my program incorporates a few standalone EXEs . can i include those as part of my package too? please help

Package
u can use package & development wizard

just give it the name of ur project

COM+ Package
Hi all,
Any one knows which the most commonly used Authentication level and Impersonation level in COM+ Package

Package
the problem is i need to create a new package, uninstall the existing one at clients m/c., and reinstall it each and everytime at client's machines even for a small change in the application. how can we prevent this? is there any way to do like developer 2000, making executables for each form? will it be advisable?

CD Package
Is there a way to install your program on a CD so the customer does not have to install it they just run it from the CD?

VB Package
I have created a VB application. And used VB packaing tool to Create a setup for that program. All this was done on VB 6 on win 2000 Professional.
When I run my set up on a clean PC ( win 2000 installed and no VB installed at all), it gives me an error 'some system files are old. Setup cannot continue'
Can any one tell me why this happens and whats the workaround for that ?

Package
I'm trying to package my program but I don't know what dependancy I need to include.

inet1
timer
progressbar
commondialog
frame
imagebox
menu
commandbutton
combo1
sstab

How Do I Package The Exe?
I have never deployed a project into production before. It made it out of QA, but the dude that does that has Visual Studio on his machine. How do I package my exe so that it works on boxes that are running NT 4.0 workstation but don't have VB or Visual Studio on them? I know tha this is a real basic question and any help is really appreciated. Thanks.

Package
When I package my project into a single cab, I get four things in the folder. A folder called support, a zip file, a setup, and a word doc. I want to e-mail my program to someone, but I thought I was supposed to sent the zip file. I can unzip it, but when I run setup, I get "Invalid command line parameters" for an error. I can run the other setup that is not in the zip. How am I supposed to do this? What am I supposed to send, the setup and the zip. I thought I sent just the zip before and it worked, but not now. Any know what I am supposed to do?

Package
Hi All,
How to include an another setup file while creating a package in VB 6.0
Rgds,
Kalpana.

DLL 4 CD Key For Package
Hi there,

I am using Installshield Express 5.0 to make a package(Set up creation ).I want to provide a CD key...
for that ,in the 'Installation Designer' tab, under 'customer information' i have the following options-
serial number template
serial number validation
validation function
succes return value

I want the Cd key to be something as : AD34-AY23-XX26..
but have no idea as to how to create a DLL for that and to use it for this purpose...

This is very urgent for me...and i shall be highly indebted . if u can send across any code snippet for help..
any suggestion in this regard will be helpful...

thanking you all in anticipation

Regards

Package
<html><div style='background-color:'><DIV class=RTE>
<P>Hi,</P>
<P>I am trying to create a setup package for my application, but I get a message that tells me that a certain dll file (msstdfmt I think) has problems with it's dependencies. Still I can continue but in the end I cannot run the setup because of the same file. What do they mean by dependencies?Should I find this dll somewhere, is it broken?</P>
<P>Thanks, Roxy.</P>
<P><BR> </P></DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMBENUS/2734??PSG575">Exp ress yourself instantly with MSN Messenger! Download today - it's FREE!</a> </html>

DTS Package
Hi,

Can someone tell me if (and how) can I execute a DTS from a store procedure or, if this is not possible, how can I call (execute) a DTS from Visual Basic.

Other question... Is it possible, from Visual Basic to CREATE a DTS package in SQL Server?

Thank you,

Sergio Oliveira

DTS Package From VB
Hi,

I've created a VB package, and trying to run it from a VB project. Works fine on my PC with SQL Enterprise Manager installed, but not on another developers PC.

I've looked on t'internet, and TEK-TIPs and tried registering DLLs.

I've tried both ways in the code - creating a DTS Object

e.g. Set oPkg = CreateObject("DTS.Package")

and also executing a stored procedure which has the command to run a DTS Pckage

i.e Select @CommandLineVarChar = "DTSRun.exe /S XENAAS_P800_0010 /E /N RMBWST_FIN_COPY_TEST /R"

But neither work, and it doesnt give an error - even stepping through the source code doesnt help.

Any suggestions please as its driving me MAD!!!

Thanks in advance
Rob

About Vb Package
i wrote an application and used the package and deployment wizard in order to create an installation program ,

when trying to install it on the same computer the application was written in all goes smoothly , however , when trying to install the application on different computer , i get a message that the computer cannot locate the file ST6UNST.exe , and asks whether i want to find it my self , when i'm adding this file from the support package and locate it myself another message is shown and says that -
- c://docment and settins /administrator/local settings/temp/msftqws.pdw/st6unst.execannot be located , again.
after that the installation stops ,

does anyone have a clue what the problem is ?
my development flat is vb6 sp5 in windows xp sp2.
my app will be installed in windows xp and windows 2000 sp4.

by the way,i had packed the vb sp3 and sp5 in my development computer and desnation computer.

if someone have good suggestion ,u can give me a Email.
my email is sorcerer_mld@163.com

Thank everybody!!!

Package!!!!
Hi

I make a package for my App using the Package & Deployment Wizard from my machine (W200 Pro);

but when I tryed to run this Package on another machines (W2000 Pro) I got the error shown in the Pic, this error required to restart the machine; but also after restarting i got this error again and again

How can I resolve this ??!!!

Thanks

Package
Hi all,

I'm creating the install package with Package and Deployment Wizard from MS visual basic 6.0 and uder OS windows XP.
The install package is created correctly, but than it is not possible to install this package unde win2000. When I want to install this package under win2000 the warning is dissplayed:"System cannot continue because some system files are out of date in your system ...... "
Could you help me how to prepare correct install package?(with possibility install it under win2000)

Package
hi everyone ,i am using vb6 & datareport in my project . After creating package , i installed my project in another system ,i included all the files . when i run the report the following message is thrown.
"Failed to get rowset from data source"
can anyone tell me how to solve the problem

Edit: dries_neyrinck: moved to the VB6 databases section, it was located in the .NET section

Edited by - dries_neyrinck on 5/6/2005 5:08:55 AM

DTS Package

Hello allWhat is the best way to call a DTS Package saved in the SQL Server (SQL v.7.0 SP 4) from a VB (VB v. 6.0 SP 5) Application.

Hello all

What is the best way to call a DTS Package saved in the SQL Server (SQL v.
7.0 SP 4) from a VB (VB v. 6.0 SP 5) Application.