• The query which I am using in the package is just select query -- it is not using any variables.

    it is coming from different database we are using it as a source int he package as of now I am just hardcoded in execute sql task...

    instead of hardcoding is there any option?

    can u tell me the process.any link is there to get me some idea.