I 100% agree with you RE: SSIS project being a PITA in general.
the only reason I even consider it is just because it's easier to integrate with SQL Server jobs and abstract out the tedious parts of programming the data flow manually
the scenario here is to call some stupid web API that has some throttling (yay exception handling!) and updating the database with the results.
Removes BlockNode demarcation from analysis allowing localVariables to represent ProcedureScope regardless of where they are declared. Remove false-positive result where an assignment is made using a preceding assignment.
Modify tests to avoid false-positive test result(s)
Added tests for #4913. Modified tests to verify flagged results contain expected references and do not contain unexpected references. Checking result 'counts' can allow failing tests to pass.
below vbscript code took me 3hours just to complete trimming whitespaces of a 24MB file any tips to speed up the process below?
dim filename, path \'variables
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.GetFile(Wscript.ScriptFullName)
strFolder =...
Wow... I have a process that runs at 01:00 each day to download some data from a vendor via their API & send it to another vendor. On Monday it took 25 seconds to execute on my machine at the office.
It seems that at some point between Mon evening when I logged out and this morning when I logged in (I was off yesterday), my office machine was turned off, so the automated process didn't run Tues morning or this AM.
So, I kicked it off by hand this morning from my work laptop, at home, connected via the VPN - all processing here instead of directly on the office network.
it took 23 MINUTES to run!
Oh, sure, there's more network traffic at 8am than there is at 1am, but that's ridiculous!!!
Heres a code that update weekly datas from production reports
Known flaws :
The code is repetitive but i havent found a simple way to simplify it (since it work fine and its not complex, i dont know how to simplify it. But its still repetitive which is counter coding intuitive)
There is most li...
below vbscript code took me 3hours just to complete trimming whitespaces of a 24MB file any tips to speed up the process below?
dim filename, path \'variables
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.GetFile(Wscript.ScriptFullName)
strFolder =...
Heres a code that update weekly datas from production reports
Known flaws :
The code is repetitive but i havent found a simple way to simplify it (since it work fine and its not complex, i dont know how to simplify it. But its still repetitive which is counter coding intuitive)
There is most li...
VBA Rubberducking
VBA Rubberducking