SSIS / BIDS Rename File with File System Task

Lets see if I can explain how to rename a files using the File System Task in BIDS or SSIS. First you will need to add a File System Task to your Control Flow. (Drag and Drop it to the Form) Open the task and change the Opertaion to Rename File. Set the IsDestinationPathVariable to True and set the IsSourcePathVariable to True as well. Click SourceVariable and select from the drop down….

SharePoint 2013 Design Packages broken

We were attempting to use Responsive SharePoint from CodePlex, They’ve done a lot of heavy lifting with regards to implementing Twitter Bootstrap within SharePoint 2013. After some testing we found that certain sites were becoming corrupt and throwing Errors and Warnings. The first warning occurred after creating pages, a modal dialog would appear with the following message. Invalid field name. {50631c24-1371-4ecf-a5ae-ed41b03f4499} After doing some digging it appeared the field was missing…

TSQL: Search All Tables

/****** Object: StoredProcedure [dbo].[SearchAllTables] Script Date: 3/14/2013 8:01:42 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROC [dbo].[SearchAllTables] ( @SearchStr nvarchar(100) ) AS BEGIN — Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved. — Purpose: To search all columns of all tables for a given search string — Written by: Narayana Vyas Kondreddi — Site: http://vyaskn.tripod.com — Tested on: SQL Server 7.0 and SQL Server 2000…

SharePoint 2013 unexpected database growth

So one day, suddenly I find my development environment out of drive space, never good, but its my dev box and not a production system. So that’s the good news. Production Environment Fix(Contentdb): So I start poking around and find that the content database is bloated to 17 gigs. That’s a problem since I don’t have any real content in the database. I ran this Script and it pointed me to the…

SPWeb.Users.GetCollection does not work as expected

It appears that SPWeb.Users.GetCollection is not bound to its initialized web although SPWeb.Users[username] and SPWeb.Users.GetByEmail(email) are. The unfortunate thing, SPWeb.Users[username] and SPWeb.Users.GetByEmail(email) both throw exceptions if nothing is found. public static Boolean UserExistsbyEmail(SPWeb web, string email) {//Throws Exception if account doesn’t exsit within the SPWeb try { SPUser spu = web.Users.GetByEmail(email); } catch (Exception ex) { return false; } return true; } public static Boolean UserExistsbyUserName(SPWeb web, string userName) {//Throws…

Session State in SharePoint

I tried using Session state today in a web part I was developing, it failed, the session was always null. I followed the best practices, verified it was enabled in web.config, it wasn’t, so I turned it on. EnableSessionState=”true”.   I tried my webpart again, same thing, null. So I ran Enable-SPSessionStateService. It returned the following error.   Enable-SPSessionStateService : An update conflict has occurred, and you mustre-try this action….

SharePoint 2013 Front End Server Prep

Here’s a collection of tools that are handy to have installed on your front end servers. The first thing you’ll want to do is install a Windows SDK. The SDK package comes with a lot tools, specifically GacUtil.exe Server 2012 http://msdn.microsoft.com/en-us/windows/desktop/hh852363.aspx Server 2008 The first thing you’ll want to do is install a Windows SDK. The SDK package comes with a lot tools, specifically GacUtil.exe Server 2012 http://msdn.microsoft.com/en-us/windows/desktop/hh852363.aspx Server 2008…

SharePoint Configuration Wizard Error – The SDDL string contains an invalid SID or a SID that cannot be translated

was setting up a HyperV instance for development. Grabbed a Server 2012 Eval, threw SQL on it and installed SharePoint Foundation 2013. I was running through the configuration wizard and it was at step 8 or 9, creating Sample Data… and it threw the error below. I went digging through the logs and found this gem of information…. 04/17/2013 18:21:54 8 ERR Failed to create sample data.An exception of type…