again, i do appreciate all your help and feedback. can't thx ya enough for that 🙂

thx for all your help guys, i do appreciate it very very much...

so you are saying i CANNOT use EXEC [DATABASEname](which is a variable in my case).[schema].storedprocname

it. it supposed to be two different execute sql tasks separately it won't be dynamic, correct..

do appreciate your prompt response. also wondering, after loading data into tables, i do want to go back to control flow and run the stored procedure in both databases. so...

i do apologize for not being very detailed.

i have multiple databases in my sql server instance. in my case sample & tsql2012 is my target not all the databases....