The 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 RepliesI want to execute a ssis package from vb.net application.I am getting the following error while calling a ssis package from vb.net application. The specified package could not be loaded from the SQL Server database ssis package is working fine from BIDS as well as from SQL Server Management Studio (SSMS).Package is deployed to the File System of SSMS.I am using the following code.
Code:
app.LoadFromSqlServer("\MData_import", "70.50.30.891SQL2005", Nothing, Nothing, Nothing) where app is the Microsoft.SqlServer.Dts.Runtime.Application object and MData_import is the package name.There is no password set for the package.
I 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?
I 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 RepliesWhat is the appropriate way to do this?
View 2 RepliesIs 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 RepliesI'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)
I 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]...
how to create package file in vb.net window application
View 2 Repliesi am about develop an application and i want to do the following.
1. use vb.net 2008 for the application
2. use mysql database as the database for the application
Question:
1. is it possible to package the application by adding the mysql database so that during deployment it will be installed as well eg. vb.net 2008 and access database can be attached and deployed without installing any file to support
I completed an application in vb.net and i'm using sql server 2005 as database engine.Now I want to create a software package for this application.But the problem is that how can I include the database within this package,I'm also using a crystal report viewer.ie, How can I install this application to a system that doesn't have sql server?.
View 1 RepliesI have created a windows application which Installs Multiple MSI's based on some condition. The project is created in Visual Studio 2008 with .Net framework 3.5; If this application runs in a machine which has atleast Dot Net 2.0 installs, it works fine. but the system without framework 2.0 throws an error "The application failed to initialize properly (0xc0000135)"
How can I stop my application from crashing. I tried giving a check in the Main(), but it is not even firing the Main(); Is there any way I can give a prerequisite, But not in the Publish, Coz i am using the output exe and not the clickonce output..
I've developed a database application in VB.Net 2010 Express and published a ClickOnce deployment package, the only choice in the Express version. The installation is supposed to create a listing on the Start menu but this isn't happening. Also, I'm using a specialized Hebrew font in the application that is not carrying over to the installation. what I'm doing wrong or if the ClickOnce publishing method is not capable of working in this way?
View 2 RepliesI am using a 3rd party dll in an application and the installer does not register the component irrespective of any settings in the install package.It will register manually though using regsrv32 after installation.My question is how can I use the System. Diagnostics. Process.Start("cmd.exe")function to call the regsvr32 with the dll name after installation from the install package, also the correct syntax for referencing the installation folser if the user amends it on install so that it doesn't fail on execution because of spaces.Dim stRegPath as String= "regsvr32 & "" & Path.GetDirectoryName (Assembly. GetExecutingAssembly().Location) & "rogue.dll".
View 3 RepliesNot in the Debug directory or any directory, I actually mean within my program Is there a way to add the exe to the My.Resources or something similar and execute the application that is stored within my application. I have tried to do a Process.Start(Myexe'sName), but I have a feeling that looks for an exe outside the actual program, directory
View 8 RepliesHow can I add an .exe to my resources and execute it within my code? Or atleast have that program compile with my project and be able to execute it?
View 5 RepliesI have to execute the command line program takeown.exe[url]...
from my console application, I've tried this cose but received no output and the program does nothing[code]...
I have created a Windows application (in VB .NET). Now I want it to run from Console too.However, when i run it from console, i don't want to should the windows forms and also want to run some specific tasks.
View 1 RepliesSo basically my VB project creates a text file that is readable by another console application (not made in VB). Basically what I want to do is in my program, I want it so that when you press a button, it will run all of the text files (that you made in my program) through that console app (the console app takes XML files and converts it into another format). How can I do this? In the console app, you type in the file name (ex. File.xml) and press enter and it will give you the output file. How do I "call" a console app and have it run in the background? (background as in the prompt window doesn't pop up.)
View 3 RepliesI'm building an application that will be using several (7) SQL queries, I'm wondering whats the best way to approach this since I've never built an app with this many queries in it. These queries really won't change, just the start date and end date and I have query in my first form that finds out the next available date by checking a table. What I'm wondering is if it would be better to construct these queries in my application or if it would be better to use stored procedures on my sql server to do the same thing and not have the application carry the load of the queries.
View 1 Replieshow you start (execute) an application.
View 3 RepliesMy DBA has several SSIS packages that he would like the functionality of providing the end user with a way to input values for variables in the package. What would be the best solution for creating an application that would take the user input and pass the data through to the SSIS package variables?
I can get this work locally using this code
Dim packageName As String
Dim myPackage As Package
Dim integrationServices As New Application
[code]....
Problem is this requires that the user have SSIS installed locally.
I am having an issue with an ASP.Net page I am writing and struggling to diagnose why this page is failing.
I am trying to do this:
Dim st As New StringWriter()
Dim strURL As String = "CourseProgramme.aspx?id=3733"
Context.Server.Execute(strURL, st)
txtNotes.Text = st.ToString()
The aim here is to get the HTML back for the page that has been specified in strURL and then display it in a textbox. However when I run this code it crashes the ApplicationPool in IIS and when I look in event viewer I see this error message:
A process serving application pool 'blueprintdev' suffered a fatal communication error with the Windows Process Activation Service. The process id was '5284'. The data field contains the error number.The strange thing here is that in another page I do this code which works fine:
Dim strDutyStartDate As Date
strDutyStartDate = TextboxDutyStartDate.Text
Dim st As New StringWriter()
[code]....
As far as I can see other than the URL I am passing, which does exist, I cannot see a difference between the two.The page I am developing is in ASP.Net with .Net 4.0 however in the website there are some classic ASP pages. IIS is running at version 7.5.7600.16385 on Windows Server 2008 R2 64Bit.So far I have tried setting the application pool to run in 32bit mode but that causes errors in other areas and the site will not load.
I'd rather not go into the detail of the problem, because it's a lot of typing... but the functionality of vb.net (when making a web application) is quite annoying.
This is what it does...Page1.aspx loads, then you push a button on the page, and that button then does this: Response.redirect("Page2.aspx")
But first, it does Page1's load event, then it does the btn.Click event, THEN it does Page2.aspx's load event... Is there a way to force it to not do Page1's load event, and just make it execute the button click, and the page2's load event?
[Code]...
how can i get this code to return all values instead of just the first value ?
I 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 RepliesI 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]...
I 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 RepliesI 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.
I 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 Replies