How to Setup a VM to install TFS 2013?

Install in the following order:

• Install Windows Server 2012 Standard or Data Center Edition
• Promote the server as Domain Controller (optional)
• Install SQL SERVER 2014 Developer Edition with the features Database Engine Services, Full-text and semantic extraction for search, Analysis Services, Reporting Services - Native, Management Tools - Basic, Management Tools - Complete
• Install TFS 2013 Update 2

TF255146: Team Foundation Server requires SQL Server 2012 SP1 (11.00.3000) or greater. The SQL Server instance XXXXXXXX you supplied is version 12.0.2000.8.

This issue raised when trying to install Team Foundation Server (TFS) 2013 over SQL 2014 database. Make sure to install TFS 2013 Update 2 as it will support SQL SERVER 2014 while the previous version supports up to SQL SERVER 2012.

Continue loop in SSIS even after an Error

Scenario

Got set of messages to process using a For Loop in SSIS. But when there is an error in one message then the rest of the messages are not processed. Given the child package failed the parent package is also failed. How to continue with the messages even a message has errors?

Solution

Set the MaximumErrorCount property of the For Loop container to 0. FailPackageOnFailure: When set to True, the failure of the task or container results in the failure of the package in which it is defined. FailParentOnFailure: When set to True, the failure of the task or container results in the failure of its container. MaximumErrorCount: Property specifies the maximum number of errors that can occur before the item fails.

Get Date and TimeStamp from an FTP Server

    FtpWebRequest request = (FtpWebRequest)WebRequest.Create (serverUri);
    request.Method = WebRequestMethods.Ftp.GetDateTimestamp;
    FtpWebResponse response = (FtpWebResponse)request.GetResponse ();
    Console.WriteLine ("{0} {1}",serverUri,response.LastModified);

TF31003. Either you have not entered the necessary credentials or your user account does not have permission to connect to the Team Foundation server.

Scenario

Trying to connect to TFS 2010 using VS 2008 Team Explorer where TFS is on a different domain than the current logged in Domain.

Solution

Make sure the Server URL is the full URL along with the Team Project Collection Name. If you don't provide the Project Collection Name in the URL then you will get the above error.
http://[server name]:[port name]/tfs/[project collection name]

Also make sure to include the domain beside the user name when you are asked for credentials as the TFS server is on a different domain.
User name: domain name\username