 | |
Run a DTS Package from a web server
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Run a DTS Package from a web server -
08-18-2004
, 01:21 PM
#2
| |||
| |||
|
|
I have an asp.net website that accesses a SQL Server on a separate box. I created a DTS and through code run the package. The code does not produce any error but the task within the package does not run. I also get this effect if I try to run the package through Enterprise Manager on any other workstation other than the SQL Server. I'm guessing this is a permissions issue, but I am unable to find which permissions to change. Please Help. Thanks -- Stephen Perotti Senior Programmer/Analyst |
#3
| |||
| |||
|
|
Thanks for your response. Actually, the package runs without errors. It says that it was completed successfully, but none of the steps in the package has run. This happens when I try to run it in design mode, from the code on the website, or by choosing Execute Package. I understand that DTS packages are client-side in context of the SQL Server box. But, I should be able to execute the package through code when the SQL Server is on another box. The code does run fine and the package executes just fine if website and SQL Server are on the same box. "Allan Mitchell" wrote: DTS is client side so everything you do is in the context of the box on which you are running the package. To troubleshoot this Run the package in EM through designer. What does not run? Does it error or just become blacked out which says that it did not execute? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "sperotti" <sperotti (AT) discussions (DOT) microsoft.com> wrote in message news  49C0959-2E4B-46F7-AA5A-482C8C3E3D3D (AT) microsoft (DOT) com...I have an asp.net website that accesses a SQL Server on a separate box. I created a DTS and through code run the package. The code does not produce any error but the task within the package does not run. I also get this effect if I try to run the package through Enterprise Manager on any other workstation other than the SQL Server. I'm guessing this is a permissions issue, but I am unable to find which permissions to change. Please Help. Thanks -- Stephen Perotti Senior Programmer/Analyst |
#4
| |||
| |||
|
|
Ah OK If it runs when everything is co-located then it has to do with 2 things 1. The IIS Account that is being used ti logon to SQL Server OR 2. Do you have the DTS dlls on your Source boxes? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "sperotti" <sperotti (AT) discussions (DOT) microsoft.com> wrote in message news:E2A2F251-CC78-4615-B1A0-67042E6722CA (AT) microsoft (DOT) com... Thanks for your response. Actually, the package runs without errors. It says that it was completed successfully, but none of the steps in the package has run. This happens when I try to run it in design mode, from the code on the website, or by choosing Execute Package. I understand that DTS packages are client-side in context of the SQL Server box. But, I should be able to execute the package through code when the SQL Server is on another box. The code does run fine and the package executes just fine if website and SQL Server are on the same box. "Allan Mitchell" wrote: DTS is client side so everything you do is in the context of the box on which you are running the package. To troubleshoot this Run the package in EM through designer. What does not run? Does it error or just become blacked out which says that it did not execute? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "sperotti" <sperotti (AT) discussions (DOT) microsoft.com> wrote in message news 49C0959-2E4B-46F7-AA5A-482C8C3E3D3D (AT) microsoft (DOT) com...I have an asp.net website that accesses a SQL Server on a separate box. I created a DTS and through code run the package. The code does not produce any error but the task within the package does not run. I also get this effect if I try to run the package through Enterprise Manager on any other workstation other than the SQL Server. I'm guessing this is a permissions issue, but I am unable to find which permissions to change. Please Help. Thanks -- Stephen Perotti Senior Programmer/Analyst |
#5
| |||
| |||
|
|
Well, I have tried both of those things and it doesn't work. I did try an experiment to see if the problem was in the package itself. I called a different package that just runs a simple SQL query. When I call this package from code it works fine. The package that I want to call has an activex task in it. The activex code will not run within a package when called from a remote server. Any thoughts? "Allan Mitchell" wrote: Ah OK If it runs when everything is co-located then it has to do with 2 things 1. The IIS Account that is being used ti logon to SQL Server OR 2. Do you have the DTS dlls on your Source boxes? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "sperotti" <sperotti (AT) discussions (DOT) microsoft.com> wrote in message news:E2A2F251-CC78-4615-B1A0-67042E6722CA (AT) microsoft (DOT) com... Thanks for your response. Actually, the package runs without errors. It says that it was completed successfully, but none of the steps in the package has run. This happens when I try to run it in design mode, from the code on the website, or by choosing Execute Package. I understand that DTS packages are client-side in context of the SQL Server box. But, I should be able to execute the package through code when the SQL Server is on another box. The code does run fine and the package executes just fine if website and SQL Server are on the same box. "Allan Mitchell" wrote: DTS is client side so everything you do is in the context of the box on which you are running the package. To troubleshoot this Run the package in EM through designer. What does not run? Does it error or just become blacked out which says that it did not execute? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "sperotti" <sperotti (AT) discussions (DOT) microsoft.com> wrote in message news 49C0959-2E4B-46F7-AA5A-482C8C3E3D3D (AT) microsoft (DOT) com...I have an asp.net website that accesses a SQL Server on a separate box. I created a DTS and through code run the package. The code does not produce any error but the task within the package does not run. I also get this effect if I try to run the package through Enterprise Manager on any other workstation other than the SQL Server. I'm guessing this is a permissions issue, but I am unable to find which permissions to change. Please Help. Thanks -- Stephen Perotti Senior Programmer/Analyst |
#6
| |||
| |||
|
|
And the ActiveX task does what? Are you using anything that is server specific i.e. a custom dll or a path relevant only to the server? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "sperotti" <sperotti (AT) discussions (DOT) microsoft.com> wrote in message news 358748A-8F27-4950-8F56-EFBEA7E0DA1B (AT) microsoft (DOT) com...Well, I have tried both of those things and it doesn't work. I did try an experiment to see if the problem was in the package itself. I called a different package that just runs a simple SQL query. When I call this package from code it works fine. The package that I want to call has an activex task in it. The activex code will not run within a package when called from a remote server. Any thoughts? "Allan Mitchell" wrote: Ah OK If it runs when everything is co-located then it has to do with 2 things 1. The IIS Account that is being used ti logon to SQL Server OR 2. Do you have the DTS dlls on your Source boxes? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "sperotti" <sperotti (AT) discussions (DOT) microsoft.com> wrote in message news:E2A2F251-CC78-4615-B1A0-67042E6722CA (AT) microsoft (DOT) com... Thanks for your response. Actually, the package runs without errors. It says that it was completed successfully, but none of the steps in the package has run. This happens when I try to run it in design mode, from the code on the website, or by choosing Execute Package. I understand that DTS packages are client-side in context of the SQL Server box. But, I should be able to execute the package through code when the SQL Server is on another box. The code does run fine and the package executes just fine if website and SQL Server are on the same box. "Allan Mitchell" wrote: DTS is client side so everything you do is in the context of the box on which you are running the package. To troubleshoot this Run the package in EM through designer. What does not run? Does it error or just become blacked out which says that it did not execute? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "sperotti" <sperotti (AT) discussions (DOT) microsoft.com> wrote in message news 49C0959-2E4B-46F7-AA5A-482C8C3E3D3D (AT) microsoft (DOT) com...I have an asp.net website that accesses a SQL Server on a separate box. I created a DTS and through code run the package. The code does not produce any error but the task within the package does not run. I also get this effect if I try to run the package through Enterprise Manager on any other workstation other than the SQL Server. I'm guessing this is a permissions issue, but I am unable to find which permissions to change. Please Help. Thanks -- Stephen Perotti Senior Programmer/Analyst |
#7
| |||
| |||
|
|
The activex task is a parser program. It does reference a third-party ..dll on the SQL Server and parses x12 files. "Allan Mitchell" wrote: And the ActiveX task does what? Are you using anything that is server specific i.e. a custom dll or a path relevant only to the server? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "sperotti" <sperotti (AT) discussions (DOT) microsoft.com> wrote in message news 358748A-8F27-4950-8F56-EFBEA7E0DA1B (AT) microsoft (DOT) com...Well, I have tried both of those things and it doesn't work. I did try an experiment to see if the problem was in the package itself. I called a different package that just runs a simple SQL query. When I call this package from code it works fine. The package that I want to call has an activex task in it. The activex code will not run within a package when called from a remote server. Any thoughts? "Allan Mitchell" wrote: Ah OK If it runs when everything is co-located then it has to do with 2 things 1. The IIS Account that is being used ti logon to SQL Server OR 2. Do you have the DTS dlls on your Source boxes? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "sperotti" <sperotti (AT) discussions (DOT) microsoft.com> wrote in message news:E2A2F251-CC78-4615-B1A0-67042E6722CA (AT) microsoft (DOT) com... Thanks for your response. Actually, the package runs without errors. It says that it was completed successfully, but none of the steps in the package has run. This happens when I try to run it in design mode, from the code on the website, or by choosing Execute Package. I understand that DTS packages are client-side in context of the SQL Server box. But, I should be able to execute the package through code when the SQL Server is on another box. The code does run fine and the package executes just fine if website and SQL Server are on the same box. "Allan Mitchell" wrote: DTS is client side so everything you do is in the context of the box on which you are running the package. To troubleshoot this Run the package in EM through designer. What does not run? Does it error or just become blacked out which says that it did not execute? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "sperotti" <sperotti (AT) discussions (DOT) microsoft.com> wrote in message news 49C0959-2E4B-46F7-AA5A-482C8C3E3D3D (AT) microsoft (DOT) com...I have an asp.net website that accesses a SQL Server on a separate box. I created a DTS and through code run the package. The code does not produce any error but the task within the package does not run. I also get this effect if I try to run the package through Enterprise Manager on any other workstation other than the SQL Server. I'm guessing this is a permissions issue, but I am unable to find which permissions to change. Please Help. Thanks -- Stephen Perotti Senior Programmer/Analyst |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.