Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  Running SSIS in Stored procedure

Author  Topic  Zainab Starting Member 1 Post Posted - 2010-07-15 : 01:42:51 Hi, I am trying to run a SSIS package from stored procedure, which reads an excel file from specified network path and uploads the data into database and also generates an error excel file and save on the same location. The problem is when i try to run the package through cmd it works perfectly but when the same is being run from stored procedure it gives error. I think there are some permission which needs to be set. Kindly help. Zainab Zummerwala