Hi,

Please provide me the steps on how to execute the package even if the excelsheet is stored at a different location from the package. when the package is executed, it...

Hi,

what if the excel file is stored in a different location on the machine ? this is our requirement currently.

If you can provide me the steps I would be grateful...

thanks

Hi,

Will this command work if I am in another database for ex, If I am in "SQL_Training" database will it get executed in this database ? or do i need...

Hi,

I am getting this message when i executed this SP by using xp_cmdshell

"Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'xp_cmdshell'....

Hi,

can you also provide me the code on how to call dtexec in a stored procedure and run it using xp_cmdshell command . The entire code ?

Hi,

Thanks for your prompt reply.

Could you provide me the steps on how to do this in SQL Server agent ?

Hi,

In regards to running the SP, here's how i plan to do it.

- I can update or insert any row in the excelsheet and then save it.

- Next I will...