January 18, 2013 at 7:12 am
I have 2 servers, one for the database and the other for the web apps. Both server are in different domains and Im trying to execute a ssis package using a stored procedure to call dtexec utility like this:
SET @dtsCmd = 'dtexec /F "C:\MyFolder\MyPackage.dtsx"
When the SP is executed from the web app it will run fine without any errors but is not running any of the package tasks. But if if execute the SP in SSMS it works fine and the package tasks are executed. Thank you for your help.
January 28, 2013 at 5:48 am
What exactly are the package tasks?
Does the webapp user have the required privileges to execute the package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 5:56 am
Hello, the package task is to import a excel file to a table. The webapp user connects to the database using a sql server user that have privileges. The dtexec is executed trough the xp_cmdshell proxy account.
January 28, 2013 at 6:08 am
Does the proxy account have permission on the C:\MyFolder\ directory?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 6:35 am
Yes, it is a local admin user that has full control on that folder.
January 28, 2013 at 6:39 am
If you launch SSMS using that proxy account, can you run the sp?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 7:10 am
Yes I can run the SP with the proxy account (local admin account) and it works fine.
January 28, 2013 at 7:15 am
Anything weird that pops up in the logging?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 7:45 am
I could not find anything neither in the sql server logs nor in the event viewer. :crazy:
January 28, 2013 at 7:47 am
Did you enable logging in the SSIS package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 7:53 am
I dont know how to do it... I will read about it and get back to you, please don't go too far away and thank you for your help.
January 28, 2013 at 9:07 am
Logging is working now but is not logging anything at all when the SP is executed from the website but when I execute the Sp from SSMS I see a lot of informational messages and no errors.
January 28, 2013 at 1:43 pm
DiegoPeña (1/28/2013)
Logging is working now but is not logging anything at all when the SP is executed from the website but when I execute the Sp from SSMS I see a lot of informational messages and no errors.
Not logging anything at all? It should at least log the beginning and end of the package run.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 1:49 pm
Yeah, its really weird, I just dont know what to do.
Viewing 14 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy