Sql - SSIS Lookup With Update Possible?
Sep 16, 2011
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?
View 1 Replies
ADVERTISEMENT
Dec 4, 2009
I 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.
View 20 Replies
Oct 20, 2009
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 Replies
Aug 23, 2011
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.
View 1 Replies
Apr 14, 2011
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?
View 8 Replies
Feb 19, 2009
I have a datagridviewcomboboxcolumn which has its .DataPropertyName set to a int field, its .DisplayMember set to a nvarchar field and its .ValueMember set to a int field on a lookup table. I have captured a dataerror which states that the control is trying to push the .DisplayMember(nvarchar) to the .DataPropertyName(int) field. When I load existing data it works fine. When I try to leave the datagridviewcomboboxcolumn after selecting a different value in it or leave it when I add a new row, I get the error. What am I doing wrong?
View 1 Replies
Jan 12, 2011
Simple Code lookup to get Description I have a static list of Street Type Abbreviations and their associated Street Type Descriptions: RD to Road. I have the complete list needed. There are 37 elements in the list - 37 Street Type Abbreviations with their associated Descriptions. The lookup will only happen once. The input lookup field is in a single field: stType.
[Code]...
View 2 Replies
Mar 14, 2012
i am using the LookupEdit control from DevExpress fairly heavily in my projects. It is like a combobox, but it is bound to a datasource and can display multiple columns from the datasource. A single column is identified as the "value" column and a single column is identified as the "Display" column.
I use the LookupEdit control on my forms to give users a pick-list of appropriate values for a particulat database field. Each field has its own table in the database holding said values, commonly referred to as a lookup table, and each lookup table is used as the datasource for each paired LookupEdit control. Of course when a form is being filled-in by the user this works great. And it works good when the user opens a saved record into the form and I set the EditValue of the LookupEdit based on the value stored in the database. Pretty basic stuff right?
Now here is the problem... Let's say a lookup value is no longer an appropriate entry and so it is removed from the lookup table. Say I sell cars and one of the fields in the Cars table is Color. And I have a lookup table called CarColors and the selections are: Black, White, Red, and Silver. Now let's say we sold some Red cars in the past, but now we no longer carry Red as an option and we probably never will. So I remove "Red" from my lookup table, and now when I load an old Order into my form the LookupEdit for Car Color value now shows NULL. What is the best way to handle this situation? ProcessNewValue? Set NullText property? Use a bit field in my lookup table for IsActive, and set to FALSE for Red instead of deleting it?
Obviuosly I want to retain the historical values while maintaining a currently valid lookup list. And I know this question goes deeper as there are probably database design considerations like whether or not to put a constraint on the foreign key relationship between the lookup and child table, etc... I should also mentioin I am using LookupEdit control rather than a ComboBox becasue a lot of my lookups have other information like Description, Sort Order, or are coded and thus require a multiple column display.
View 1 Replies
Feb 20, 2012
I have a datagridview control on a form that is filled programatically (dataadapter, dataset ) from a database table (access).
Some of the columns in this table are foreign keys to other tables. Is it possible to have these
columns as combo box columns so the values can be selected directly from the other tables?
View 3 Replies
Jul 16, 2009
I have an Access 2003/2007 application that pulls computer names from my network along with their last know TCPIP address. This data is created by another application. I am trying to use the IP Adresses to install software via a push application that accepts a list of IP Addresses.My app has a history table of every comuter that has been checked to see if the software is installed. I use the Fully Qualified Domain Name to make this verification. I then populate my text file with the IP address of the computers that have not been installed.This all works well if the last know IP address is still valid for that computer.What I am trying to find is a function that I can pass the FQDN to and have it do a NetBios lookup to return the current IP Address from our DNS Servers so I can be sure that the IP addresses I am populating the text file with match the FQDNs of the computers I am trying to push the software to.I found some info on System.Managment.dll. For some reason Access will not let me add it to my library references.Does anyone know of a standard library function I can use to achive this.[code]
View 2 Replies
Oct 19, 2009
I am trying to setup a macro to lookup a value. Its very basic, I am trying setup a sheet to build tariff requests for mobile phone deals. so on sheet i will have lots of macro boxes that simply pubulate a table with a value on sheet 2.
Its basically so a sales person can go onto the excel sheet click click click and it will produce a table of all the product on each mobile number connection.
View 1 Replies
Aug 11, 2010
in item Search form i can search the item that i want, if i found the item that i need i will select the entire row and fill this row in DataGridView in frmSWSfromGrid.i been able to achieved this same scenario but it uses textboxes.the ff. COde
frm Dialog code
Public Property DepartmentID() As String
Get
[code].....
View 2 Replies
Apr 8, 2009
I am almost finished building my application. All the data need is being inputted from various locations. I have a form that is suppose to consolidate all this data into a specific format. There are 47 fields that have to be populated and/or calculated based on two fields, the Username and a date range (this part is done). I was trying to set each of the TextBoxes equal to the SQLCommand that would return the proper value, but i am not calling it correctly. Would somebody please take look, is there something i am missing, do i need to write it in a function? I have had to use the Select statement itself in a couple of filters so I'm pretty sure that is correct, but i need help getting it to run the sqlcommand.[code]
View 16 Replies
Dec 29, 2008
I'm creating a Macro for reporting purposes and trying to create a formula that will look at a prior days report, save it out, and work off of that one.
View 2 Replies
May 17, 2011
i am using a third party tool "lookupedit control" which is similar to a combobox. as we type in the address bar of our browser we get the related items in the dropdown of the address bar. eg: if e type go we get all the items starting from go in the drop down of the address bar. I want to implement the same functionality for lookupedit or a combobox.
View 1 Replies
Sep 15, 2011
I need some advice I have a bound datagrid and a bound combobox lookup on a form. What i want to do is filter the combo box so it only shows the items left that are not in the datagrid already.
I have managed to achieve this already.But when the program runs, and there are items displayed in the data grid the combo box items are now filtered.The program crashes as it can't display the combobox item as i have filtered them out. The program runs fine if the datagrid is empty (IE combobox items not filtered). But as soon as there is a record in the datagrid when i save the database and refresh the combo box the program falls over is the items it is looking for is not in the combo box items list.
What would a work around be. I have thought of a separate combo box that is hidden and use the datagrid combobox events to show it in the correct position.Just to be tedious the displayed item is not the stored item value
View 5 Replies
Jun 5, 2009
I am trying to setup a lookup combo box in my web page. I was using a linq data source but I then moved my linqtosql code to it's own class library for my DAL dll (took out of app_code folder). So, I am converting the page code to be able to still have lookups driven now by a biz object.Here's what I have done in my biz layer...
Public Class KosherTypes
Public Shared Function GetKosherTypes() As List(Of KosherTypeLookup)
Dim db As New DBDataContext
[code]....
I then setup an object data source and mapped it to this class.I have a few questions as when I was doing internet searches I didn't find anyone that seemed to be doing this and yet I know lookup tables / combo boxes are common...I went with returning a list but I could have returned an IEnumerable or IQueryable. In my reading it seemed IQueryable had more functionality for linq to sql but since I am returning a simple two column list then I only need to return an IEnumerable or List. I went with a List since it's strongly typed.
View 1 Replies
Jun 29, 2009
I have a Person.Profile table with columns like
PersonType (Student, Employee)
____ (Male, Female)
MaritalStatus (Single, Married, Widow, Separated)
[code].....
View 3 Replies
Jun 11, 2011
Simple Code lookup to get Description I have a static list of Street Type Abbreviations and their associated Street Type Descriptions: RD to Road. I have the complete list needed. There are 37 elements in the list - 37 Street Type Abbreviations with their associated Descriptions. The lookup will only happen once. The input lookup field is in a single field: stType. Not trying to get fancy. but what is the best approach? Dictionary, List, two dimensional array, etc. Started with Dictionary but the .Add was getting redundant. Two dimensional array let me initialize the values, but searching an old school loop.
View 1 Replies
Mar 8, 2010
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 Replies
Sep 20, 2010
I Just want to know is is possible to execute a ssis package from vb.net application?If so how to do that???
View 3 Replies
Jan 29, 2009
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] .....
View 1 Replies
Jul 28, 2010
I'm using VB.NET but any other known language should be fine as long as it uses basic features. My task is to create astrological compatibility chart, when two users have certain astrological sign as inputs and there is a text about those signs compatibility. for those who are unaware of astrological signs but still want to help, there are 12 signs. Each sign has different compatibility with other sign or itself. So basically i get into 12^2-12 conditions. ie. Aries with Cancer "do not match at all" so I can save one record of that issue as backwards it is the same (thus -12 at the end). Question is simple is there any other way to create this except of using 12^2-12 case issues...
[Code]...
View 3 Replies
Aug 22, 2009
I have a form with labels that have databindings on them from an access database .. im using vb 2008 .. and i have a search query and a next button on the form displays when the currency manager count is greater than 1, to be able to display the next set of data.. now the problem i am having is that when i click the next button, its not changing any of the data in the labels on the form .. i have no clue why it isnt working, im for sure the code i am using is correct, i've tried for hours and cannot figure out where the problem is..
here is the code that i am using
Dim currManager As CurrencyManager
Private Sub frmLookupChild_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]....
View 3 Replies
Jan 19, 2009
I'm wondering what a best practice is for handling this.I've got a standard vendor table - with VendorId (which is PK, numeric) and a field the users call SimpleId (which is usually a name - don't let the column name of SimpleId make you think it's numeric!).I've got one datatable that comes from a data adapter that looks like this. And this already changes the table in the SQL database...SqlDataAdapter("Select VendorId, SimpleId From Vendor_T", _connection)I've got this datatable on one panel of my form with a binding navigator - and you can change the SimpleId for a vendor with this.
View 16 Replies
Jul 17, 2009
I've been trying to use lookup tables to display names instead of ID's in a DataGridView using a DataGridComboBoxColumn and have even copied the example shown in the Forms over Data videos produced by Microsoft but still get the following error message:System. =Argument Exception:DataGridView ComboBoxCell value is not valid..Everything was done in the designer and the problem only occurs with the DataGridView; lookups work fine using a combo box when displaying single records.Also the error message only pops up when I close the form. Prior to that all the names are displayed correctly for each record, the drop down list shows the names correctly and I can edit, add and delete rows and save all my edits with no problems. Its just when I close the form that the problem occurs.Each time I press OK in the message box the names in the combo boxes are removed, one by one.
View 5 Replies
Jun 16, 2009
I want to create a simple program which can convert Units of Measure (e.g inches into centimeters, milliliters, meters, feet, etc). I want to create a function which has two parameters (unit to convert from and unit to convert to) and returns a conversion value (e.g. funciton passed parameters values inch and centimeter and returns value 2.54). In terms of strategy for the least processing overhead I am exploring a few options. I guess the slowest way would be some kind of nested If/Then or Case loop, so I wanted to use something similar to a 2D table lookup in excel (where the top row and the left column (key?) would have the unit types, and the conversion values would occupy the cells in the table body). Is this possible in VB? Could I load all of this into a 2D array or something? I read a bit about hashtables and dictionaries as well, Ideally Im looking for the least processor-hungry code since this function may be called upon frequently. Ill be using other functions to perform similar lookups on other 2D tables elsewhere too (i.e. matching a value on the top row and the left column and returning the coincident cell value in the table body).
View 8 Replies
Feb 23, 2012
assist in the proper way to populate a value in a txtbox based on a combobox selection? I basically have a table (tblStudent) that has two fields (Range, Amt). The range records are 1-5,6-10,11-20,21-50, >50. Amt are 0 by default.
four more Tables
(tblPA,tblNY,tblNJ,tbMD) with 2 fields (pctgStud,amount) where prctgStud are
ranges (0, 1-10,11-25,26-50,51-100). Amount are 0 by default.
My form has a 5 simple comboBoxes that allows one of the ranges to be selected for each of them. I also have 5 txtBox relating to the corresponding (Amt) fields. How do I populate the textboxes with the related AMT based on the range selected from the comboBox. On a side note, I want to ultimately increment all the textbox values by one in the tables when submit is clicked.
View 10 Replies
May 17, 2012
I am writing a service to get a count from a table on an SQL server. THe SQL box is in the same domain, and the service is runnign under the same account as the SQL box.
The box service is running on is Win 2008 in the domain. The interesting thing is that when I use this same code and run a normal EXE on that server, it runs no issues. In a service it crashe with:[code...]
View 4 Replies
Mar 11, 2011
I have a program which I am securing with a Username and Password box, in which the user enters their credentials. In the database, the username is a number field (VB would not accept this as a string and was looking for it as Int32). And the password is a text field. I have the form linked to the database by an OleDbConnection with a DataAdapter (DaUser) and DataSet (DsUser). I am using a datarow which I have declared at the top of my code i.e. Public drUser As DataRow. The problem arises when the user enters their username and password.
The following code searches the primary key row of the database (Username)
drUser = DsUser.Tables("User").Rows.Find(txtUsername.Text)
When the Username entered does not exist, I'm getting this error when trying to display on the form the users email:
NullReferenceException was unhandled - Object reference not set to an instance of an object.
I've tried both if statements and try/catch to basically say if the Username doesn't exist... display an error message etc.
View 2 Replies
