BOL has the following information for packagetype: The client that created the package. The values are as follows: 0 (default client), 1 (SQL Server Import and Export Wizard), 2 (DTS Designer in SQL Server 2000), 3 (SQL Server Replication), 5 (SSIS Designer), and 6 (Maintenance Plan Designer). What does default client mean?

It is reserved for the "Undefined" case. Reference source: http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtspackagetype.aspx Arthur My Blog

Besides those 5 tools, what are other MS tools for creating SSIS packages? Does "Undefined" simply mean non-MS tools? It is kind of odd that the value 4 is skipped.

This is a use of package, not tools a package was created with. You can set this property yourself in BIDS to whatever value.Arthur My Blog