I want to put a process in a SSIS package that will rebuild a solution. In that solution it creates a setup.exe that includes a sql server compact database that is updated by the SSIS package.
View 2 RepliesI 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?
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 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 RepliesVS2008 SP1, Winforms solution, VB.NET, compiling for x86 and .NET v2 I have about a dozen projects in the solution, with a couple of Windows forms projects and some class libraries. If I rebuild the solution, it clears out and recompiles all the projects, as you'd expect... and then disappears without trace or error message. Since I'm reconnecting to VSS 2005 over HTTP across the internet, it takes all month to start back up with everything loaded, so it's incredibly irritating. The compiled application itself works fine, and normal build and run after changes also works fine.
EDIT: Just to clarify, No add-ins except Refactor! (I know, I guess I ought to try uninstalling it to see if it's that, but it's just too useful! - I will see if there's an update though). And no custom build steps. It's just a vanilla Winforms app, with references between the projects (and some references to COM dlls for interop).
[Code]....
I 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 am trying to run a ssis package from visual basic 2005.the package was created with the import export wizard in SQL Server Business Intelligence Studio in SQL server 2005 I get this error
Assertion Failed:Abort=Quit, Retry=Debug, Ignore=Continue
at STrace.ReadTraceValues()
at STrace..cctor()
[code]....
I built a simple package using the export wizard in BIDS. The package just exports data from a table to a csv file I added the reference Microsoft.SqlServer.ManagedDTS.
I also added Microsoft.SqlServer.dtsruntimewrap. Run I run the package in BIDS it works fine but when I try to execute from vb 2008 ..the file is never written. Here is the vb code I am using ssis sql server 2005
Imports Microsoft.SqlServer.Dts.Runtime
Public Class Form1
[code].....
I've had to backwards convert my SSIS 2008 package to 2005 including converting all the C# script tasks to VB. After finishing this and getting it to run fine from Visual Studio, I went to deploy it to the server but when I import the package through SSIS into the 'File System' I get the following error:[code]Now when I open the package file up and go to that line this is what I have:[code]
View 1 RepliesI have created an SSISpackage in my asp.net project.To call the ssis package, i have written the following code.
dim app as new Application()
dim package as Package=app.LoadPackage("C:ProjectsMyPackage.dtsx")
dim result as DTSExeResult=package.Execute()
Response.Write(result.Tostring())
but it shows some errors.i think some namespaces are missing.What all namespaces have to be imported?
I have successfully run an ssis package and inserted data from one table in the first database to another table in the second database. But all the rows are inserted in this case. I have placed an oledb source control, a character map control and an oledb destination control. No query is written in this. I specified only the source table and the destination table in the 2 databases. But I need to transfer only some column values in one table to another, not the entire table data.
View 1 RepliesI am currently working on an SSIS package that we are migrating from SSIS 2005 to SSIS 2008. The issue is that the developers of the current version used the fact that in SSIS 2005 the accessor of a NULL column returns 0, whereas SSIS 2008 throws an exception. Also, they extensively use expressions such as this one:
IIf(Row.X_IsNull, System.DBNull.Value, Row.X)
The problem is that in SSIS 2008, regardless of whether the condition is set to true, the program still tries to read Row.X and throws an exception. The package is big and it would take a very long time to convert all of these IIfs to manual Ifs with temporary variables.
i am writing a VB front end (VS 2008 .NET 3.5) to a data loading program that involves moving the contents of CSV flat files into SQL Server 2005 staging tables. I have had some experience with DTS in SQL 2000 so I decided to use SSIS packages to load the CSV data. Creating the packages in BIDS worked fine for the development environment where I hard-coded the Connections and file paths. The problem arises when I will release this program to 30 different sites that do not have SQL Server admins to help changing the configuration.
I have a SQL table in which I will put all the necessary path information and I can pull that into the VB program on startup. I need to see an example of how I can set the properties from VB once the package is instantiated and opened.Here is an example of where I plan to set those properties and run the packages.
Private Function RunPackages() As Boolean
Try
Dim oApp As New Application
Dim oPackage As New Package
[code]....
Even though I am using a configuration file in the example, I am finding it difficult to edit the configuration files for each site. I see that there are methods and properties exposed for the oPackage instance. However, I can't find a good reference for the Class model to use as a guideline. All the examples expect packages to be run and configured with SQL Server and BIDS. direct manipulation of package properties in VB or C#?I am now considering using the old standby SQL Bulk Insert. It almost appears as if the Data Tasks are just wrappers for the Bulk Insert operation. Furthermore we have several sites still using SQL Server 2000. With the economy the way it is, most of those sites do not want to spend ANY extra money upgrading to SQL 2005 or 2008.
However, having a good resource to learn how to manipulate SSIS packages from the CLR would be very helpful. I have heard that in SQL 2008 things have changed even more. It is maddeneing that once I learn a "new" Microsoft technology it seems to be discarded by MS in their next release in favor of a "better" alternative.
I am using SSIS Package to Load Daily a file of 8GBs. If the free Disk Space is more than 100GBs.. Everything goes fine. Problem Starts when we have less free Disk Space. I tried to Load a 8GB file with 60 GB Free Disk Space it Inserted 1658 records,Then I deleted SQL Logs and made space more than 100GBs free. For same file it inserted 60,000 records. I am not able to Understand how it happened and It have happened many times.
View 1 RepliesI am using VB.NET 2002 and we have set up a test environment running SQL Server 2005. I am trying to add a reference to Microsoft.SQLServer.ManagedDTS.dll which is required to run a DTS/SSIS package from VB.NET. However the dll does not show in my add reference listing so when I select BROWSE and select the actual DLL I get a rather long error message telling me that only 'dll' and COM components can be referenced.
The exact message is: A reference to 'C:Programs FilesMicrosoft SQL Server90SDKAssembliesMicrosoft.SQLServer.ManagedDTS.dll' could not be added. This is not a valid assembly or COM component. Only assemblies with extension 'dll' and COM components can be referenced.make sure that the file is accessible, and that it is a valid assembly or COM component.
When i try to run a msi using System.Process.Start("test.msi") in a vb app i get the following error. The installation package could not be opened. Contact application vendor. Msi file works fine when double clicked, tried System.Process.Start with text files and exe files and they work fine, problem only with msi files. Running vista. Also tried xp but no luck.
View 2 RepliesI 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]...
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 Repliesi am still new to VB, and need a little help. We have an application that runs on what I believe is VB2005. I am able to open the main .dll in VB2010, and can modify the forms, etc, and they will show the changes in the applications, but is there any way to change the current forms to the nicer looking forms in VB 2010? I guess I could just rebuild the entire .dll in the new version, but was hoping not to have to do that.
View 3 RepliesUsing VB 2008 When I press the F5 or Start Debugging it does a rebuild even when I have made no changes since the last time. Where is the setting to tell it to only do a rebuild if there are changes?
View 3 RepliesI have an add-in that does operations to open projects in the current solution. Before I do any of those operation, I want to verify if I need to build the projects or now. Is there a way I can check if a project is out of date (Up-To-Date = True)?
View 1 RepliesI have a vb .net program on visual studio 2005. I modified my code for a bug fix. When I am rebuilding and running the application, it shows me the old version of my program, ie, the new changes are not taken effect. To test more, I changed a Label box text and tried to rebuild the program. The program shown me the screen with the old label text. The change was not affected. I tryed to save the application, close, reopen , unfortunately the same effect. Then I copied the project folder to my other laptop to see if visual studio had anything wrong. But then there also I am facing the same problem.
[Code]....
Here is the code
Dim xR() As DataRow = xT.Select("TS='" & TS & "'")
Dim qRow As DataRow
If xR.Length = 1 Then
qRow = xR(0)
[Code] .....
Sometimes(not always) I get that internal index is corrupted. I read somewhere that frequent updates to in memory datatable, can produce error like that and that only real solution is to create dataview from time to time, and by doing that datatable rebuild it's indexes...is that for real....I have changed my code and now I'm creating dataview and disposing it right away...so far so good. but I was wandering is thatfact....does datatble rebuilds it's indexes when you create dataview...and if not when are they rebuild.
I recently inherited a VB project for some maintenance. I've been making changes and testing in VS2008 using F5. It's been going well.I did a rebuild all and now it won't run. It displays a dialog saying something like "MSACAL.dll or some of its dependencies are missing." There are a number of INTEROP.....dll files in ..obj (I didn't look in ..in and am home for the weekend) but none in ..objDebug.
View 1 RepliesAnyone ever get fake compile errors and rebuild the program and then they go away? Well mine aren't going away and I can compile and run no problem. I've got something like 100 compile errors and the "run with error's" warning doesn't appear at any time and when I do run my program it runs just the way it should. However I still see like 100 errors.
View 4 RepliesI am writing a custom control which is a textbox currency control. What is the best way if I make changes to my control to have my main project use the changed control?
View 9 RepliesI changed config file of the windows many times. Before changing config file I stopped the service and after changing config file, started again. Every thing worked fine.
But last time when I made some changes in config file of the windows service and started it - It didnt worked, I even tried reinstalling the service but in vain.
As a last resort I rebuild the service with new config file and copied newly build files on the server and installed the service. To my surprise the Windows service worked perfectly this time.But I have only made changes to config file and the code of the windows service was untouched. My question is, do we need to rebuild the Window service if we change the config file many time?
I would like to get some advise from all of you. I created a program setup using standard procedure(adding new project.. setup and deployment, setup project). When I ran the setup and installed the program in computer, It's working. Then I decided to amend certain form in the program. I right click at solution"my program name" and click rebuild solution. then i try to run again the setup, there is nothing happen after that(It remain like before amendment). Did I miss anything here? I have never used this method before and this is my first time using it.
View 3 RepliesI have been working on a number of card games. Important, of course, is shuffling the deck.I have come up with a few different ways to do this. Currently I do not shuffle, but to deal a card, I lay out the deck in order, selecting a random number between 1 and the number of cards remaining and selecting that card. I then remove that card from the deck so that another card can be picked.There are two main ways to do this, and I am trying to figure out which one is optimal.The first is to have an array of cards. When one card is dealt, a new array is formed with that card missing. I kind of like keeping the array size exactly the size of the deck, but perhaps this is not efficient. So, the first array has length n and the new array after the card is dealt has length n-1. VB.Net makes it simple to change array sizes around like this.
View 1 Replies