I have an urgent question about the datagridview and combobox column in VB2005 I am unable to show the first item in the award code field by default without selecting an item first. How can this be done? For example CX should be shown in the blank area for the first 2 items, which shows up as blank. The 2nd issue is how can I take the data from my hidden field, which has an award code of either cd,cn,mr, etc, which is brought back in the dataset below and is on the grid but the column is just hidden. I actually need this data shown as the default in the “blank space” of the combobox. I am at a loss. So basically when I load the grid I need the award code for a specific row placed into the combo box as if it were selected for that specific row by default. So row 1 would show the following: Row 1 would show Transfer =blank Rfa number CX08-004 Award Code=CD Row 2 would show Transfer =blank Rfa number CX08-003 Award Code=RP etc etc Below code is what I use to bind the datasource to the combo box With grdBatchBudgetProjection ‘Dataviewgrid With chk ‘CheckboxColumn .DataPropertyName = "AwardCD" .HeaderText = "Award Code" .Width = 100 ' Bind Column .DataSource = ds3.Tables(0) .ValueMember = "AwardID" ‘also tried AwardCD here .DisplayMember = "AwardCD" .DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox 'dd or cbo, doesn't really matter for this field. End With .Columns.Add(chk) End With ----------------- I also tried the below code with no success. i just cannot see what I am doing incorrectly.

'Kludge loop to have combo box index= value returned from sql
'For iRowCount = 0 To ds2.Tables(0).Rows.Count - 1
Dim j As Integer = 0

        For Each row As DataGridViewRow In grdBatchBudgetProjection.Rows
'' Dim Cell As DataGridViewComboBoxCell = DirectCast(grdBatchBudgetProjection.Item(5,j),
          DataGridViewComboBoxCell)
 Dim cell As DataGridViewComboBoxCell = DirectCast(grdBatchBudgetProjection.Item(5, j),
         DataGridViewComboBoxCell)
            cell.Value = ds2.Tables(0).Rows(j)(4).ToString
            'Debug.Print(ds2.Tables(0).Rows(j)("AwardCD").ToString)

Here is the problem: I have a .net application (a button runs a stored proc, which in turn runs the SSIS package). I need to add a dialog so that each time someone wants to change or use a different flat file source, no problem they just browse to the location of the file and the flat file name and location are added to my flat file connection via the .NET application ,which all the files are in the same formatting. I am not sure where to start with the variables. >.NET dialog passed to Stored proc > passed to variable in SSIS package. I am not even sure how to do the stored proc to SSIS package in a flat file connection. Any help would be appreciated. :omg:

unfortunately, I came up with the same error. I just cannot understand what I am doing incorrectly. It has to be caused by something on the server somehow. I actually have the asme code in Vb and it works just fine but the c# code does not want to work past this line. pkg = app.LoadPackage(pkgLocation, eventListener); I have tried the following for the pkglocation, they all give me the same error: Failed to open package file pkgLocation = @".\Serv37\M:\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx"; pkgLocation = @"\\Serv37\M:\wwwroot\AS- MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx"; pkgLocation = @"\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx"; pkgLocation = @"\\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx"; pkgLocation = "\\Serv37\\wwwroot\\AS-MIS\\LoadBeaPayroll\\LoadBeaPayroll\\package.dtsx"; Any more suggestions anyone?

The following is the exact message I am getting when running the application from Visual Studio 2005, trying to load a .dtsx package. I could not add a screen shot here. The code is so simple that I cannot understand what the path problem is. Failed to open package file "\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx" due to error 0x80070003 "The system cannot find the path specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format. The. ,dtsx package and code are both located on the server. I can run the .dtsx package fine in BIDS and get the required result. When the code runs to the line "pkg = app.LoadPackage(pkgLocation, eventListener);" that is when I get the "Failed to open package file" error. Below is a re-posting of the actual code: using System; using System.Collections.Generic; using System.Text; using Microsoft.SqlServer.Dts.Runtime; namespace DocBeaEntry { class MyEventListener : DefaultEvents { public override bool OnError(DtsObject source, int errorCode, string subComponent, string description, string helpFile, int helpContext, string idofInterfaceWithError) { // Add application-specific diagnostics here. Console.WriteLine("Error in {0}/{1} : {2}", source, subComponent, description);return false; } } public class clsSSIS { public static void RunDTSX() { string pkgLocation; Package pkg; Application app; DTSExecResult pkgResults; MyEventListener eventListener = new MyEventListener(); pkgLocation = @"\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx"; app = new Application(); pkg = app.LoadPackage(pkgLocation, eventListener); pkgResults = pkg.Execute(null, null, eventListener, null, null);Console.WriteLine(pkgResults.ToString()); } } }

The following is the exact message I am getting when running the application from Visual Studio 2005, trying to load a .dtsx package. I could not add a screen shot here. The code is so simple that I cannot understand what the path problem is. Failed to open package file "\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx" due to error 0x80070003 "The system cannot find the path specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format. The. ,dtsx package and code are both located on the server. I can run the .dtsx package fine in BIDS and get the required result. When the code runs to the line "pkg = app.LoadPackage(pkgLocation, eventListener);" that is when I get the "Failed to open package file" error. Below is a re-posting of the actual code: using System; using System.Collections.Generic; using System.Text; using Microsoft.SqlServer.Dts.Runtime; namespace DocBeaEntry { class MyEventListener : DefaultEvents { public override bool OnError(DtsObject source, int errorCode, string subComponent, string description, string helpFile, int helpContext, string idofInterfaceWithError) { // Add application-specific diagnostics here. Console.WriteLine("Error in {0}/{1} : {2}", source, subComponent, description);return false; } } public class clsSSIS { public static void RunDTSX() { string pkgLocation; Package pkg; Application app; DTSExecResult pkgResults; MyEventListener eventListener = new MyEventListener(); pkgLocation = @"\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx"; app = new Application(); pkg = app.LoadPackage(pkgLocation, eventListener); pkgResults = pkg.Execute(null, null, eventListener, null, null);Console.WriteLine(pkgResults.ToString()); } } }