No, you don’t need VS 2008 to use DTLoggedExec.
If you want to use it with SQL Server 2008/2008 R2 you just have to use the correct .manifest file. You can read how to do it here:
Let me know if it works.
Thanks for the guidance. Followed the steps and could get these done
1. execute the package from the command prompt
2. Created the database by using the create db script
But, I could not get a understanding on how to use the tool on a whole. What is the next step ?
How to profile the ssis package and get the profile data loaded into the database ?
Once again, thanks