The scenario – “I” get a daily feed from SAP of who has accounts on that system…But, the file name is generated automatically by SAP. So, it varies from day to day – and is NOT based on the date time stamp. So, basically, let’s consider it to be random. Using this reference: http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html I [...]

Very briefly, the last logon time stamp is something like the number of milliseconds since Jan 1, 1601 (something to do with the Year 2000 Bug and that was ANSI’s solution to it) So, to get the last logon date (I didn’t bother with the hours minutes and seconds) I pull in the lastlogondatestamp as [...]

I was intimidated by the whole XMLAO thing, but it’s really not that bad once you get some experience with it. I will flesh this out over the next several days, so this first post will be a little cryptic. Start by adding an ADO data source connection. I set mine to pass the workflow [...]