Hello everyone. I h've been trying for the last week to access a variable in my SSIS package and foward it down to a Data Conversion Item. I've read that I could use a Derived Column or a Script Component Item but I have not had any luck. When I use the Script Componet I am able to test the variable value by adding the code Msgbox(Me.Variables.WMWeekNbr) in the method CreateNewOutputRows in the ScriptMain class. I see the message box with value but it doesn't foward to the data conversion item. I did add the variable to ReadOnlyVariables property. I also created a output columns on the script object. Im basically trying to create a C# application that will take a value and pass it to the SQL SSIS package which will delete values from the database. Thanks :doh:

Thanks

Hello, does anyone know if this is a bug or if I’m doing it wrong. I’m basically I’m using two For loops to filter out items from one list if they already exits on another (for dual list control). But when I remove a item from the list and I decrement the variable it looks like it does not decrement in memory therefore the inner loop will always read 23 even though I decrement the variable Sourcecounter. SO if outer loop has 2 items and inner loop has 23 and a item matches then I decrement the initial length of the inner loop by SourceLenght - 1. But the variable Sourcecounter will always go to 23 not 22. Here is the sample Dim DestinationLenght As Integer = 2 Dim SourceLenght As Integer = 23 Dim Destinationcounter As Integer For Destinationcounter = 0 To DestinationLenght Dim Sourcecounter As Integer For Sourcecounter = 0 To SourceLenght If Me.lstSource.Items(Sourcecounter).Text.ToString = Me.lstDestination.Items(Destinationcounter).Text.ToString Then Me.lstSource.Items.RemoveAt(Sourcecounter) Sourcecounter = Sourcecounter - 1 SourceLenght = SourceLenght - 1 End If Next Next Thanks

Thanks guys I will take a look at these code gen's:-D

Sorry guys, Is this a programming question?:~

A company did a project for us and they used a really nice code generator that create a DataManager Project and a DataAccessLayer Project in our solution. The DataAccessLayer had one class per table which I think is pretty nice. Have any of you used something like this?:doh:

:~ I created set of radio buttons which depending on what is selected will make a DIV tag visible or hidden, but since this is only client side code every time I do a submit on my form the div tag will appear. And this is whether on not the radio button which hides my div tag is selected. So to solve this I created a JavaScript function which will check to see which radio button is selected and either hide the div tag or make it visible, but I have not found a way to call the function. I went into the HTML CODE on my VB page and added a onload call to my function from the body tag but this also didn’t work. I do understand that attributes can be added to a button but only events. My question is, "Does anyone know how to call a JavaScript function every time the page is loaded"? Thanks