June 26, 2007 at 1:33 pm
After performing a data export and saving is as a sql server package I cannot now find my packages within Management Studio.
I have looked at all of the nodes within Management Studio (incl. both Integration Serivices and Database engines) but cannot see my packages.
Yes, I can locate my packages by executing the "Execute Package Utility" which I found here :
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\DTExecUI.exe
......but where is the icon for this in Studio Manager?
Thanks in advance
June 27, 2007 at 2:57 am
IN SQL 2005 all yur packages ar now stored in SSIS. Use can use the SSIS object explorer to look at the packages that exists in the server.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 27, 2007 at 5:03 am
yes, in SSIS I can see 2 nodes "running packages" and "stored packages" but both of these nodes are empty.
Even though when I run the Package Execute Utility (by navigating to the exe in program files).....i can see my packages.
The Sql Server 2005 is installed on a Windows Vista Ultimate machine, if this makes any difference
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply