Search results for query: *

found a solution var filteredRecords=AllRecords.Where(w=> !(w.Amount==0 && w.Sales==0));

How do I write a where statement that will exclude records if both conditions are met. example: var filteredRecords=AllRecords.Where(w=>w.Amount!=0 && w.Sales!=0); so if any record had amount=0 or sales=0 I want to include. I only want to exclude records where BOTH sales and amount are equal...

Is there a way to dynamically resize the legend of a chart based on the number of items being displayed? example: I have a pie chart that shows sales per state Currently I only have sales in 3 states so the legend shows those 3 states. but lets say after 1 year I have sales in 15 states I...

I am trying to use the mget command and download all csv files to a specific folder. I tried the following code but i wasnt able to successfully download the files. cd /outgoing mget *.csv \\ServerA\MorningFiles\Download This is the error message I received: "open for read: no such file or...

in VB.Net 1. how do count the number of steps in a SSIS package. 2. what's the equivalent of DTS.step for a SSIS step

Does anyone know whow to add two lines in a header for an export to a text file? Basically i transferring data from sql table to a text file but i need two header lines in my text file example : Version-5.1 spr-comma delimitted 7647, john smith, 123 main st, newport, ri 3459, jane collins...

I'm trying export data from a sql server table to an Excel file using SSIS. 1. Is there a way to get the package to override the file every time it runs? 2. Apparently SSIS does not allow implicit conversion. For some reason I keep on getting an error that I cannot convert between unicode and...

Why would using the xp_cmdshell stored procedure be preferred over the DTS package? Is it faster, easier to use?

I pass the parameter by entering the value in parameter field/section and the app is being executed by calling the exe file in the win32 field/section in the "execute process task properties".

It worked. thank you so much.................. :) Sam

I used Console.In.Readline but that didnt work so I tried using other variations and they still didnt work. What's the correct syntax?

.Net is causing the console to open, that part is fine but DTS is causing it to hang when I put a value in the parameter field. I would like to pass the value 1 to my .Net app but the console hangs. I put the number 1 in the parameter field/section. Is that the correct syntax?

I've been putting 1 in the parameter field/section because I want to pass the value 1. But instead of passing the value 1, the console just hangs there and waits for my input into the console. If I enter a value then press "enter" then the process works fine, but it relies on me entering a value...

try this: Dim objItemChecked As Object For Each objItemChecked In CheckedListBox1.CheckedItems msgbox (objItemChecked.ToString) Next Sam

Right, I dont want the console to ask for user input, just to pass the argument to the app. I tried your suggestion and unfortunately it didnt work. I'm using the "Execute Process Task" in DTS so when I put the argument on the command line it thinks that the argument is part of the file name.

When I put the parameter on the command line do I need to use a slash or just a space and the parameter ?

Try replacing the + in your SQL statement with &

Hi....... Make sure your login ID has rights to IIS...

I have a DTS package that runs a Vb.Net executable program. I would like to pass a argument from the DTS package to the Vb.Net app without having to enter the argument in the console manually. Every time I try to run the DTS package and vb.net app the Console appears and waits for my input. How...

I have a DTS package that runs a Vb.Net executable program. I would like to pass a parameter from the DTS package to the Vb.Net app without having to enter the parameter in the console manually. Every time I try to run the DTS package and vb.net app the Console appears and waits for my input...