Link to home
Start Free TrialLog in
Avatar of Zolf
ZolfFlag for United Arab Emirates

asked on

Cannot see SSIS package in Management Studio

Hello there,

I use the manifest file to create Executable package as File System in SSMS,but for some reason I cannot see those packages in the SSMS. The default folder the wizard gets is C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\SSIS Project-FDO Report and when I go to this folder I can see those packages there, but not in the SSMS. Why is it so,what am i missing.

cheers
Zolf
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

how do you try to see these SSIS packs in SSMS exactly (there are several ways)?
is the " C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\SSIS Project-FDO Report '
your PC or server location?

if your PC and you wish this to be seen from your server:
try to use some network location and  use UNC path (with proper NTFS (note: even for a local location) and shared folder rights?
try to store SSIS packs inside of sql  server SSIS...
Avatar of Zolf

ASKER

Thanks for your comment.

how do you try to see these SSIS packs in SSMS exactly (there are several ways)?
I select the SSIS Service in SSMS and login.

is the " C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\SSIS Project-FDO Report '
your PC or server location?
Its my pc

if your PC and you wish this to be seen from your server:
I dont want to see this rom another machine. I want to see it on my own pc.

try to store SSIS packs inside of sql  server SSIS...
You mean I dont use filesystem and instead use mssql for deploy
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Zolf

ASKER

Thanks