The Pragmatic Works Foundation was created to find passionate people who are interested in joining the technology field but cannot make the financial investments needed for training and hardware. Working with our job placement partners our goal is to place all candidates who complete training with a new career in technology. What does it involve? After submitting a personal profile to be considered, qualified candidates will be selected to attend an orientation. The purpose of the orientation is...
Read More
I was working on a package that would need the date appended to a .csv file. My source was from two csv files and my destination was to a brand new csv file. To append the date, I needed to create an expresion. My file name and file path wer both in a variable. I tried a couple of times on my own with no success. I keep misplacing my \\, then didn't put my double"" in the right places. I was getting pretty frustrated, but here is how I figured it out. I did an internet search on appending dates ...
A quick view of common SSAS Definitions: I used the definitions from the Microsoft's website and added the images to it.
The other day while working at a client site, we were creating SSIS packages that would execute using TSQL in order to load a database. We wanted to eliminate having a bunch of different shared data sources and then having to create configuration files for each of the data sources. The reason being is that we created a database (we'll call it Database B) in SSMS that was housing just the stored procedures. Those stored procedures were being called on by Database A (existing database) to load ano...