How do I build SSIS packages from TFS?
-
Wednesday, March 21, 2012 7:16 PM
Techies--
In a nutshell, how do I build a 2008 BIDS created SSIS package through TFS? The normal SDLC flow in our environment is to develop our apps in Visual Studio 2010 which connects to the TFS server seamlessly--so the automation on this is clear.
What is it exactly that needs to happen with SSIS builds? I see all sorts of references online to tfs msbuild scripts--some references online discuss defining msbuild types, some discuss sidekick, etc. -- but what I really need is a simple example with a simple set of instructions to get started.
All Replies
-
Wednesday, March 21, 2012 7:23 PMModerator
Hi plditallo,
Visual Studio 2008 can only be used with SSIS 2008.
TFS is just code repository, see this answer for more info on TFS integration: http://social.msdn.microsoft.com/forums/en-US/tfsversioncontrol/thread/7c654fc1-05f9-420c-99f0-a63034f51e89
Arthur My Blog
- Edited by ArthurZMVP, Moderator Wednesday, March 21, 2012 7:23 PM
- Proposed As Answer by VivelYano Thursday, March 22, 2012 5:25 AM
-
Thursday, March 22, 2012 6:09 AM
Like Arthur said, SSIS 2008 is only compatible with VS2008.
What you probably want is do an automated build in TFS using Team Foundation Build Server. Here are some articles about it:
Randy Aldrich Paulo
MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog
BizTalk Message Archiving - SQL and File
Automating/Silent Installation of BizTalk Deployment Framework using Powershell >
Sending IDOCs using SSIS- Marked As Answer by plditallo Thursday, March 22, 2012 1:59 PM
.png)
