Using TFS as source control in SSMS

Step 1: Download TFS provider

Step 2: Close SSMS for TFS provider installation

 

http://www.techtree.co.uk/sql-server/management-studio-ssms/use-team-foundation-server-tfs-as-your-source-control-in-ssms/

Relative paths in SSIS

BIDS Helper contains the feature and this is quite useful in terms of SSIS deployment

 

https://bidshelper.codeplex.com/wikipage?title=Fix%20Relative%20Paths

http://www.artisconsulting.com/blogs/greggalloway/2008/7/13/relative-paths-in-ssis

When ssis package has been deployed to target server and referenced by a SQL server job, misleading error information occurs

When a SSIS package has been deployed to target SSIS server, it was running fine under SSIS 2012 designer.  When running designer, this package will be running under the windows credentials . When I create a sql job to run the package, it always gave me an error and this error message was always complaining  about one specific SP syntax. After spending 2 days troubleshooting, I realize that there was nothing wrong with the SP, it was the Sql agent account which is the sql server service account that does not have permission on some folder in a remote server. After I’ve put this Service account in the admin group of that Remote server, the sql job runs without an issue.

Lessoned learned : 1. If ssis package contains folder access, always make sure which account this pkg will be run under. Does this account have access to the folder specified?

SSIS 2012 Moving and Resizing tips

when I was working with SSDT-BI VS2012, I was often disappointed the GUI. Sometimes, I need to move object around or resize but the object will simply fly off to the remote area… blog from andy shed some useful hints

http://sqlblog.com/blogs/andy_leonard/archive/2012/03/20/ssis-2012-moving-and-resizing.aspx

 

also some workaround

 

1. to realign task to the top

Create an empty task (doesnt matter) in the top left corner - then zoom out of ure project .. ctrl+click the new task, and the next one down - then go to format - remove - vertical spacing and it will lock everything back to the  top

2. To move object around, ctrl+direction Arrow, it’s slow but working

3. to resize an object, alt+direction Arrow

 

4. Use format –> auto Layout –> diagram will bring everything back but your object size and annotation will be totally screwed up.This is usually the last resort, strongly no recommended!!

SSIS Error Message

https://msdn.microsoft.com/en-us/library/ms345164.aspx