title: Is it possible to design SSIS packaged without using some version of Visual Studio?
body: <p>Due to company policies it's not allowed to have some kind of Visual Studio version. Is it possible to design SSIS packages without have some kind of Visual studio version?</p>
  
  <p>In my opinion. And correct me if i'm wrong:</p>
  
  <ul>
  <li><p>SQL Server : This need to have an SSIS instance and a SQL instance. SQL for storing data (not really necessary if you use a difference target) and SSIS for deploy the package to and schedule the refresh of the packages.</p></li>
  <li><p>Managment Studio : Not really needed, but handy to maintain the database.</p></li>
  <li><p>Tool to create the SSIS package. This can be achieve by:</p>
  
  <ol>
  <li>install data tools : this comes with a Visual Studio shell</li>
  <li>install Visual Studio Community : comes with the ability to open and create SSIS projected. It can be deployed from there</li>
  <li>install Visual Studio Prof : comes with the ability to open and create SSIS projects. It can be deployed from there</li>
  </ol></li>
  <li><p>Data tools is free to use can be used commercially</p></li>
  <li>Managment Studio is free and can use used commercially</li>
  <li>VS Community is free but can't be used commercially (not even in a pilot)</li>
  <li>VS Prof is not free and can be used commercially</li>
  <li>SQL Server is not free and can be used commercially</li>
  </ul>