Create New SSIS Package - From "New File" Option - No Project - Ulysses

08-May-08 11:27:02
Is there a way to simply create a SSIS package file without having to create
a project in BIDS.  Is there a way to add the "New SSIS Package" option to
the File>>New>>File dialog such that you do not have to create a new project
every time you need to create a simple SSIS package?
button
 
 

Create New SSIS Package - From "New File" Option - No Project - Ulysses

08-May-08 05:25:54
It's not that its a big deal from a generic perspective, its just an extra
step that I would like to omit if possible.  The only real sore spot I have
with putting SSIS packages in a project is that you have to declare a start
package when you want to run the entire package and if you have several
projects within your project this can sometimes get overlooked and you
actually end up running a package unintentionally.

So do you have a way to provide the ability to create a "New SSIS Package"
from the File>>New>>File dialog or not?
button
 

Create New SSIS Package - From "New File" Option - No Project - York

09-May-08 07:28:41
This is like "Can I create a web page (aspx file) without creating a
web project/solution?). What's the big deal of creating an integration
service project? It takes a few seconds. You can keep multiple
packages or delete the old one before creating a new for easier
testing.

BTW, if you open an existing package (dtsx file) without going through
the project, you will lose lots of IDE support like building, step-by-
step debugging, etc.
button
 

Create New SSIS Package - From "New File" Option - No Project - jhofmey

09-May-08 07:28:46
AFAIK there is no way to create a package without having it belong to
a project.  I usually just have a generic SSIS solution/project that I
use to develop new packages in, and then I move these to the relevant
solution/project once I am happy with it.

That might be too many steps for your liking, but I prefer to work
quite methodically ... it helps me avoid making mistakes and catch
issues early.

Good luck!
J
button
 
SSIS 2005 - Native OLE DB\SQL Native Client