You are right, and admin doesn't get sysadmin by default... and I had to set the server to a single user mode, added a sysadmin with command line 🙁 ...

it's fixed... believe it or not, I got the another 2005 DTS msi file from Microsoft, installed it, and everything started to work, on both 2005 & 2008 SSMS, same...

hmm... I have both 2005 & 2008 SSMS installed in my Win7 PC, also installed both BC & DTS designer. How can you tell which instance it applied to?

sorry, I think I put it in a wrong way... shouldn't call it error message.

In 2008 SSMS, I go under 'Management', then 'Legacy', expand 'Data Transformation Services', all DTS packages...

np... just so frustrated, DTS was working w/ 2008 before my system crashed yesterday. That's why I have to reinstall and redo everything... I remember I had the same issues...

it's the same message:

SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature....

it works 🙂 thanks,

I think crdate from sysobjects is for table, not column.

I also looked at INFORMATION_SCHEMA.COLUMNS, but there is no creation date 🙁

any other suggestion...

i use a third party reporting tools, check it out if you want 🙂