sql server dts: I have used above exe to Install my DTS Package in SQL Server 2005.

An entry is created in the sysdtspackages90 table.

2 Questions:
1)Where in SQL Server 2005 should I be able to see the Package itself?
2) If I want to run it manually, when I double click on the dtsx file on the
Database Server I get a message asking me what program I want to open it

hi
1.-
In sysdtspackages90 there is an entry that stores the package.
Also you can see the package if you connect to ingration services, this is
when you open management studio then connect and instead of DataBase engine
you choose Integration Services and the name of the server.
2.- You can exectute packages that are store on the file system using
command line and arguments with DTEXEC, or you can use a graphic interface
to execute packages this is DTEXECUI (execute package utility) in c:\program
files\sql server 2005\90\DTS\Binn

cheers

--

Francisco A. Gonzalez
fgonzalez@solidq.com



[quoted text, click to view]