Groups | Blog | Home
all groups > sql server dts > august 2007 >

sql server dts : SSIS:how to arrange dtsx into different folder & offline setting problem


YesGoGoGo
8/16/2007 9:37:10 AM
hi!
I have 2 questions about SSIS.

1.
In my SSIS project
there are many dtsx
can I arrange them into different folder?
like
SSIS_PROJ
|
---FolerA---DTSX1, DTSX2,DTSX3
---FolerB---DTSX4, DTSX5,DTSX6

I've tried to arrange these DTSX but failed.
I wonder if there is something like SSRS where you can arrange these
items into project
and add those projects into a solution.
Or just modify project configuration file to achieve this goal?

2.
Everytime when I open a SSIS project
It seems it will detect connections of those DTSX and the loading time
is so long
So I'll switch it to offline mode to descrease loading time
I wonder if there is a configuration file that can make offline mode
as default setting
so that I don't have to enable it every time when I open the project.

Hope anyone could give me some hint
thank you!
YesGoGoGo
8/17/2007 9:21:53 AM
[quoted text, click to view]

well...I've found this answer by myself
I always save project under "offlinemode=false"
No wonder everytime I open the project,offline mode is off
And if I want to check mapping configuration file
I can use "xxx.dtproj.user" to modify OfflineMode

but I still can't find a solution to first question.
need help~

jhofmeyr NO[at]SPAM googlemail.com
8/20/2007 2:48:00 AM
[quoted text, click to view]

Hi,

I'm not 100% sure about the standard version of BI Dev studio that
comes with SQL Server 2005, but certainly in VS2005 + TFS you can
create multiple SSIS projects within a single solution. To do so,
open you SSIS project and click File -> New -> Project (or press Ctrl
+Shift+N), type in the name for your new project and change the
Solution drop-down box from "Create new Solution" to "Add to
Solution". Click Ok and you should be good to go.

Good luck,
J
AddThis Social Bookmark Button