markwheeler.com - various shenanigans.

SSIS: Upload file to Sharepoint Document Library

April 17, 2013 mmwheeler

Update 4/23/2014: I have posted a new method using a Script Task. Had a request to dump a large dataset from a SQL query into a CSV file and then upload that file to a Sharepoint document library. Because the resulting file was large, I zipped the file using a […]

Downloading files from Sharepoint Library with SSIS

April 10, 2013 mmwheeler

Discovered this SSIS dataflow task called HTTPDownload. The link here is a dtsx package you can import into Visual Studio. Modify the HTTP Connection Manager with the URL of the file. Note that this has to be specific, so the source file has to be the same if we are […]

SSRS – Query for NULLs and Order by NULLs last

April 2, 2013 mmwheeler

Had a request to create a report for Project Server milestones. There was a custom enterprise column added for tasks which contained a location code. My report had to return all values including where location was NULL. The first step was to get a valid NULL parameter in my Site […]

St. Paddy’s Day Bash at Brion’s Grille

March 21, 2013 mmwheeler

See all the videos at my YouTube Channel

JQuery – Get Value of DIV with Custom Attribute

January 1, 2013 mmwheeler

I have a ProjectServer with a custom field (Project Status Slide) where users have a URL for an image. I needed to retrieve the URL from the custom field and display it inline on the ProjectDetails.aspx page <div GUID=”xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx”>http://myserver/PWA/Pictures/Slide1.png</div> The source of the custom field resembles the above. I put […]

Sharepoint 2010 SSRS Oracle Data Access Components BadImageFormatException

October 29, 2012 mmwheeler

I am using SSRS to report against an Oracle database source directly. For a while I was getting the following error. Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. Apparently there is […]

Sharepoint 2010 Email-Enabled Discussion List Content Query Web Part

October 26, 2012 mmwheeler

I had a recent request to allow supervisors to post “kudos” emails to a Sharepoint site for display on a “dashboard.” They did not want it to be labor intensive by having to logon and copy/paste email content to a list. To achieve this I created an email-enabled discussion list. […]

DIY Visual Pinball Cabinet – Part 3

October 12, 2012 mmwheeler

Here’s a play testing video.

Sharepoint 2010 Backup and Cleanup Scripts with Notifications

October 10, 2012 mmwheeler

Simple scripts that you can automate with the Task Scheduler to backup/cleanup your Sharepoint 2010 farm with email notifications. Backup Script try { $today = (Get-Date -Format dd-MM-yyyy) #Location of the Backup Folder [IO.Directory]::CreateDirectory(“E:BackupDailyFarmBackUp$today”) # This will actually initiate the SPFarm backup. Backup-SPFarm -Directory E:BackupFullFarmBackup$today -BackupMethod full # Backup-SPFarm -Directory […]

DIY Visual Pinball Cabinet – Part 2

October 2, 2012 mmwheeler

Almost there! The build is completed and painted. I got the legs attached. Still waiting for the digital plunger and motion kit. Do NOT order order directly from NanoTech Entertainment directly. Use the link above via virtuapin.net […]

markwheeler.comvarious shenanigans.