February 11, 2008 at 9:24 am
I admit a fairly new at SSIS. Once I create the package I would like via Studio Manager to connect to SSIS then find and execute the package.
For the life of me I read BOL and other web sites and how can I have the package appear in either the File or msdb folder in Integration Services via Studio Manager?
JTS
February 11, 2008 at 9:53 am
In Visual Studio
File > Save Copy of Package.dtsx as > Select SSIS Package Store as Location > Define Server and for Package Path[Click on button [.]] and now pick the folder MSDB or File System and Save.
In Managment Studio
You would need to connect to Integration Services.Expand Stored Packages.You should be able to view your package based on the location you saved it in .
Hope this helps out
[font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]
February 11, 2008 at 10:12 am
Unbelievable and yet unable to find these simple steps anywhere...
Thanks!!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply