SSIS File System storage deployment
Hi
I have deployed my project through deployment utility, while installing my project on to the staging server,I have used file system deployment,
In my case insted of using default path (C:\Program Files\Microsoft SQL Server\100\DTS\Packages\Integration Services Project1) ,I had given my custom path like
(C:\Integration Services Project1) Project deployment got succeeded and as usually all packages and config files came to my custom folder, every thing is fine up to know
But
when i open SSMS (Integration services)
My project is not visible for me. why ?
when i accept the default path then every thing is fine my installed project packages are appearing under File System.
how can i see those custom folder installed packages in SSMS ?
Thanks
December 19th, 2010 6:20am
There is a file in %%system root%%\Microsoft SQL Server\100\DTS\Binn called MsDtsSrvr.ini.xml If you want custom paths in the filestore, you need to add them here, in the format
<Folder xsi:type="FileSystemFolder">
<Name>My Custom Store</Name>
<StorePath>Path To Store\Custom Store</StorePath>
</Folder>
This should be inside the <TopLevelFolders> tag
Free Windows Admin Tool Kit Click here and download it now
December 20th, 2010 10:40am
Thank you
I will check it
December 21st, 2010 1:15am