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.

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

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: http://blogs.msdn.com/b/buckh/archive/2008/10/23/using-team-foundation-build-with-biztalk-and-ssis-projects.aspx http://sqlblog.com/blogs/jamie_thomson/archive/2010/09/14/ssis-msbuild-task-now-included-in-msbuild-extension-pack.aspxRandy 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

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: http://blogs.msdn.com/b/buckh/archive/2008/10/23/using-team-foundation-build-with-biztalk-and-ssis-projects.aspx http://sqlblog.com/blogs/jamie_thomson/archive/2010/09/14/ssis-msbuild-task-now-included-in-msbuild-extension-pack.aspxRandy 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