So here is the good news.

I could create a Sp which executes the Job and also wait untill the job is run success. I have executes this proc in Sql...

Hi Rowan

Thanks for your response,

I have no issues in connecting the SQL Server Db from VBA, I have done that part by connecting through a DSN setupn on my machine.

I...

Hi,

I was just wondering to which thread does my question belong to MSAccess/Integration Services/General Sql Server?

Hence psoted in 3 areas, aplogize for the inconvinience caused!!!

HI Thanks for your response, Can you please suggest how to track whether the job is ran completely or not,

Do I need to handle this in the proc, please...

yes thanks gaz, am not using * in my actual query.. i have 150+ columns which i cant show you here in my example hence placed *....

Thanks all again, my...

Hi Gaz,

thanks for your response, I got this idea and was trying to implement the way you suggested. The query is working fine but here I am getting redundant column...

Hi, thanks for all your help..

There is no issue in the package, a i rightly posted in my last reply, it is an issue with the Sql Server agent being...

Thank you....

I don't know how far this i relevant to my problem. But i s=did attached my services screenshot, it has the logon as "NT Authority\Network Service" for all the...

Thanks for your on time response.

I have created a job using package source as file system and given the path to execute the package.

When I start the job, its failing,...