Hello, I'm brand new to SSIS, so please bear with my limited knowledge and experience. I'm working through a tutorial found at http://accelebrate.com/sql_training/ssis_2008_tutorial.htm, and I can't save my package in the package store. Here's the error I get: =================================== The storage location for the folder "File System\" cannot be accessed. (Microsoft Visual Studio) ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.ExistsOnDtsServer(String sPackagePath, String sServerName) at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package) at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e) All I'm trying to do is save the package in the package store before I execute it. Any help will be greatly appreciated!

Hi, Are you connecting to a remote Integration Services Server? If yes, you need to ensure you have sufficient permission on that folder “**:\Program Files\Microsoft SQL Server\100\DTS\Packages\Admin”. If it's local machine, could you run BIDS as administrator and give another try? Or you can simply disable UAC for test. You can also try to save that package in another folder not Admin folder. Hope this helps, Raymond Raymond Li - MSFT

Hi Raymond, Thanks very much for your reply! I'm working on my local instance of SQL Server for these tutorials. I tried running BIDS as administrator, but it gave me the same error message. I also disabled the UAC, rebooted, and tried again but to no avail. As I've attempted the third option, I've realized I have a few questions about the Package Store. Is this embedded in some hidden directory within SQL Server? I tried saving it in the root of the Package Store, entitled "SSIS Packages" and it gave me this error: =================================== The path is not valid. Parameter name: packagePath (Microsoft Visual Studio) ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Server.Storage.SplitPath(String path, String paramName, String& itemName) at Microsoft.SqlServer.Dts.Server.Storage.PackageExists(String packagePath) at Microsoft.SqlServer.Dts.Runtime.Application.ExistsOnDtsServer(String sPackagePath, String sServerName) at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package) at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e) I then try to save it in the directory called "MSDB" and it gives me this error message: TITLE: Save Copy of Package ------------------------------ There already exists a package named "/MSDB/ExportDepartments" on server "BRANDON-PC". Do you want to replace it? ------------------------------ BUTTONS: &Yes &No ------------------------------ I don't know why there would be another package that has that exact same name - I haven't saved this package yet... Can you help me understand please? I don't know why this isn't working the way the tutorial says it should... Thank You, iwalkathinline

Can you check if the following directory is present \Program Files\Microsoft SQL Server\90\DTS\ if not create the DTS folder and it should workvinu

Is this embedded in some hidden directory within SQL Server? The default path is “C:\Program Files\Microsoft SQL Server\100\DTS\Packages”. Ensure you can acess to all the folder. And then try to save the package as below (notice the path): You cannot save it to the root. You can also connect to SSIS in SSMS, and the test if you can import package to the folder. Hope this helps, Raymond Raymond Li - MSFT

Let us know of this folder was there and if the issue is resolvedvinu

Any updatesvinu