Is it possible to deploy file system SSIS packages from TFS?

• nmccormick

  Say Hey Kid

  Points: 700

  More actions

  January 16, 2012 at 10:40 am

  #144873

  For our data warehouse loads we use SQL Server 2008 R2 and SSIS with file system packages. We use TFS (Team Foundation Server) for version control of our SSIS package files. Currently when we do an implementation we copy the file from our personal TFS workspace to development. And for production implementation we copy from development to production. I'm very new to TFS and know just enough to check in and check out files. What I'd like to be able to do is to implement to development or production directly from TFS, not my personal workspace or development environment. Is that possible?

  Thanks,

  Nancy

• Mahesh Lakkala

  SSC Veteran

  Points: 222

  More actions

  January 20, 2012 at 3:23 am

  #1436347

  I am not aware of TFS, but basically from any source safe tool, get the latest version of the packages to a stage folder and deploy to production.