I have a SSIS Package (SQL Server 2005) which has a very simple control flow and a data flow. The package runs acceptably fast, but the Post Execute phase is ridiculously slow - the whole package takes 90 minutes to execute, from which 37 are the PostExecute phase. I don't have any event handler on that step, the source and the destinat...
Hi i am running a Sub which takes as arguments a Datatable and a String. Private Sub Populate(ByVal dttemp As DataTable, ByVal strWhichPart As String) At one point there is a combobox which is populated with some of the data in the datatable. The name of the combobox is cmd plus the name of the string for example when the string is ...
I want to develop a windows console application which executes an action periodically after a given time. I've read somewhere that a timer class is only available for windows forms applications, so what is the best way to accomplish what I want? ...
In Sybase SQL, I would like to execute a String containing SQL. I would expect something like this to work declare @exec_str char(100) select @exec_str = "select 1" execute @exec_str go from the documentation of the exec command execute | exec is used to execute a stored procedure or an extended stored procedur...
Is there a way to start a process in Java? in .Net this is done with for example: system.diagnostics.process.start("processname"); Is there an equivalent in Java so I can then let the user find the application and then it would work for any OS. Thanks How does that work if I provide a file? ...
when i try to use cron to execute my python script in a future time,i found there is a command at,AFAIK,the cron is for periodly execute,but what my scenario is only execute for once in specificed time. and my question is how to add python script to at command, also it there some python package for control the at command my dev os is ub...
I'm trying to use Java's ProcessBuilder Class to execute a command that has a pipe in it. For example: ls -l | grep foo However, I get an error: ls: |: no such file or directory Followed by: ls: grep: no such file or directory Even though that command works perfectly from the command line, I can not get ProcessBuilder to execute ...
I want to run a python script from another python script. Where I pass in variables as I would at command line. So for example I would run my first script that would iterate thru a list of values 0,1,2,3 and past those to the 2nd script "script2.py 0" then "script2.py 1", etc. I found SO 1186789 which is a similar question but ars's ...
I have a question relating to Perl dynamic code. Is there a construct in Perl where I could use to execute code. For instance, $command = " some command"; $perl -> execute($command); $command changes in run time . Sorry for my terminology. I do not know how to explain it otherwise. I am trying to accomplish this: I have a function w...
I have a SQL Server 2008 database where all access to the underlying tables is done through stored procedures. Some stored procedures simply SELECT records from the tables while others UPDATE, INSERT, and DELETE. If a stored procedure UPDATES a table does the user executing the stored procedure also need UPDATE permissions to the affec...
We are transitioning from SQL Server 2005 to 2008 and suddenly our Execute As User statements aren't working. Did something change between these 2 releases? ...
How can you have a function or something that will be executed before your program quits? I have a script that will be constantly running in the background, and I need it to save some data to a file before it exits. Is there a standard way of doing this? ...
We are sending data to be faxed and currently the program is using the PCPERFORM command. It appears that the data is being deleted before the PCPERFORM is completed. Will the EXECUTE command wait until the item is completed? ...
Hello, I'm trying to run the following command using exec in ant: ls -l /foo/bar | wc -l Currently, I have my exec looking like this: <exec executable="ls" outputproperty="noOfFiles"> <arg value="-l" /> <arg value="/foo/bar" /> <arg value="|" /> <arg value="wc" /> <arg value...
Hi, i'm looking to call a custom error log/debug function at the end of each function. example: i want to call error_log(__METHOD__); I want to echo $query; show execution time etc.. at the end of every function for debug purposes without having to call that customized function every time. much appreciated. ...
Hello , As the title says ... I have tried to use the following code to execute a PHP script when user clicks a button in my Java Swing application : URL url = new URL( "http://www.mywebsite.com/my_script.php" ); HttpURLConnection conn = (HttpURLConnection) url.openConnection(); conn.connect(); But nothing happens ... Is there someth...
I know how to add a link to a button in Adobe Flash... But how exactly do I add an _onClick() event to execute a Microsoft Excel sub macro? I have a web browser form in an excel sheet. Excel allows you to draw a browser form on the page and link it to a page (e.g. stackoverflow.com) so stackoverflow.com will show in the browser fram...