« first day (1818 days earlier)      last day (1362 days later) » 

Duga
Duga
12:01 AM
RELOAD!
[banane-io/PDB] 2 commits. 2 additions. 2 deletions.
[rubberduck-vba/Battleship] 1 opened issue.
[rubberduck-vba/Rubberduck] 1 opened issue.
[Minesweeper] Games Played: 113, Bombs Used: 87, Moves Performed: 16165, New Users: 8
 
 
1 hour later…
IvenBach
IvenBach
1:24 AM
2019-05-28 18:22:22.4622;FATAL-;Rubberduck._Extension;Startup sequence threw an unexpected exception.;Castle.MicroKernel.ComponentActivator.ComponentActivatorException: ComponentActivator: could not instantiate Rubberduck.UI.ToDoItems.ToDoExplorerWindow ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
   at Rubberduck.UI.ToDoItems.ToDoExplorerViewModel.UpdateColumnHeadingsOrderToMatchCachedOrder(ObservableCollection`1 columns) in C:\Users\IvenB…
 
Mathieu Guindon
Mathieu Guindon
> System.NullReferenceException: Object reference not set to an instance of an object.
at Rubberduck.UI.ToDoItems.ToDoExplorerViewModel.UpdateColumnHeadingsOrderToMatchCachedOrder(ObservableCollection`1 columns) in C:\Users\IvenBach\Source\Repos\Rubberduck\Rubberduck.Core\UI\ToDoItems\ToDoExplorerViewModel.cs:line 111
> at Rubberduck.UI.ToDoItems.ToDoExplorerWindow..ctor(ToDoExplorerViewModel viewModel) in C:\Users\IvenBach\Source\Repos\Rubberduck\Rubberduck.Core\UI\ToDoItems\ToDoExplorerWindow.cs:line 24
 
IvenBach
IvenBach
Not 3 seconds do I paste and you're already pointing it out.
 
Mathieu Guindon
Mathieu Guindon
it's Exception.ToString 
System.NullReferenceException: Object reference not set to an instance of an object.
that's this.GetType().ToString(), with the (localized) description string
 
IvenBach
IvenBach
Wasn't getting this on my work box.
mumble mumble deserialization of column order mumble indices not found.
 
Mathieu Guindon
Mathieu Guindon
then the stack trace; each frame begins with at, so what you read at the top of it is where the exception was thrown: the last scope that got to run being the last one to be at the top of the call stack, reading down you follow/"trace" execution all the way back to the top of the stack - which may or may not be the application's entry point, depending on what the code does (and how). 
at Rubberduck._Extension.Startup() in C:\Users\IvenBach\Source\Repos\Rubberduck\Rubberduck.Main\Extension.cs:line 235
in a release build, you don't normally have the .pdb files, so the in part is missing
 
IvenBach
IvenBach
1:41 AM
I was right its github.com/IvenBach/Rubberduck/blob/Issue2947_ToDoHeaderReorder/… since nothing is being deserialized.
Need to also persist the column width too.
 
Mathieu Guindon
Mathieu Guindon
you got this!
 
IvenBach
IvenBach
:giggle: My ego needs no assistance.
I'll pick this up after scouts.
 
Mathieu Guindon
Mathieu Guindon
lol
 
