anyone has experience with creating an automatic installation package with .cfm file IIS definition and to install a datasource to the DB server please share what is the best option. i have looked at a few but couldnot figure out how to make the package

What packaging tool are u using??

What packaging tool are u using??

what do u mean by a packaging tool ?? i havenot used anything what do u suggest we use ??

Best on your query, I am assuming you are installing a web project built in ColdFusion (cfm). ColdFusion is a scripting language, it does not create dlls, exes or any executables. If you are doing Adobe AIR project, that's different thing. You mentioned IIS, so must be web project.

You rather create a deployment document with step by step instructions like where to copy the files, how to setup the datasource in cfadmin (CFIDE) and what the datasource name should be and the which database it points to. Then you just zip up the ColdFusion and any include files, DML scripts that creates the tables and hand over to whoever deploying it.

that is how we do it now, but i want something that allows them to point where they want to install the files then create a def in IIS and isntall the .bak as a datasource in SQL. the only thing they would have to do is define a Datasource in cf admin. Does that sound doable ??