Hello,
I created one SSIS Package which convert the mbd file to SQL-2005 table.
Now i defined one job which call that package.
Now i wrote one SP which run that job using command sp_start_job.
in the same SP I checked the status of that Job, once that job successfully completed, I update the one table from whatever data inserted in that table.
Now the problem is within sp when i check the table it does not have any record but when i check the same in query analyzer it shows the data.
I even try to separate the code in another SP which update the table. But again problem remains the same.
Please help me in that.
Thanks and Regards