Duga
Duga
2:06 AM
> **Justification**
Self-Closing Pair (SCP) completion is currently hard-wired to bail out when the current line is in a comment. That hard-wired behavior needs to be made configurable, and/or improved so that it still kicks in when the current line looks like `'@Annotation|`, so we can get from there to `'@Annotation("|")` with just two (<kbd>(</kbd> and <kbd>"</kbd>) keystrokes.

**Description**
When SCP determines that the current line is a comment, instead of bailing out it needs to firs
 
 
6 hours later…
IvenBach
IvenBach
8:18 AM
@IvenBach sandman got you. Do at work.
 
 
3 hours later…
Duga
Duga
11:05 AM
> Version 2.4.1.4627
OS: Microsoft Windows NT 10.0.17763.0, x64
Host Product: Microsoft Office x64
Host Version: 16.0.11601.20230
Host Executable: EXCEL.EXE

**Description**
When i run the Code Inspection tools, in the window there is the message "Rubberduck doesn't see anything yet" with ducks that rotate forever.

The toolbar says "Ready".
I cannot click the refresh button on the Code Inspection window neither the refresh link right under the error message.

In %APPDATA%\Rubberduck
> Could you check for me whether Rubberduck is configured to automatically run Code Inspections after parsing? Also we default to no logging unless it's the first start after a new installation. Please check whether a logging level other than "None" is set in the settings. Thanks :)
> Yes, the checkbox "Run Inspections automatically on successful parse" is checked. All settings are reset to the default values.

Logging level was set to "No logging".
Now I've changed it to "Debug".
[RubberduckLog.txt](https://github.com/rubberduck-vba/Rubberduck/files/3232163/RubberduckLog.txt)
 
FreeMan
FreeMan
@Duga but first, get AC working?
I have this nifty yellow warning triangle on my ADO .NET Destination step in my data flow, but I don't see anything in the properties or Edit pane indicating what's wrong with it. Where do I go to find out what's broken not quite right?
 
Duga
Duga
11:28 AM
> The root cause of this seems to be an incorrect handling of Inspection Cancellation in the ViewModel for the CodeInspections window. The Stacktrace for the COMException in the log suggests that the `SheetAccessedUsingStringInspection` has been run and failed.

```
2019-05-29 13:18:27.6929;WARN-2.4.1.4627;Rubberduck.Inspections.Rubberduck.Inspections.Inspector;System.Runtime.InteropServices.COMException (0x8001010A): Il filtro messaggi ha indicato che l'applicazione è impegnata. (Eccezione d
> I think the issue relates to the `Unparsed` and `IsRefreshing` flags not being set correctly in the error handling of Inspection result fetching here:

https://github.com/rubberduck-vba/Rubberduck/blob/bdef13f0747fcb0278978337d33354e2914d7e96/Rubberduck.Core/UI/Inspections/InspectionResultsViewModel.cs#L404-L409
 
FreeMan
FreeMan
I also keep getting:
> Warning: 0x802092A7 at Data Flow Task, Temp Table [119]: Truncation may occur due to inserting data from data flow column "Q12" with a length of 50 to database column "Q12" with a length of 5.
which I understand - row 2 of my data set has the survey question while rows 3-x have the answers. I deleted row 2 and tried running it again and I'm still getting that error.
Is it because I created the connection with a file that had that extra data in there?
Found it! (Google to the rescue) On the flat-file source, I had to set output data property to length of 5 instead of the 50 that it was at.
 
FreeMan
FreeMan
12:08 PM
Hey, having success and almost liking SSIS!
I've got it truncating my temp table then loading the CSV to it.
I have a Stored Procedure that loads the new data from the temp table to the permanent table. Would the logical next step be to have another Execute SQL Step to fire off that stored proc?
If so, can I add a parameter to the whole SSIS package that it can use? The SP requires a parameter so it knows which client the data is for.
 
Mathieu Guindon
Mathieu Guindon
@FreeMan sure you can!
 
FreeMan
FreeMan
I guess it would be simpler/easier/more logicaler/something to make one call to do all the data loading instead of calling SSIS to load the data to the temp table, then another SP call from my VBA code to load the permanent table.
begins to rummage to discover learn how to set/use SSIS package parameters
 
this
this
is the parameter independent of the file(s)?
 
FreeMan
FreeMan
12:26 PM
No. I'll need to pass in the file name (each client downloads with a unique file name), and I'll need to pass in the client ID ([int]).
I could pass in just the ID and get the file name - it's in a config table, but I think it would be easier to pass in the file name.
 
this
this
hm. If you already know the file's name which is unique to the client, seems to me that can be looked up in the SP you are calling.
 
FreeMan
FreeMan
I could do it bassackwards, I suppose.
(it's backwards to me because everything is internally based off the client ID and I look everything up from there).
that makes sense, though.
 
this
this
One reason why I'd do that way is because it makes for more testable code if the SP is inferring the client ID from the filename.
Then you have no need for a SSIS parameter.
 
FreeMan
FreeMan
then it's one parameter to the SSIS package (file name) ...
eh?
 
this
this
Hm. I thought you had a table with all the file names already?
 
FreeMan
FreeMan
12:29 PM
I do.
 
this
this
and if that has the client ID then.
 
FreeMan
FreeMan
step back (for my benefit) big picture:
 
Quack Exchange
Quack Exchange
-1
Q: Overflow issue in Excel object when inputting multiple Excel sheets

Jay JacksonI'm extremely new to this community and appreciate any and all help. Apologies if my question has been answered before and if so, please point me into the right direction. Issue: I created a VBA script which inputs an excel files, runs some processing and then asks the user if they want to take ...

vba excel
 
Hosch250
Hosch250
1:26 PM
@FreeMan Did you just step back off a cliff?
 
FreeMan
FreeMan
@Hosch250 no, but our corporate internet did.
carp! It looked like my "big picture" had posted, but not my follow up...
1) Load CSV->temp table via SSIS, passing it the file name
2) Execute SP from SSIS step passing the file name to load temp-> permanent table.
When I pass the file name in, do I need to include the full path or is that determined by how I set up the parameter?
 
Duga
Duga
2:16 PM
> Thanks for the bug report! If you have inspections configured to run automatically after a successful parse, you can use the "main" refresh command as a work-around to refresh inspection results:

!["Ready" parser state button](https://user-images.githubusercontent.com/5751684/58563707-a107e600-81f9-11e9-8554-59c9217b8b07.png)

The default hotkey for this command is <kbd>Ctrl</kbd>+<kbd>`</kbd>.

That said, this inspections toolwindow refresh bug rings a bell and I think it might have be
 
KySoto
KySoto
so i see superuser.com/questions/1442570/cross-referencing-assistance and im just like... if that data was in a basic access table it would take but a simple query...
 
FreeMan
FreeMan
@KySoto you can even run a query against a worksheet in Excel.
 
KySoto
KySoto
lol.
 
FreeMan
FreeMan
After all, isn't Excel a database?
 
KySoto
KySoto
i dont excel much
im a black sheep access vba programmer
all the REAL programmers play around in excel and.. uhh... one of the other ones
 
FreeMan
FreeMan
2:31 PM
Potentially dumb question: If I'm designing my SSIS package against my Dev server, do I need to recreate it against the prod server or just edit the appropriate connection managers? Or can that be passed in as a parameter, too?
 
this
this
can be parameterized, too. Also look up SSIS catalog & environments
 
FreeMan
FreeMan
thanks
got my SP modified to accept the file name and look up the client ID. Seems to work ok
 
Mathieu Guindon
Mathieu Guindon
everything can be parameterized
 
Duga
Duga
> Hitting the "main" refresh doesn't resolve the issue.
After cliccking i read on the button "Starting", then "Loading reference", "Resolving reference" and finally it display again "Ready" but in the Code Inspection window the error remain the same.
 
FreeMan
FreeMan
walking through the Udemy intro course on SSIS. found the part about creating the Catalog.
lots to absorb...
 
Duga
Duga
2:49 PM
> @IvenBach @Vogel612 I was really only referring to anything that can already be access with a hotkey in some context, as in the "run all tests" which uses a HotKey to get to the tests pane and then another HotKey to run all tests.
> @IvenBach @Vogel612 I was really only referring to anything that can already be access with a hotkey in some context, as in the "run all tests" which uses a HotKey to get to the tests pane and then another HotKey to run all tests.

But I understand if the constraints of the environment don't let you do everything you want. ;-)
 
KySoto
KySoto
so what do you guys think of muh answer?
0
A: Assign Value from Query with sum to Textbox

KySotoCreate a query using the sql you have, but slightly modded PARAMETERS eid long; SELECT Sum(tblentrys.entryhours) AS TotalHoursPerFunction FROM tBleExams INNER JOIN ( tBlBankList INNER JOIN ( tBlExaminers INNER JOIN ( tBlEntrys INNER JOIN tBlActivity ON tBlEntrys.EntryActi...

@Hosch250 You know, you can use mcafee for that too...
 
Mathieu Guindon
Mathieu Guindon
3:11 PM
@Duga so much for trying the latest pre-release
although, I think the exception is hiding the refresh issue of the inspection results command
and the exception would still be thrown with the latest pre-release
 
Duga
Duga
> I like this approach. I've gotten so accustomed to it working I have come to expect it... :)
 
Feeds
Feeds
3:40 PM
CommitStrip: It’s an art
posted on May 29, 2019 by CommitStrip

 
Mathieu Guindon
Mathieu Guindon
@Duga that's awesome
 
IvenBach
IvenBach
@Duga Request a PR to #MakeItSoNumbah2
 
Duga
Duga
4:01 PM
> Hitting the "main" refresh button doesn't resolve the issue.
After clicking I read on this button "Starting", then "Loading reference", "Resolving reference" and finally it display again "Ready" but in the Code Inspection window the error remain the same.
 
 
2 hours later…
KySoto
KySoto
5:41 PM
Do you guys know if it is possible to save an access form without using docmd
 
this
this
as in saving changes made to an Access form in design view? Pretty sure you need to use DoCmd.Save for that.
 
FreeMan
FreeMan
I'm getting this when I execute my SSIS package:
> Warning: 0x80049304 at Data Flow Task - Load Temp Table from CSV, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
The fix appears to be obvious. The question is "is this something I need to be concerned about?" and if so, "right now?"
 
KySoto
KySoto
ugh
i hate that we have to use docmd
i feel like im doing it wrong
@FreeMan doesnt matter at all
 
FreeMan
FreeMan
seems that it's only going to be an issue if my package runs "too long" and I'd like to figure out how to make it better quicker
 
this
this
While we do avoid DoCmd as much as possible, it is inevitable in some situation. Saving is one of them -- I suspect that it's the one that does the writes to the streams within the Access file.
 
KySoto
KySoto
5:51 PM
even then...
that makes sense
id rather not get into that
its funny though, if you create a new form programatically, it doesnt allow you to name it in the create function
 
FreeMan
FreeMan
6:03 PM
Yay! got a parameter added to SSIS. Boo! I have to specify the full path & file name (unless someone has a tip), so now I have to modify the SP to pull just the file name from the full path.
 
KySoto
KySoto
my code inspector is borked
i open one group
it opens all groups
current version of next
 
FreeMan
FreeMan
^ known issue
 
KySoto
KySoto
i was going to report it
but my train o thought was derailed by the engineer watching me type this message
i was trying to be appropriately descriptive
 
FreeMan
FreeMan
How many heads explode: 
DECLARE	@completeFileName nvarchar(500) = 'F:\My\path\to\my\file\filename.csv'
DECLARE @fileName nvarchar(50)
SET @fileName = REVERSE(left(REVERSE(@completeFileName),CHARINDEX('\', REVERSE(@completeFileName))-1))
SET @fileName = LEFT(@fileName, LEN(@fileName) - 4)
For testing purposes. @completeFileName will be passed into SSIS as the parameter and will be passed on to the SP for execution
Also, @c pops up Comintern's name. Anyone hear from him lately? I'm sure life's gotten in his way, but it'd be nice to know he's OK.
 
this
this
6:20 PM
aren't you doing a ForEach enumerator in your SSIS package?
if that's the case, you only need a path, and insert into a "result" table for each loop.
 
FreeMan
FreeMan
ummm... no.
 
KySoto
KySoto
heh
code inspection is complaining that member tag is not found on hte compile time interface for type control
 
FreeMan
FreeMan
Current logic is 1) Download file, 2) load to temp, 3) load to permanent, Lather, rinse, repeat.
Guess I could download all, call one SSIS to Load Them All.
Hadn't thought of that.
 
this
this
@KySoto it's not.
 
KySoto
KySoto
its ok
 
this
this
6:22 PM
it only exists on Access.TextBox, Access.Combobox, etc. but not on Access.Control
 
KySoto
KySoto
yeah, everything that exists in the controls collection seems to have a tag property
except i think... buttons?
nope, buttons have it
yeah, so everything has a tag
but hte base class doesnt have it
 
FreeMan
FreeMan
Just outta curiosity, why does the Execute SQL Task have 2 green lines from it? Can I have 2 different tasks kick off simultaneously once it's finished?
 
KySoto
KySoto
error and results
 
FreeMan
FreeMan
On the Data Flow tab, they're blue for results, red for errors. How do I know which green is which?
 
KySoto
KySoto
brb bio
 
FreeMan
FreeMan
6:26 PM
bio? biology break as in bathroom?
right click the line, I get Success, Failure, Completion. Great...
 
Mathieu Guindon
Mathieu Guindon
@FreeMan there's only one
the other is a handle for adding another
 
FreeMan
FreeMan
But the color inconsistency still stands...
 
Mathieu Guindon
Mathieu Guindon
any control/data flow task/component can have as many outputs as you need it to have
and any connector can be configured to branch on success (green), on error (red), or on completion (..yellow? black? don't recall)
 
FreeMan
FreeMan
ah. I see. So I can have multiple things kick off after that Exec SQL Task finishes?
 
Mathieu Guindon
Mathieu Guindon
yes
 
FreeMan
FreeMan
6:30 PM
completion is black.
I see. If I select one of the other options Failure or completion the color of the line changes.
#TIL (a lotta stuff)
Now the trick is to remember it until tomorrow!
 
Mathieu Guindon
Mathieu Guindon
2 mins ago, by Mathieu Guindon
any control/data flow task/component can have as many outputs as you need it to have
^ that's not exactly true though
but, for a "flower & bees" explanation, it's good enough :)
 
FreeMan
FreeMan
"flower & bees"? OK dad, but I already heard this stuff from my buddies in the locker room at high school...
:)
 
Feeds
Feeds
 
FreeMan
FreeMan
Go Go Twitter @Feeds gadget breakage!
and, "Oops!"
 
Hosch250
Hosch250
@Feeds I saw that.
Fortunately, I rarely have to rely on SE for my knowledge.
 
FreeMan
FreeMan
6:44 PM
wow... this is kinda spooky. I think I've got all this working now. I just need to figure out how to call my SSIS package from my VBA code and I'm golden!
 
Mathieu Guindon
Mathieu Guindon
ouch
if you figure out anything simpler than setting up a SQL Server Agent job involving an SSIS Package Execution proxy user, a stored procedure in msdb that starts the job, and a stored procedure in a DB the VBA code can access & run... let me know, I'm interested :) 
ALTER procedure [dbo].[UpdateMaterialInventory]
with execute as 'SqlAgentProxy'
as
begin

	execute msdb.dbo.sp_start_job N'NDS-ManualMaterialInventory';

end
ALTER procedure [dbo].[UpdateMaterialInventory]
as
begin

	execute msdb.dbo.UpdateMaterialInventory;

end
had to create a SSISProxyCredentials object (under Security/Credentials) that uses the identity of the SSIS service account
oh, and it's fire-and-forget: VBA gets to know when the job starts, but not when it ends!
IOW it's a bloody mess
much easier from .net actually, no idea - the only .net code I have that runs SSIS packages is... itself in a SSIS package
 
this
this
 
Mathieu Guindon
Mathieu Guindon
7:03 PM
 
this
this
yuck. I absolutely hate how SharePoint works.
"It's OK! You can put in spaces and all craps! We'll just make up a random name with weird encoding convention for those fuddly old programmers!"
 
KySoto
KySoto
@MathieuGuindon i wanna tell the guy exactly that... but i dont wanna get black marks for telling people they are stupid
screwit....
Maybe you should change your column headers to prevent such errors from happening. Using spaces and special (non alphanumeric) characters in fields is a recipe for disaster.. — KySoto 40 secs ago
 
this
this
@KySoto I don't think that's fair. Remember, SharePoint is meant to be accessible to non-programmers, to enable them to do their things without having to involve IT. The screwup is not on the users but on the SharePoint programmers who didn't come up with a good convention of converting captions into programmatic names.
Users don't give a fig about whether the name is easy to work with for the programmers; they want their TPS report to look purty.
But because Microsoft can't do it right, the users now have to care about extraneous details like whether it's a good programmatic name or not.
Oh.... fun fact! You can't change the programmatic name once you've created the column! Yay!
 
KySoto
KySoto
what do people actually DO on sharepoint?
 
this
this
CMS, mainly.
 
KySoto
KySoto
7:11 PM
CMS?
 
this
this
content management system
 
KySoto
KySoto
so sharing excel and word docs?
and calendars
 
this
this
yeah but with a way to search and find contents, too.
But that's the main use basically.
 
KySoto
KySoto
i guess we just dont have nuff stuff
no one searches anything
they just kinda know where their stuff is
 
this
this
for certain industries like a law firm (for example), it does matter a lot
since they're awash in 10Ks of documents about anything
 
KySoto
KySoto
7:15 PM
welp, im glad im not working at a law firm
ive only ever heard horror stories
lol
 
FreeMan
FreeMan
@MathieuGuindon I was under the impression that calling a SP to kick off the SSIS package was the way to go. This confirms it.
@this thanks!
@MathieuGuindon IOW, the SP should write results to a table to be read back by VBA so I know what worked and what didn't...
 
IvenBach
IvenBach
@MathieuGuindon more like backward Ed doing that IMO. Although that would contribute to SO anti-friendly appearance.
 
Mathieu Guindon
Mathieu Guindon
@KySoto cry. a lot.
 
this
this
@MathieuGuindon did you have the misfortune of working on one?
 
Mathieu Guindon
Mathieu Guindon
@FreeMan you mean the package
@this 10 years ago, yes
#NeverAgain
 
this
this
7:28 PM
ooooh, with 2007?!?
 
Mathieu Guindon
Mathieu Guindon
maybe
 
this
this
2010 was tolerable. 2007... #Insanity
 
Mathieu Guindon
Mathieu Guindon
more likely 2003
 
FreeMan
FreeMan
@MathieuGuindon well, the SP that loads the data from temp to permanent table.
 
this
this
even worse.
never worked w/ 2003, though. Only briefly w/ 2007 but mainly with 2010.
Not exactly itching to get back at it anyway.
 
Mathieu Guindon
Mathieu Guindon
7:30 PM
@FreeMan and how does VBA know to go read that "ok done!" marker record? Hit the db every 30 seconds until it comes back with a "yup"?
 
FreeMan
FreeMan
yeah, prolly... :(
 
Mathieu Guindon
Mathieu Guindon
"poll-y"
 
FreeMan
FreeMan
Actually, since it's fire & forget, I really do need a for each loop - I've only got one temp table (I guess I could have more), so I need them to run synchronously, not async.
@MathieuGuindon poll-ly
 
this
this
that's not how job works, really.
it is asynchronous by definition
The linked blog article shows how you can poll, which is not that fun.
 
FreeMan
FreeMan
sequentially, not synchronously...
 
this
this
7:33 PM
But in this case, the client really really wanted the status notification, so.
 
FreeMan
FreeMan
i.e. I load client 1's data to the temp table, then load that to the final table and flag it as client 1. Then truncate temp table, load client 2 data to temp, then move load to final, flagging as client 2.
Lather rinse repeat
Maybe the whole process needs a rethink now...
would putting it in a ForEach loop in SSIS ensure they run sequentially, or would it fire off the SP/Data Flow/SP process as fast as it can and leave everything to fend for itself?
 
Mathieu Guindon
Mathieu Guindon
Make SSIS drop a marker file on some network share on success, and use a (client-side) FileSystemWatcher to fire an event when the marker file shows up?
 
FreeMan
FreeMan
this is the control flow that I've got (mostly) set up
 
this
this
this is only doing one file at a time?
 
FreeMan
FreeMan
yes
 
this
this
7:37 PM
I was expecting a foreach over a bunch of files.
 
FreeMan
FreeMan
That needs to be looped (either by VBA calls or within SSIS) for all the clients.
 
Mathieu Guindon
Mathieu Guindon
1
A: Receive notification of file creation in VBA without polling

Steve RindsbergThis provides a native WinAP + VB/VBA way of doing the job, I expect: http://books.google.com/books?id=46toCUvklIQC&pg=PA757&lpg=PA757&dq=windows+api+monitor+directory+changes+vba&source=bl&ots=jmMY4sJFK4&sig=KCB6B_soEA9_JzjlhyNZvSC91w4&hl=en&sa=X&ei=cUAMUsDzOe3iyAHu8YGwAg&ved=0CFIQ6AEwBw#v=onepage

 
FreeMan
FreeMan
Do I need to define "a bunch of files" up front?
 
this
this
See, the way I think you want to do is to first collect all files you need, fill up a driving table with the file path & client ID.
 
FreeMan
FreeMan
There are times when I may reload data for one specific client. Or when the web site may refuse to give me the data...
ah...
 
this
this
7:38 PM
then kick off the job which will then do a ForEach over an ADODB.Recordset of that table
that way, you have all the parameters fed to the package from the recordset in the ForEach, rather than externally.
and the job only need to run once.
(rather than once per file, that is)
 
FreeMan
FreeMan
that makes more sense.
I was looking at it from the perspective of minimal modifications to what I have, not a more serious rewrite. When in the forest, one tends to only see the tree trunks...
 
this
this
I try to approach stuff in sets, not rows. :)
@MathieuGuindon Nice! Thanks for sharing!
 
IvenBach
IvenBach
I picked that book up already. Need to go through with with my extra free time.
 
KySoto
KySoto
7:58 PM
well...
this is... -_-
 
Mathieu Guindon
Mathieu Guindon
8:12 PM
wtaf
doesn't sound like 1984 "victory gin" at all
 
FreeMan
FreeMan
@this You're referring to a ForEach Loop Container in SSIS, not a For Each Record in MyADODBRecordset in VBA, right?
Just wanting to be sure...
 
this
this
Correct.
you would use a recordset enumerator for the container (?)
Foreach ADO enumerator is the term I'm trying to remember.
 
FreeMan
FreeMan
thx. Interesting... Looking at this MS tutorial showing how to call a SP from SSIS, there is a IsQueryStoredProcedure setting that is set to False and disabled, but doesn't seem to need to be set to True in order to execute a SP.
weird...
 
IvenBach
IvenBach
@KySoto Pineapples AHOY!
 
KySoto
KySoto
lol..
 
this
this
8:26 PM
@FreeMan confused I don't see that setting in the article?
 
FreeMan
FreeMan
In the image under step 8. There are 2 settings red boxed. It's under the 2nd red box.
Also:
 
this
this
ooh, not a thing you set directly
 
FreeMan
FreeMan
yeah, I kinda figured...
 
this
this
TBH, I never even noticed.... :-\
 
FreeMan
FreeMan
will it flip to True after it compiles and realizes this is a SP?
focuses on the useless details...
 
this
this
8:28 PM
 
FreeMan
FreeMan
@FreeMan Microsoft <-- ftfy
@this interesting. I skimmed that. skiwi'd and will reread tomorrow...
TTGH!
 
Mathieu Guindon
Mathieu Guindon
love how @skiwi has become a verb
 
IvenBach
IvenBach
8:45 PM
Wonder how that come about :whistles-innocently:
 
KySoto
KySoto
@this you make access front ends that utilize bound forms right, how many concurrent users do you tend to have?
 
this
this
anywhere in between to 5 to 100
 
KySoto
KySoto
hmm. are there many issues with locking?
 
this
this
with a SQL Server backend? No.
 
skiwi
skiwi
9:05 PM
@MathieuGuindon What's happened?
 
this
this
33 mins ago, by FreeMan
@this interesting. I skimmed that. skiwi'd and will reread tomorrow...
 
Mathieu Guindon
Mathieu Guindon
@skiwi congrats, you're a meme :)
2
 
skiwi
skiwi
Nice :)
 
Mathieu Guindon
Mathieu Guindon
/verb
 
this
this
all we just need is a screenshot of 1000 tabs to gif-ify it.
 
skiwi
skiwi
9:10 PM
user image
3
 
Mathieu Guindon
Mathieu Guindon
wow so many TW tabs
all HNQs?
 
skiwi
skiwi
Yes, @MathieuGuindon
 
Mathieu Guindon
Mathieu Guindon
9:41 PM
not so hot anymore though ;-)
 
Mathieu Guindon
Mathieu Guindon
9:58 PM
0
A: What's a Zombie? And what are the many other memes of Code Review?

Mathieu GuindonMeme: Skiwi (verb), e.g. "skiwi'd" Originator: IvenBach (?) Cultural Height: VBA Rubberducking (2nd monitor?) Background: Skiwi has long been renowned to consistently have well over 1000 open tabs in his browser. "To skiwi something" means to open a browser tab and leave it opened to get back ...

#immortalized
 
Feeds
Feeds
 
skiwi
skiwi
10:16 PM
@MathieuGuindon Nice :)
 
mansellan
mansellan
#TIL there are a heck of a lot of reasons lurking behind {addin} could not be loaded
making progress though i think
 
Mathieu Guindon
Mathieu Guindon
10:30 PM
ttqw
 
IvenBach
IvenBach
 
 
1 hour later…
IvenBach
IvenBach
11:45 PM
:barf: Why is saving the width so much more difficult that I thought it would be.
It serializes and deserializes without issue. When using it as a default as part of RD.Cord.Settings leading the default chokes.
<ColumnHeaderInformation>
<DescriptionColumn>
<DisplayIndex>0</DisplayIndex>
<Width />
</DescriptionColumn>
<ProjectColumn>
<DisplayIndex>2</DisplayIndex>
<Width />
</ProjectColumn>
<ModuleColumn>
<DisplayIndex>3</DisplayIndex>
<Width />
</ModuleColumn>
<LineNumberColumn>
<DisplayIndex>1</DisplayIndex>
<Width />
</LineNumberColumn>
</ColumnHeaderInformation>
<ColumnHeaderInformation>
  <DescriptionColumn>
	<DisplayIndex>0</DisplayIndex>
	<Width />
  </DescriptionColumn>
  <ProjectColumn>
	<DisplayIndex>2</DisplayIndex>
	<Width />
  </ProjectColumn>
  <ModuleColumn>
	<DisplayIndex>3</DisplayIndex>
	<Width />
  </ModuleColumn>
  <LineNumberColumn>
	<DisplayIndex>1</DisplayIndex>
	<Width />
  </LineNumberColumn>
</ColumnHeaderInformation>
It's either <Width /> being empty, or after confirming the paste in chat window the extra spaces on the FooBarColumn elements. 
<ColumnHeaderInformation>
  <DescriptionColumn>
    <DisplayIndex>0</DisplayIndex>
    <Width />
  </DescriptionColumn>
  <ProjectColumn>
    <DisplayIndex>2</DisplayIndex>
    <Width />
  </ProjectColumn>
  <ModuleColumn>
    <DisplayIndex>3</DisplayIndex>
    <Width />
  </ModuleColumn>
  <LineNumberColumn>
    <DisplayIndex>1</DisplayIndex>
    <Width />
  </LineNumberColumn>
</ColumnHeaderInformation>
Could it just be the tabs that's the problem? I manually spaced them so how they got there is strange.
@IvenBach That it does. Well done only-moments-ago-Iven.
 

« first day (1818 days earlier)      last day (1362 days later) »