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
zolfAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
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...
zolfAuthor Commented:
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
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
ok:

you open SSMS->SSIS-> using "Import" wizard-> point to 'c:\.." and try to find DTSX  file ( There are no option for any another files extensions..)

..like in this article, right?

How to: Import or Export a Package by Using SQL Server Management Studio
https://technet.microsoft.com/en-us/library/ms141235(v=sql.105).aspx
--

try to copy these files to e.g. C:\MySSISpacks folder and try again..and try to find DTSX (SSIS extension file -- no other files are visible !)

Make sure you run SSIS as Administrator

Check SSIS service logon login - make sure it has access to the folder " C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\SSIS Project-FDO Report "

deploy into sql server SSIS directly from your BID project

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
zolfAuthor Commented:
Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.