I have a SSIS package that runs every 5min.My package has an error routine in the onError event handler but I don't want it to get in there.So in fact, the package should just exit / close / kill itself without any warning or error.Preferably this should be initiated by the script task (vb.net 2008)
View 1 Replies
I want to convert the following vb.net script into C#.net script in SSIS Script task.I tried converting using Developer Fusion but iam getting lots of errors.
[Code]...
I have written a task script using vb.net that have thread used in the code, the problem is how i can know when will be finished all the threads so i can return the success result.
View 2 RepliesI have a variable called Valint that i need to read/write to in a script task, but it doesn't seem to work:
public class scriptmain
inherits usercomponent
dim counter as integer
dim Valint as integer
[code]....
For some reason my output is always 0
How can I kill the excel.exe process in SSIS during the data flow task when it fails? There could be multiple instances of Excel.exe running from other packages that are perfectly valid so I don't want to loop through all instances killing them.My problem is that during the data flow task the process will sometimes fail due to a sheet that is named incorrectly or missing columns. This keeps an instance of excel.exe running which is now an orphan task eating up resources so it needs to be killed.At the same time there are other SSIS packages running that are accessing their own excel.exe process and aren't having any issues. So how can I kill the orphan excel.exe process without impacting the other excel.exe process?
View 2 RepliesI am using a VB script in SSIS Script Task to add header and Trailer to a flat file. The code was working fine until recently i came across a problem where the rows in the file are more than usual and resulting in a failure on script task with error`Error:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
[Code]....
I am trying to create a datagrid and export the contents to a text file using VB.NET and I am doing this inside an SSIS script task in order to automate the process to export a dynamic table to text file. I don't get any error and the files are created but the files are empty. [code]
View 2 RepliesHow can I make this program not to give me the results for the quit command input of -999 but rather just to quit without the results?
Sub Main()
Dim TempIncelsius As Double
Dim TempInput As Double
Dim Formula As Double
[CODE]...
My 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 the index was out of bounds error for the following script. I have 1 input column and 11 output columns added to the SSIS Script component. The data types for all of them are string. Not sure where I am going wrong
Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
Dim strRow As String
Dim strColSeperator As String
[code].....
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?
So I have a little gui that will read a given spreadsheet and list all the "valid" sheets. This happens when a user presses a button.[code]...
View 17 RepliesI have an old Visual Basic 6.0 application. The program was compiled and ran as a schedule task. It creates the pdf files. When I look at the event viewer. It gives me this error message. The server {85DE1C45-2C66-101B-B02E-04021C009402} did not register with DCOM within the required timeout. The application id refers to adobe file. The schedule task never runs. This above error message showed up on the event viewer.
If I run the application by itself, it creates the pdf files with no problem. Any idea with this issue. I did a look up on this error. There is no solution for this issue that I came across on the web.
Here is the error I get when trying to debug my program: The "ResolveAssemblyReference" task failed unexpectedly.
System.IO.FileLoadException: The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)
[code].....
I have an external (3rd party) EXE which I start from my app, which reads data from the user and creates a corresponding registry key with the information, then exits. I then need to read those registry values from my main application.
I start the app with:
Process.Start(My.Computer.FileSystem.SpecialDirectories.Temp & "GatherInfo.exe")
I need to read those registry values AFTER that EXE has quit - so I know they've been created. At the moment I'm just making my main app sleep after that process has been started:
System.Threading.Thread.Sleep(1000)
And then checking for the reg values. I'm worried this won't work for different users however, as the speed of the computer will determine how long the process takes to start and exit.
is it guaranted that a task A started before TaskB will be completed before task B assuming the task do the same level of operatons?or in other words is there a chance that a task B will finish before tast A in the assumption that the task calls the same procedure?
View 4 RepliesMy program opens an excel file with excel.application's .visible=false. If the code is running and I manually open any excel file the excel file being used by code will then open up as well (making the .visible=false useless). Then at the end I use the excel.application's .quit to make sure that instance of excel quits, but it will quit every open instance of excel (even ones not opened by that code).Is there any way around this? to make sure it does not appear when other files are opened, and to make sure it only closes that one instance of the excel application.
View 4 RepliesSo i am writing something for work, and i was roaming the internet to see how to do it in vb.net, but it seems to really not have many hits. vb.net doesnt recognize Declare and all information points to things that say Private Declare Function [info]What i was wanting to do is to check if a computer has a DSN card in system DSN's, if it has it use the information and connect, otherwise, quit the program.
Do you know where i can find how to do this? I just need to check for the existance, i dont need to make them.All of my search results, while seemingly useful, were not written for vb.net I want to get something up here specifically for vb.net so we can get more search hits. i find more information, i will post it, but it doesnt seem to be going too far in the vb.net department, as it is in .net
I'm trying to create an excel file and load headers into the first row and then save the file to the local computer for later use. All of that works fine, but for some reason the "EXCEL" process won't quit. I have read through the tutorial written by Mike R and I have even tried just copying and pasting the code from the tutorial into my project, but to no avail. I should also note that I have not yet tried the "Extreme Measures" listed in the post, though at this point I am tempted to.
Code:
Dim ExcelApp As Excel.Application
Dim ExcelWorkBook As Excel.Workbook
[code]....
How I can quit the empty default text that appears in a comboBox when it is loaded?
View 3 Replies I got a form, another form, another form, another form, etc.And I got a quit form (Msgbox is not pretty)So, there starts a problem.I have two quit forms now, so that the user can pick the best one.The problem is that I don't know how the user can pick it. I have a quit button in Form3. I want SettingsForm have one label that says "Use the new quit dialog:" and two RadioButtons (which it has.) The Yes Radiobutton = Uses the new form, the no button uses the old one.Settings save the selection for the next session, etc.
RadioButton2 = Yes
RadioButton1 = No
Label = Use the new quit dialog
ButtonQuit = The Quit Button
This runs correctly, but Excel remains active after close.
If I don't create the range objects below, everything seems to work (with no output of course). Does anyone have any idea on how to keep Excel from staying in memory. Also... in the tests I'm running, I do not make the application visible.[code]...
I want to store some information of the form in such a way that if the user quit/exit the application it stores the information. When user runs the application next time the information should be available to him. It also involve the restart of the computer. The application is in vb.net 3.5 framework. The one way that i can think of using flat files and encrypted data, but i can not do this. I do not to store any kind of data on client side and I can not store this information on server side. The problem is of getting client machine information and storing it on server.
View 3 RepliesI 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 RepliesI Just want to know is is possible to execute a ssis package from vb.net application?If so how to do that???
View 3 RepliesI have a sql query that looks like this
SELECT SUM(A) AS expr1 FROM TREES WHERE (b = ?) AND (c = ?) and (d = ?)
How do I map the parameters? Since its a sum, I cant select multiple rows.
I am converting a DTS update lookup to an SSIS lookup with an update query. So far it doesn't seem to work.
OLD DTS ACTIVE X CODE:
value = DTSLookups("apple").Execute(DTSSource("ID2"))
SQL Query in DTS:
UPDATE TABLE1 SET STAMP="TEST" WHERE (ID = ?)
In SSIS:
Create a lookup, use same above query, and I get an error if I click on column: "Parameter information cannot be derived from SQL statements. Set parameter information before preparing command"
IS there anyway to accomplish this in SSIS with a lookup? Or is there a better way?
I made an SSIS (SQL Server Integration Services) package, and the first thing it does is to send email from a script task. I am using System.Net.Mail to send the email. The problem is that the email gets sent only the package is done executing and exits, but the package could take hours to complete. So, the idea was to send an email saying something like "package started", and when it's done sends another e-mail "package is done", but what actually happens is that I get 2 emails at the end of everything, "package started" and "package is done". So, how can I "release" the e-mail to send right away ?
Here is the code to send the email:
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Net.Mail
[Code] .....
In VB6 I used internet explorer object a lot. There things internet explorer object can do that webbrowser control cannot. For example, internet explorer object is easier to debug because when the application is in debug mode, internet explorer object is still interactive with client. Also we can clear cookies and resstart with internet explorer object. We can do ie.quit, then set ie=new internetexplorer then ie.visible=true
In vb.net internet explorer object becomes webbrowser control and I have no way to do that? How can I delete cookies and then restart webbrowser control? How can I tell webbrowser control to "quit" or destroy it self? That sort of thing.
Code
Class ApplicationTests
Shared Sub Main(ByVal args() As String)
' The variable pkg points to the location of the
' ExecuteProcess package sample installed with
[Code]...
