DTS Package Fails - Its Not Going Into The If Block
Nov 18, 2010I am getting one issue while working with DTS Package using VB.Net application. I am using the following code to execute the DTS package.
[Code]...
ADVERTISEMENT
Loading Output From Package Out Of A Local Package Error
Mar 24, 2010I am trying to run the application created in the example at [URL] The code errors at the line dtsDataReader = dtsCommand.ExecuteReader(CommandBehavior.Default)
the error is A requested parameter does not exist in the package. I have checked everything that i can think of in the package Also when I try to run the package using the dtexecui utility I two errors "Error: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW.
[Code]...
VB2010 Use An Application To Package All Files Together Into A Setup Package
Feb 26, 2011I am wanting to use an application to package all my files together into a setup package. I have tried InstallShield 2011, but when i click on Visual Basic .net wizard, it tells me I do not have Visual Studio.NET installed on my system. I am currently using VB2010 Express How can I fix this... or is there a better application available for packaging?
View 2 RepliesRun 2008 SSIS Package - Click A Button And Have A SSIS Package Execute?
Apr 14, 2011I created a simple VB application in Visual Studio 2010.My computer, which I am using to create the program, is Windows 7 Pro, and SQL Server 2008 is running on a Windows Server 2008 Enterprise, which I have full access to.
I want to click a button and have an SSIS package execute.I looked around on the Internet and found examples, but they do not seem to work for me.I try to add a reference, Microsoft.SqlServer.ManagedDTS.dll, as a few sites advise, but it is not listed when I go to PROJECT>ADD REFERENCE.
I also type:
Imports Microsoft.SqlServer.Dts.Runtime but all I get is a squiggly green line, which when hovered over states "Namespace or type specified in the Imports 'Microsoft.SqlServer .Dts.Runtime' doesn't contain any public member or cannot be found." Below is some code I copied from one of the websites and pasted in my button click event (the path is correct), but a get blue squiggly lines under "Package" and "DTSExecResult":
Dim pkgLocation
As String
Dim pkg As
New Package[code]....
What can I do to make the SSIS package run when I click the button on the Windows application a created?
Can't Run My MSI Package
Apr 16, 2010I have a Visual Studio 2005 project. Formerly, all our PC's and servers were 32-bit but we have rearchitected everything and purchased new hardware and we are running 64-bit servers. Here is my scenario. I would like to convert my 2005 project to 2008, maybe that will solve all my problems, if you think so tell me and I will concentrate on that. But when I tried to convert the project via the Conversion Wizard, I got 102 compiler errors and I think there would be more but that was the max. So I gave in and just worked on it in VS2005 on a 32-bit machine. The solution consists of five projects, one is a web program, one is a windows service, one is a library and the other two are install programs - one for the web program, one for the windows service. I want to install the Windows Service on a test machine which is 64-bit. When I tried to run setup.exe on that machine, I got this error:MsiInstallProduct returned '1638'
View 2 Replies[02 / 03] Can't Even Package?
Jan 28, 2009I am basically an EAI consultant and for my work I took an initiative to develop a windows based GUI whose functionaility would be to simply execute a couple of Oracle SELECT queries and display the results in the form. I took the help of my friend who is a VB.NET expert and he was kind enough to develop the complete code for me within a day (He isn't available now).
[Code]...
App To Package An Application?
Aug 10, 2009Is it possible to create an app. that collects info from the user, writes that info to a file then package another app with the file bundled with it.
View 1 RepliesCan't Package DLL And Ship With App
Apr 14, 2011I need a DLL to be available to my app at runtime but the app has to be standalone with no installer so I can't package the DLL and ship with the app.I am using the technique discussed in this thread: url..That works perfectly. My problem is that I need to do the same thing with an additional DLL and I can't figure out how to do it. It would be easy enough to create a "stream2" and a "raw2" but how do I return both of them from the function? Or how do I only return the one that is needed at the time?
View 6 RepliesDeployment - Can't Even Package
Jan 28, 2009I am basically an EAI consultant and for my work I took an initiative to develop a windows based GUI whose functionality would be to simply execute a couple of Oracle SELECT queries and display the results in the form. I took the help of my friend who is a VB.NET expert and he was kind enough to develop the complete code for me within a day (He isn't available now). The application did work fine and we tried to package into an MSI using the Deployment & Packaging Project option. Now when I installed the application on a different computer, it throws OraOps10.dll not found ! I also tried the Setup Wizard from the same Deployment & Packaging Project option but it results in the same error.
Please note the following:
-> We used .NET 1.1 and the backend database is Oracle 10g.
-> We downloaded the Oracle Data Access components for .NET from Oracle's website. The DLL file in the error message actually came with this installation.
When I am packaging the solution, I expected all the dependencies including this OraOps10.dll should have also been packaged. What could go wrong here? I don't think I can request my customer to install the Oracle Data Access components for .NET, in this case we don't even need a packaging feature. I would be grateful to you guys if this silly issue is fixed very soon.
How To Run DTS Package In VB 2005
Oct 9, 2008I created a DTS Package for SQL Server 2000. I named this as DTS_Attendance. How will I run this using VB.NET 2005? What are the references I need to add?
View 6 RepliesPackage And Deployment
Dec 10, 2010how to package and deploy vb.net application.
View 1 RepliesPackage VS VB To Single Exe?
Mar 16, 2009Please provide any affordable solution for packaging a VS 2008 deploy to a single *.exe.
If the solution also encapsulates and protect viewing then all the better.
.Net Integration In Install Package
Aug 6, 2010I was wondering if it is possible to bundle a .net framework client runtime (.net framework 4 to be exact). Because not many computers have .net framework 4 Installed and i don't want them to download from the microsoft site. As i checked the program itself is a redistributable package <link>. Now the problem comes how do i integrate this into my own installer so that instead of asking for a download it would just ask to install the framework and then install from the setup that will be included in the package. I am using a standard setup project. Using VS 2010 Pro.
View 1 RepliesExecute A DTS Package From VB Application?
Apr 3, 2009The DBA has created a DTS package to update a SQL Server 2000 table. We have a VB .NET 2008 application that needs to execute this package. We thought that having the application execute a stored procedure to do this would suffice; however, we are exploring a way to execute the DTS package programatically.
View 1 RepliesExecuting A Ssis Package?
Mar 8, 2010I created a ssis package in visual studio 2005. I want to execute the package from vb.net code. How can this be done?
View 1 RepliesExecution Of SSIS Package?
Sep 20, 2010I Just want to know is is possible to execute a ssis package from vb.net application?If so how to do that???
View 3 RepliesLaunch SQL Server Package From 2.0 App?
Mar 12, 2010Is it possible to kick-off a SQL Server package from a VB.NET 2.0 app? Can a VB app talk to SQL Server - other than what is built into the ADO.NET API?
View 2 RepliesMaking A Debian Package?
Jun 8, 2011I am trying to make a debian package in windows. I have been searching for a few days and havent found much. Is there a way to make debian packages in vb.net/c#? is it possible with cygwin or msys?
View 14 RepliesOpenGl Graphics Package - How To Use In .net
Jan 31, 2009i want to do a graphics project in Vb.net but have to use OpenGl Libraries . How do i download compatible OpenGl package and how to use them in my .net code.
View 3 RepliesPackage Mdb File In Installer?
May 13, 2009I have a finished application that is ready to be delivered to my client, I am looking for an efficient way to add my database file (i.e. .mdb file) into the installer package, thats one thing..another thing is that how can I customise the installer package to always put that .mdb in the D: drive during installation..
View 3 RepliesPassword Protect A Zip Package?
Jun 7, 2010How do you password protect a zip package?
View 6 RepliesRe-download The Whole Package And Install It?
Jan 26, 2010I'm getting a new computer, and I want to keep VS 2005 instead of upgrading because:
- I don't want to have to upgrade all 143 of my projects.
- I don't like the way VS 2008 looks.
- VS 2010 is just slow to the point of absurdity.
- I don't want to have to re-download the whole package and install it, which took about 4 hours for VS 2008, 10 hours for VS 2010.
Is there a way to just copy everything over? It's Express Edition. Also, would the old setup file work, or is support for VS 2005 completely gone?
VS 2008 .net 2.0 Needs To Be In Package To Install
Oct 29, 2009This is not for a class. I would like to know if anyone has information to use the bootstrapper from MS or how to include MS DotnetFix.exe in an application to install onto a computer that does not have it. Also is this possible for mobile devices if the application would need to be packaged for them also?
View 4 RepliesVS 2010 Installer Package?
Dec 22, 2011I have written a program in vb.net with mysql database.Now, my question is how can I add the mysql installation along with the query to create the database that my program is using? I wanted to include .net framework also in the installation.
View 1 RepliesWay To Package A Vb6 Hybrid Application?
Jun 15, 2011I've been working on a project for my company that's completely implemented in VB6. However, we've been transitioning small parts of it over into VB.NET (v4.0). Previously, we would simply use the Package and Deployment Wizard to bundle everything up into a single setup executable, but I'm not confident that it will be enough this time. If it can, we'd like for the setup to check if the .NET framework is installed on the target machine and then install it if it is not, which I'm pretty sure Package and Deployment Wizard cannot do.
I've been reading up on INNO scripting since it seems an appropriate alternative for packaging both VB.NET and VB6 projects, but it has a lot of warnings about including the wrong or unnecessary dll files. I'm a complete noob and this doesn't instill a great deal of confidence in me. I don't want our customers to run our installer and have their computers crash as a direct result.I've been doing my own research (apologies in advance if this question has already been asked, I didn't see any relevant threads)
[2008] Add More Then One Exe In One Setup Package?
Jan 23, 2009I finished an important project (Visual Studio 2008 Professional Edition) and now I have to deliver it with an appropriate installation program. My product is composed by a lot of projects and each of them generates an exe file with its images, help, xml , database etc. A main exe calls a sub exe for the work it has to do passing appropriate parameters. I think is not suitable to use a click-once feature and I have looked for the deployment wizard but I didn�t found a complete documentation and moreover some example step by step.where can I find that documentation, tutorial and example ? It�s possible to customize the forms generated by the wizard ?
View 8 RepliesAccounting Package - How To Copy Database
Jan 13, 2009I am developing an accounting package. I am using vb.net 2008 and access. I have a database named blank.mdb in the current folder which is the basic data needed. Now what I want is whenever a user creates a new company. I want this blank.mdb to be copied as Company?.mdb ? represents 1 or 2 or 10 as the case may b ...standing for the no. of company. E.g. if there r already 10 companies created then the blank.mdb should b copied in the current folder as Company11.mdb. How to copy the database. I have a few basic data in the blank.mdb and want that to be copied too.
View 3 RepliesBest Free Setup And Deployment Package For .NET?
Jan 8, 2010What do you think is the best free setup and deployment package for VB.NET? Which is easiest to use?
View 4 RepliesC# - Error Handling In DTS Package Execution Using .NET
Oct 20, 2010I am executing a SQL Server 2000 DTS package using C# by following the code from this article [URL]. once the package is executed I am looping through each step to find out if any step has failed and get info about error if it has failed. I also use this information to find out if the package has succeeded or not (package failed if anyone step has failed).
[Code]....
Calculating Shipping Cost For Package?
Jun 15, 2012I am creating a code for a school project that calculates the shipping cost for a package. In this program the user enters the weight of the package ( in pounds ) and selects the destination of the package. The application with determine the cost of the shipping. The destination of the package can be the US continental, Hawaii or Alaska. If the package is going to Hawaii a 20% surcharge is added to the shipping cost. If the package is going to Alaska, a 26% surcharge is added the shipping cost.
This is my code thus far. When applying my weight in pounds and selecting the destination I still keep getting 0.0 for the total.
Public Class Form1
Private Sub textboxpounds_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles textboxpounds.TextChanged
End Sub
Private Sub ListBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)[Code] .....
Here is a screenshot of the GUI
Uploaded with ImageShack.us
