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? |
 |
| |
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. |
 |
| |
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 |
 |
| |