I am using SQL Server 2000 and I have a created a DTS package that
copies Data from a Excel Spreasheet to a SQL Server table then executes
a user Stored Proc
What I am wanting to do is if for some reason the Stored Proc errors
out because of bad data , I would like to see the errors reported in a
file so that it can be reviewed and I was not sure if there is a way to
output the errors in DTS. When I run the Stored Proc theough Query
Analyzer I see the errors in Query Analyzer, I basically want to see
the same information after running the DTS. Can this be done, if so
how.
Any help in this regard is greatly appreciated.
ThanksI would use the DTSRUN command to execute the DTS package. On the DTSRUN
command you can use the /L option to create a log froma DTS package.
"shub" wrote:
> I am using SQL Server 2000 and I have a created a DTS package that
> copies Data from a Excel Spreasheet to a SQL Server table then executes
> a user Stored Proc
> What I am wanting to do is if for some reason the Stored Proc errors
> out because of bad data , I would like to see the errors reported in a
> file so that it can be reviewed and I was not sure if there is a way to
> output the errors in DTS. When I run the Stored Proc theough Query
> Analyzer I see the errors in Query Analyzer, I basically want to see
> the same information after running the DTS. Can this be done, if so
> how.
> Any help in this regard is greatly appreciated.
> Thanks
>|||Thanks Greg for your response. I will definitely look at that option.
Is there any way this option could be incorporated when executed
through enterprise manager.
Greg Larsen wrote:
> I would use the DTSRUN command to execute the DTS package. On the DTSRUN
> command you can use the /L option to create a log froma DTS package.
> "shub" wrote:
> > I am using SQL Server 2000 and I have a created a DTS package that
> > copies Data from a Excel Spreasheet to a SQL Server table then executes
> > a user Stored Proc
> > What I am wanting to do is if for some reason the Stored Proc errors
> > out because of bad data , I would like to see the errors reported in a
> > file so that it can be reviewed and I was not sure if there is a way to
> > output the errors in DTS. When I run the Stored Proc theough Query
> > Analyzer I see the errors in Query Analyzer, I basically want to see
> > the same information after running the DTS. Can this be done, if so
> > how.
> >
> > Any help in this regard is greatly appreciated.
> > Thanks
> >
> >|||I don't know of any way, sorry.
"shub" wrote:
> Thanks Greg for your response. I will definitely look at that option.
> Is there any way this option could be incorporated when executed
> through enterprise manager.
> Greg Larsen wrote:
> > I would use the DTSRUN command to execute the DTS package. On the DTSRUN
> > command you can use the /L option to create a log froma DTS package.
> >
> > "shub" wrote:
> >
> > > I am using SQL Server 2000 and I have a created a DTS package that
> > > copies Data from a Excel Spreasheet to a SQL Server table then executes
> > > a user Stored Proc
> > > What I am wanting to do is if for some reason the Stored Proc errors
> > > out because of bad data , I would like to see the errors reported in a
> > > file so that it can be reviewed and I was not sure if there is a way to
> > > output the errors in DTS. When I run the Stored Proc theough Query
> > > Analyzer I see the errors in Query Analyzer, I basically want to see
> > > the same information after running the DTS. Can this be done, if so
> > > how.
> > >
> > > Any help in this regard is greatly appreciated.
> > > Thanks
> > >
> > >
>|||Hi Greg,
Yes, if you open up your DTS package and go to Package => Properties you
will see a tab for 'Logging', in the 'Error Handling' section you can specify
a file to log to. Just remember that the file is always appended to and not
overwritten.
Ray
"shub" wrote:
> Thanks Greg for your response. I will definitely look at that option.
> Is there any way this option could be incorporated when executed
> through enterprise manager.
> Greg Larsen wrote:
> > I would use the DTSRUN command to execute the DTS package. On the DTSRUN
> > command you can use the /L option to create a log froma DTS package.
> >
> > "shub" wrote:
> >
> > > I am using SQL Server 2000 and I have a created a DTS package that
> > > copies Data from a Excel Spreasheet to a SQL Server table then executes
> > > a user Stored Proc
> > > What I am wanting to do is if for some reason the Stored Proc errors
> > > out because of bad data , I would like to see the errors reported in a
> > > file so that it can be reviewed and I was not sure if there is a way to
> > > output the errors in DTS. When I run the Stored Proc theough Query
> > > Analyzer I see the errors in Query Analyzer, I basically want to see
> > > the same information after running the DTS. Can this be done, if so
> > > how.
> > >
> > > Any help in this regard is greatly appreciated.
> > > Thanks
> > >
> > >
>|||Thanks Ray. I tried using that however when there are multiple errorrs
it is displaying only the first error. For example in my case the DTS
package executes a stored proc to add logins from the table but in some
cases because of typos the proc cannot grant access because it cannot
find the user account in the domain, but if there are multiple errors
it is displaying the very firts one but when I run the same stored proc
through Query analyzer I see all the errors and I need to see all the
errors so that it can be informed that there are wrong entries in the
table.
Any ideas? Here is the only error I am getting
Step 'DTSStep_DTSExecuteSQLTask_2' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution.
(Microsoft OLE DB Provider for SQL Server (80040e14): Windows NT user
or group 'YYY\XXX' not found. Check the name again.)
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100
****************************************************************************************************
rb wrote:
> Hi Greg,
> Yes, if you open up your DTS package and go to Package => Properties you
> will see a tab for 'Logging', in the 'Error Handling' section you can specify
> a file to log to. Just remember that the file is always appended to and not
> overwritten.
> Ray
> "shub" wrote:
> > Thanks Greg for your response. I will definitely look at that option.
> > Is there any way this option could be incorporated when executed
> > through enterprise manager.
> > Greg Larsen wrote:
> > > I would use the DTSRUN command to execute the DTS package. On the DTSRUN
> > > command you can use the /L option to create a log froma DTS package.
> > >
> > > "shub" wrote:
> > >
> > > > I am using SQL Server 2000 and I have a created a DTS package that
> > > > copies Data from a Excel Spreasheet to a SQL Server table then executes
> > > > a user Stored Proc
> > > > What I am wanting to do is if for some reason the Stored Proc errors
> > > > out because of bad data , I would like to see the errors reported in a
> > > > file so that it can be reviewed and I was not sure if there is a way to
> > > > output the errors in DTS. When I run the Stored Proc theough Query
> > > > Analyzer I see the errors in Query Analyzer, I basically want to see
> > > > the same information after running the DTS. Can this be done, if so
> > > > how.
> > > >
> > > > Any help in this regard is greatly appreciated.
> > > > Thanks
> > > >
> > > >
> >
> >
Showing posts with label user. Show all posts
Showing posts with label user. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
DTS problem
Hi,
I am trying to export data into EXCEL sheet using DTS, It is working fine
for single user, however it fails with error messages when tried by multiple
users at the same time...So is it limitation of DTS as it does not run
simultaneously ?Is the destination Excel Workbook the same for all users?
If it is, then that's why the DTS package fails. If that's not the case,
please post the actual error message.
ML|||Hi ML,
It is the same excel but user can change the path and each one is exporting
it in different folders, so I feel it should not be the case.
Errors is shown like :
"Microsoft Database Engine canot open the file ", It is already opened
exculisevely by another user, or you need permission to view data.
Is this because every user is using single user(user name + pwd, is provided
thru config file), with special permission, to fetch data from different
tables.
Thanks
"ML" wrote:
> Is the destination Excel Workbook the same for all users?
> If it is, then that's why the DTS package fails. If that's not the case,
> please post the actual error message.
>
> ML|||Judging by the error message all users are trying to access the same Excel
file.
You say they have the option of changing the output path - at what point in
time are they allowed to change it? Before or after executing the DTS packag
e?
ML|||It is through input box, which is displayed through VB script and that is th
e
part of DTS package. So It happens during the execution of DTS package.
"ML" wrote:
> Judging by the error message all users are trying to access the same Excel
> file.
> You say they have the option of changing the output path - at what point i
n
> time are they allowed to change it? Before or after executing the DTS pack
age?
>
> ML|||If the error occurs before this VB script is executed, then the connection t
o
the Excel file is made before the user selects the output file - which means
the connection is made to the same file for each user.
However, if the error occurs after the user has selected a different output
file, then it seems that the connection is not made to the file the user
selected.
Maybe you could create a new file for each user at the beginning of the
package, and establish a connection dynamically:
1) open a new file using VBS;
2) name the file by embedding the user's name and a timestamp (e.g.
"Output_John_200510301255.xls");
3) passing the filename as a global variable to the data connection.
ML
I am trying to export data into EXCEL sheet using DTS, It is working fine
for single user, however it fails with error messages when tried by multiple
users at the same time...So is it limitation of DTS as it does not run
simultaneously ?Is the destination Excel Workbook the same for all users?
If it is, then that's why the DTS package fails. If that's not the case,
please post the actual error message.
ML|||Hi ML,
It is the same excel but user can change the path and each one is exporting
it in different folders, so I feel it should not be the case.
Errors is shown like :
"Microsoft Database Engine canot open the file ", It is already opened
exculisevely by another user, or you need permission to view data.
Is this because every user is using single user(user name + pwd, is provided
thru config file), with special permission, to fetch data from different
tables.
Thanks
"ML" wrote:
> Is the destination Excel Workbook the same for all users?
> If it is, then that's why the DTS package fails. If that's not the case,
> please post the actual error message.
>
> ML|||Judging by the error message all users are trying to access the same Excel
file.
You say they have the option of changing the output path - at what point in
time are they allowed to change it? Before or after executing the DTS packag
e?
ML|||It is through input box, which is displayed through VB script and that is th
e
part of DTS package. So It happens during the execution of DTS package.
"ML" wrote:
> Judging by the error message all users are trying to access the same Excel
> file.
> You say they have the option of changing the output path - at what point i
n
> time are they allowed to change it? Before or after executing the DTS pack
age?
>
> ML|||If the error occurs before this VB script is executed, then the connection t
o
the Excel file is made before the user selects the output file - which means
the connection is made to the same file for each user.
However, if the error occurs after the user has selected a different output
file, then it seems that the connection is not made to the file the user
selected.
Maybe you could create a new file for each user at the beginning of the
package, and establish a connection dynamically:
1) open a new file using VBS;
2) name the file by embedding the user's name and a timestamp (e.g.
"Output_John_200510301255.xls");
3) passing the filename as a global variable to the data connection.
ML
DTS Permissions
Hello all
Hope someone can help, I have set up a new user and restricted his acces to the db,
how can I allow him to read DTS packages but not change or execute them?
Thanks
Richard
Hey Richie,Which version of SQL Server are you using?|||IF those DTS package is owned by SA and scheduled as a job then you need to give this user permission in TARGETSERVERROLE role.
DTS Permissions
Hello all
Hope someone can help, I have set up a new user and restricted his acces to the db,
how can I allow him to read DTS packages but not change or execute them?
Thanks
Richard
Hey Richie,Which version of SQL Server are you using?|||IF those DTS package is owned by SA and scheduled as a job then you need to give this user permission in TARGETSERVERROLE role.
DTS permission
I created a DTS package to extract data to a text file.
I want to create a login for a user who should be able ONLY to run this DTS. I don't want to give him/her any access to any database .
Is that possible?
Thanks in advance
GiorgioWithout permission on database user cannot complete the execution of DTS package.|||I find out a workaround:
1) I created a user that has permission only on the sample DB Northwind.
2) The DTS package is protected by "DTS Owner password" and DTS User password
3) The "Connection" in the DTS package has inside a username and password that has acess to the appropriate DB.
With this workaround I obtained that:
1) The user has access only to the Northwind DB
2) The user can run only the DTS package (because is protected with DTS User password).
Thanks anyway to everyone who replied to me!|||Then my reply was intended to light when you said no permission to any database.
I want to create a login for a user who should be able ONLY to run this DTS. I don't want to give him/her any access to any database .
Is that possible?
Thanks in advance
GiorgioWithout permission on database user cannot complete the execution of DTS package.|||I find out a workaround:
1) I created a user that has permission only on the sample DB Northwind.
2) The DTS package is protected by "DTS Owner password" and DTS User password
3) The "Connection" in the DTS package has inside a username and password that has acess to the appropriate DB.
With this workaround I obtained that:
1) The user has access only to the Northwind DB
2) The user can run only the DTS package (because is protected with DTS User password).
Thanks anyway to everyone who replied to me!|||Then my reply was intended to light when you said no permission to any database.
Thursday, March 22, 2012
dts parameter
I am running the DTS as follows,
SET @.CMD = 'dtsrun /S '+@.server+' /U '+@.user+' /P '+@.pass+' /N '+@.dtsn+' /A MyBinaryID:19 = '+@.MyBinaryID
EXECUTE master..xp_cmdshell @.CMD
This does not return all the data correctly.MyBinaryIDis a Binary(8) field, any idea how should I pass MyBinaryID and define what type of parameter in the DTS?
In the DTS package, set the Global Variable MyBinary to Integer type, and map it to the parameter used in your query. For example I use such query in a Execute SQL Task in DTS:
UPDATE tbl_DTS
SET name='xxx'
WHERE CONVERT(BIGINT,MyBinaryID)= ?
And I map the MyBinary Global Variable to Parameter1. Declare @.MyBinaryID as BIGINT in T-SQL and assign a proper value to it (of cource the value of @.MyBinary need to be some value converted from the BINARY(8) data). Then set the @.CMD as following:
SET @.CMD = 'dtsrun /S'+@.server+' /U'+@.user+' /P'+@.pass+' /N'+@.dtsn+' /A MyBinaryID= '
+CONVERT(VARCHAR,@.MyBinaryID)
EXEC master..xp_cmdshell @.CMD
DTS PACKAGES SECURITY ISSUE
Hi,
I need to give access to a user to use enterprise manager to create DTS
packages within a single database. However I have a problem that he can still
see other DTS packages and open them. IS there any way of restricting the DTS
packages so that he can only see what he had created and not others?
Thanks
Anp
Hi
It is not a good idea to develop DTS packages against a live system. You may
want to create a safe environment on a different server for this person to
work with.
John
"Anup" wrote:
> Hi,
> I need to give access to a user to use enterprise manager to create DTS
> packages within a single database. However I have a problem that he can still
> see other DTS packages and open them. IS there any way of restricting the DTS
> packages so that he can only see what he had created and not others?
> Thanks
> Anp
|||Additionally, you can secure DTS packages with DTS package
passwords. You can find explanations of this in books online
under the topic: Handling Package Security in DTS
-Sue
On Wed, 17 Aug 2005 23:11:01 -0700, "Anup"
<Anup@.discussions.microsoft.com> wrote:
>Hi,
>I need to give access to a user to use enterprise manager to create DTS
>packages within a single database. However I have a problem that he can still
>see other DTS packages and open them. IS there any way of restricting the DTS
>packages so that he can only see what he had created and not others?
>Thanks
>Anp
sqlsql
I need to give access to a user to use enterprise manager to create DTS
packages within a single database. However I have a problem that he can still
see other DTS packages and open them. IS there any way of restricting the DTS
packages so that he can only see what he had created and not others?
Thanks
Anp
Hi
It is not a good idea to develop DTS packages against a live system. You may
want to create a safe environment on a different server for this person to
work with.
John
"Anup" wrote:
> Hi,
> I need to give access to a user to use enterprise manager to create DTS
> packages within a single database. However I have a problem that he can still
> see other DTS packages and open them. IS there any way of restricting the DTS
> packages so that he can only see what he had created and not others?
> Thanks
> Anp
|||Additionally, you can secure DTS packages with DTS package
passwords. You can find explanations of this in books online
under the topic: Handling Package Security in DTS
-Sue
On Wed, 17 Aug 2005 23:11:01 -0700, "Anup"
<Anup@.discussions.microsoft.com> wrote:
>Hi,
>I need to give access to a user to use enterprise manager to create DTS
>packages within a single database. However I have a problem that he can still
>see other DTS packages and open them. IS there any way of restricting the DTS
>packages so that he can only see what he had created and not others?
>Thanks
>Anp
sqlsql
DTS PACKAGES SECURITY ISSUE
Hi,
I need to give access to a user to use enterprise manager to create DTS
packages within a single database. However I have a problem that he can still
see other DTS packages and open them. IS there any way of restricting the DTS
packages so that he can only see what he had created and not others?
Thanks
AnpHi
It is not a good idea to develop DTS packages against a live system. You may
want to create a safe environment on a different server for this person to
work with.
John
"Anup" wrote:
> Hi,
> I need to give access to a user to use enterprise manager to create DTS
> packages within a single database. However I have a problem that he can still
> see other DTS packages and open them. IS there any way of restricting the DTS
> packages so that he can only see what he had created and not others?
> Thanks
> Anp|||Additionally, you can secure DTS packages with DTS package
passwords. You can find explanations of this in books online
under the topic: Handling Package Security in DTS
-Sue
On Wed, 17 Aug 2005 23:11:01 -0700, "Anup"
<Anup@.discussions.microsoft.com> wrote:
>Hi,
>I need to give access to a user to use enterprise manager to create DTS
>packages within a single database. However I have a problem that he can still
>see other DTS packages and open them. IS there any way of restricting the DTS
>packages so that he can only see what he had created and not others?
>Thanks
>Anp
I need to give access to a user to use enterprise manager to create DTS
packages within a single database. However I have a problem that he can still
see other DTS packages and open them. IS there any way of restricting the DTS
packages so that he can only see what he had created and not others?
Thanks
AnpHi
It is not a good idea to develop DTS packages against a live system. You may
want to create a safe environment on a different server for this person to
work with.
John
"Anup" wrote:
> Hi,
> I need to give access to a user to use enterprise manager to create DTS
> packages within a single database. However I have a problem that he can still
> see other DTS packages and open them. IS there any way of restricting the DTS
> packages so that he can only see what he had created and not others?
> Thanks
> Anp|||Additionally, you can secure DTS packages with DTS package
passwords. You can find explanations of this in books online
under the topic: Handling Package Security in DTS
-Sue
On Wed, 17 Aug 2005 23:11:01 -0700, "Anup"
<Anup@.discussions.microsoft.com> wrote:
>Hi,
>I need to give access to a user to use enterprise manager to create DTS
>packages within a single database. However I have a problem that he can still
>see other DTS packages and open them. IS there any way of restricting the DTS
>packages so that he can only see what he had created and not others?
>Thanks
>Anp
DTS PACKAGES SECURITY ISSUE
Hi,
I need to give access to a user to use enterprise manager to create DTS
packages within a single database. However I have a problem that he can stil
l
see other DTS packages and open them. IS there any way of restricting the DT
S
packages so that he can only see what he had created and not others?
Thanks
AnpHi
It is not a good idea to develop DTS packages against a live system. You may
want to create a safe environment on a different server for this person to
work with.
John
"Anup" wrote:
> Hi,
> I need to give access to a user to use enterprise manager to create DTS
> packages within a single database. However I have a problem that he can st
ill
> see other DTS packages and open them. IS there any way of restricting the
DTS
> packages so that he can only see what he had created and not others?
> Thanks
> Anp|||Additionally, you can secure DTS packages with DTS package
passwords. You can find explanations of this in books online
under the topic: Handling Package Security in DTS
-Sue
On Wed, 17 Aug 2005 23:11:01 -0700, "Anup"
<Anup@.discussions.microsoft.com> wrote:
>Hi,
>I need to give access to a user to use enterprise manager to create DTS
>packages within a single database. However I have a problem that he can sti
ll
>see other DTS packages and open them. IS there any way of restricting the D
TS
>packages so that he can only see what he had created and not others?
>Thanks
>Anp
I need to give access to a user to use enterprise manager to create DTS
packages within a single database. However I have a problem that he can stil
l
see other DTS packages and open them. IS there any way of restricting the DT
S
packages so that he can only see what he had created and not others?
Thanks
AnpHi
It is not a good idea to develop DTS packages against a live system. You may
want to create a safe environment on a different server for this person to
work with.
John
"Anup" wrote:
> Hi,
> I need to give access to a user to use enterprise manager to create DTS
> packages within a single database. However I have a problem that he can st
ill
> see other DTS packages and open them. IS there any way of restricting the
DTS
> packages so that he can only see what he had created and not others?
> Thanks
> Anp|||Additionally, you can secure DTS packages with DTS package
passwords. You can find explanations of this in books online
under the topic: Handling Package Security in DTS
-Sue
On Wed, 17 Aug 2005 23:11:01 -0700, "Anup"
<Anup@.discussions.microsoft.com> wrote:
>Hi,
>I need to give access to a user to use enterprise manager to create DTS
>packages within a single database. However I have a problem that he can sti
ll
>see other DTS packages and open them. IS there any way of restricting the D
TS
>packages so that he can only see what he had created and not others?
>Thanks
>Anp
Monday, March 19, 2012
dts package runs ok but job fails
Using SS 2000 SP3. I get this error message:
Executed as user: COLUSSUS\sqlserveragent. ...DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
(800403FE) Error string: Error Code: 0 Error Source= Microsoft
VBScript runtime error Error Description: Permission denied: 'CreateObject'
Error on Line 76 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 4500
Error Detail Records: Error: -2147220482 (800403FE); Provider
Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
VBScript runtime error Error Description: Permission denied: 'CreateObject'
Error on Line 76 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 4500
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 Error: -2147220440
(80040428); Provider Error: 0 (0) Error string: Package failed
becau... Process Exit Code 1. The step failed.
The line in the code is: set fsObj =
CreateObject("Scripting.FilesystemObject")
The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
that specific user security rights to read and execute to the entire drive
but I still get the error.
Any ideas?
Thanks,
Dan D.
If I were you, I'd install SP4 first. I had a similar problem. Tasks
worked, ran, but at the very end of package execution it just dropped off
the end of the package code and crashed. SP4 fixed my problem. You might
have a different problem and you can find more by opening your package and
going into "Package Properties." Goto the "Logging" tab and turn on
logging. Run the task as normal and then open the log by right clicking on
the package name in EM and clicking on "Package Logs..." Goto the last one
on the list (more than likely "Version 1") and expand it. Open the last one
listed and see if any particular task failed with an error. If no tasks
actually failed, then SP4 is probably the only thing that will fix it. If a
task did fail, read the error and either post it here or fix it yourself.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
> Using SS 2000 SP3. I get this error message:
> Executed as user: COLUSSUS\sqlserveragent.
> ...DTSStep_DTSActiveScriptTask_1
> DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
> (800403FE) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> Error Detail Records: Error: -2147220482 (800403FE); Provider
> Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
> Error: -2147220440
> (80040428); Provider Error: 0 (0) Error string: Package failed
> becau... Process Exit Code 1. The step failed.
> The line in the code is: set fsObj =
> CreateObject("Scripting.FilesystemObject")
> The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
> that specific user security rights to read and execute to the entire drive
> but I still get the error.
> Any ideas?
> Thanks,
> --
> Dan D.
|||Dan:
BTW, your sqlserveragent has way too many privaledges. If you want to know
more, check out this link:
http://msdn.microsoft.com/library/de...rview_6k1f.asp
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
> Using SS 2000 SP3. I get this error message:
> Executed as user: COLUSSUS\sqlserveragent.
> ...DTSStep_DTSActiveScriptTask_1
> DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
> (800403FE) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> Error Detail Records: Error: -2147220482 (800403FE); Provider
> Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
> Error: -2147220440
> (80040428); Provider Error: 0 (0) Error string: Package failed
> becau... Process Exit Code 1. The step failed.
> The line in the code is: set fsObj =
> CreateObject("Scripting.FilesystemObject")
> The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
> that specific user security rights to read and execute to the entire drive
> but I still get the error.
> Any ideas?
> Thanks,
> --
> Dan D.
|||There's only one step in the package. I know what and where the error is I
just don't know how to fix it.
Dan D.
"Wm. Scott Miller" wrote:
> If I were you, I'd install SP4 first. I had a similar problem. Tasks
> worked, ran, but at the very end of package execution it just dropped off
> the end of the package code and crashed. SP4 fixed my problem. You might
> have a different problem and you can find more by opening your package and
> going into "Package Properties." Goto the "Logging" tab and turn on
> logging. Run the task as normal and then open the log by right clicking on
> the package name in EM and clicking on "Package Logs..." Goto the last one
> on the list (more than likely "Version 1") and expand it. Open the last one
> listed and see if any particular task failed with an error. If no tasks
> actually failed, then SP4 is probably the only thing that will fix it. If a
> task did fail, read the error and either post it here or fix it yourself.
> Scott
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
>
>
|||I realize this but since the problem is permissions I was trying to get the
job to run and then worry about cutting back permissions.
Thanks,
Dan D.
"Wm. Scott Miller" wrote:
> Dan:
> BTW, your sqlserveragent has way too many privaledges. If you want to know
> more, check out this link:
> http://msdn.microsoft.com/library/de...rview_6k1f.asp
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
>
>
|||OK. Create a new package. Put an ActiveX script object in it and paste the
following code into it:
--Begin Copy--
'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Option Explicit
Function Main()
Dim oFileSystem
Set oFileSystem = CreateObject("Scripting.FileSystemObject")
Set oFileSystem = Nothing
Main = DTSTaskExecResult_Success
End Function
--End Copy--
Now try to run this package as you did the first. Did it run? If so, your
76th line of code is not the problem and it is a problem somewhere else in
the code. If it fails, try to get it to run using various computers (your
desktop, server, etc.) and user ids (Administrator, your id, Agent id, etc).
Let me know how it goes. You can also open up the registry and search for
the phrase "Scripting.FileSystemObject" on the server to see if it is there.
I'd still suggest turning logging on your package on. This gives much more
detailed errors than the abbreviated errors given by the Job History viewer.
I use it on most packages that I schedule as jobs. That way I can get
detailed errors and exactly where in the package a failure occurred. Great
development tool. You can always turn it back off and can always delete the
logs if you wish.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9BBEF554-FC57-4AA0-89A8-1A3CB520BF36@.microsoft.com...[vbcol=seagreen]
> There's only one step in the package. I know what and where the error is I
> just don't know how to fix it.
> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
|||That was a good suggestion. You were right about the error message being
misleading. The script you sent ran fine.
I have logging turned on for all of our packages but the message is
essentially the same. Here it is:
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Permission denied: 'CreateObject'
Error on Line 76
Step Error code: 800403FE
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4500
I'll get the programmer to build the code one piece at a time so we can find
out where the error is really happening.
Thanks for your help.
Dan D.
"Wm. Scott Miller" wrote:
> OK. Create a new package. Put an ActiveX script object in it and paste the
> following code into it:
> --Begin Copy--
> '************************************************* *********************
> ' Visual Basic ActiveX Script
> '************************************************* ***********************
> Option Explicit
> Function Main()
> Dim oFileSystem
> Set oFileSystem = CreateObject("Scripting.FileSystemObject")
> Set oFileSystem = Nothing
> Main = DTSTaskExecResult_Success
> End Function
> --End Copy--
> Now try to run this package as you did the first. Did it run? If so, your
> 76th line of code is not the problem and it is a problem somewhere else in
> the code. If it fails, try to get it to run using various computers (your
> desktop, server, etc.) and user ids (Administrator, your id, Agent id, etc).
> Let me know how it goes. You can also open up the registry and search for
> the phrase "Scripting.FileSystemObject" on the server to see if it is there.
> I'd still suggest turning logging on your package on. This gives much more
> detailed errors than the abbreviated errors given by the Job History viewer.
> I use it on most packages that I schedule as jobs. That way I can get
> detailed errors and exactly where in the package a failure occurred. Great
> development tool. You can always turn it back off and can always delete the
> logs if you wish.
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9BBEF554-FC57-4AA0-89A8-1A3CB520BF36@.microsoft.com...
>
>
|||I know this sounds crazy, but humor me. Cut your ActiveX script in its
entirety to notepad. Save your package without anything in it (may have to
just paste my code in there so it will save). Now select it all in notepad
and copy and paste it back. Does it run? If so, somehow in writing, you
got a special character embeded in the ActiveX script task. If not, it is
an actual coding error. I've had this happen twice to me so far in 5 years.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9C7F17A5-3A3E-4465-9A4E-B66B8D215B2D@.microsoft.com...[vbcol=seagreen]
> That was a good suggestion. You were right about the error message being
> misleading. The script you sent ran fine.
> I have logging turned on for all of our packages but the message is
> essentially the same. Here it is:
> Step Error Source: Microsoft Data Transformation Services (DTS) Package
> Step Error Description:Error Code: 0
> Error Source= Microsoft VBScript runtime error
> Error Description: Permission denied: 'CreateObject'
> Error on Line 76
> Step Error code: 800403FE
> Step Error Help File:sqldts80.hlp
> Step Error Help Context ID:4500
> I'll get the programmer to build the code one piece at a time so we can
> find
> out where the error is really happening.
> Thanks for your help.
> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
|||Good try but no cigar.
Same error.
Dan D.
"Wm. Scott Miller" wrote:
> I know this sounds crazy, but humor me. Cut your ActiveX script in its
> entirety to notepad. Save your package without anything in it (may have to
> just paste my code in there so it will save). Now select it all in notepad
> and copy and paste it back. Does it run? If so, somehow in writing, you
> got a special character embeded in the ActiveX script task. If not, it is
> an actual coding error. I've had this happen twice to me so far in 5 years.
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9C7F17A5-3A3E-4465-9A4E-B66B8D215B2D@.microsoft.com...
>
>
|||Too bad. One should always try the easy fix first.... :-) Only other
suggestion is the cut and paste line by line or block by block and see which
paste causes the problem then go from there. That will at least give you a
clue where to look.
Good luck on fixing the task,
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:328C5286-92B5-4290-9C3E-FE9FD45974D6@.microsoft.com...[vbcol=seagreen]
> Good try but no cigar. Same error.
> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
Executed as user: COLUSSUS\sqlserveragent. ...DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
(800403FE) Error string: Error Code: 0 Error Source= Microsoft
VBScript runtime error Error Description: Permission denied: 'CreateObject'
Error on Line 76 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 4500
Error Detail Records: Error: -2147220482 (800403FE); Provider
Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
VBScript runtime error Error Description: Permission denied: 'CreateObject'
Error on Line 76 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 4500
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 Error: -2147220440
(80040428); Provider Error: 0 (0) Error string: Package failed
becau... Process Exit Code 1. The step failed.
The line in the code is: set fsObj =
CreateObject("Scripting.FilesystemObject")
The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
that specific user security rights to read and execute to the entire drive
but I still get the error.
Any ideas?
Thanks,
Dan D.
If I were you, I'd install SP4 first. I had a similar problem. Tasks
worked, ran, but at the very end of package execution it just dropped off
the end of the package code and crashed. SP4 fixed my problem. You might
have a different problem and you can find more by opening your package and
going into "Package Properties." Goto the "Logging" tab and turn on
logging. Run the task as normal and then open the log by right clicking on
the package name in EM and clicking on "Package Logs..." Goto the last one
on the list (more than likely "Version 1") and expand it. Open the last one
listed and see if any particular task failed with an error. If no tasks
actually failed, then SP4 is probably the only thing that will fix it. If a
task did fail, read the error and either post it here or fix it yourself.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
> Using SS 2000 SP3. I get this error message:
> Executed as user: COLUSSUS\sqlserveragent.
> ...DTSStep_DTSActiveScriptTask_1
> DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
> (800403FE) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> Error Detail Records: Error: -2147220482 (800403FE); Provider
> Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
> Error: -2147220440
> (80040428); Provider Error: 0 (0) Error string: Package failed
> becau... Process Exit Code 1. The step failed.
> The line in the code is: set fsObj =
> CreateObject("Scripting.FilesystemObject")
> The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
> that specific user security rights to read and execute to the entire drive
> but I still get the error.
> Any ideas?
> Thanks,
> --
> Dan D.
|||Dan:
BTW, your sqlserveragent has way too many privaledges. If you want to know
more, check out this link:
http://msdn.microsoft.com/library/de...rview_6k1f.asp
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
> Using SS 2000 SP3. I get this error message:
> Executed as user: COLUSSUS\sqlserveragent.
> ...DTSStep_DTSActiveScriptTask_1
> DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
> (800403FE) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> Error Detail Records: Error: -2147220482 (800403FE); Provider
> Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
> Error: -2147220440
> (80040428); Provider Error: 0 (0) Error string: Package failed
> becau... Process Exit Code 1. The step failed.
> The line in the code is: set fsObj =
> CreateObject("Scripting.FilesystemObject")
> The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
> that specific user security rights to read and execute to the entire drive
> but I still get the error.
> Any ideas?
> Thanks,
> --
> Dan D.
|||There's only one step in the package. I know what and where the error is I
just don't know how to fix it.
Dan D.
"Wm. Scott Miller" wrote:
> If I were you, I'd install SP4 first. I had a similar problem. Tasks
> worked, ran, but at the very end of package execution it just dropped off
> the end of the package code and crashed. SP4 fixed my problem. You might
> have a different problem and you can find more by opening your package and
> going into "Package Properties." Goto the "Logging" tab and turn on
> logging. Run the task as normal and then open the log by right clicking on
> the package name in EM and clicking on "Package Logs..." Goto the last one
> on the list (more than likely "Version 1") and expand it. Open the last one
> listed and see if any particular task failed with an error. If no tasks
> actually failed, then SP4 is probably the only thing that will fix it. If a
> task did fail, read the error and either post it here or fix it yourself.
> Scott
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
>
>
|||I realize this but since the problem is permissions I was trying to get the
job to run and then worry about cutting back permissions.
Thanks,
Dan D.
"Wm. Scott Miller" wrote:
> Dan:
> BTW, your sqlserveragent has way too many privaledges. If you want to know
> more, check out this link:
> http://msdn.microsoft.com/library/de...rview_6k1f.asp
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
>
>
|||OK. Create a new package. Put an ActiveX script object in it and paste the
following code into it:
--Begin Copy--
'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Option Explicit
Function Main()
Dim oFileSystem
Set oFileSystem = CreateObject("Scripting.FileSystemObject")
Set oFileSystem = Nothing
Main = DTSTaskExecResult_Success
End Function
--End Copy--
Now try to run this package as you did the first. Did it run? If so, your
76th line of code is not the problem and it is a problem somewhere else in
the code. If it fails, try to get it to run using various computers (your
desktop, server, etc.) and user ids (Administrator, your id, Agent id, etc).
Let me know how it goes. You can also open up the registry and search for
the phrase "Scripting.FileSystemObject" on the server to see if it is there.
I'd still suggest turning logging on your package on. This gives much more
detailed errors than the abbreviated errors given by the Job History viewer.
I use it on most packages that I schedule as jobs. That way I can get
detailed errors and exactly where in the package a failure occurred. Great
development tool. You can always turn it back off and can always delete the
logs if you wish.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9BBEF554-FC57-4AA0-89A8-1A3CB520BF36@.microsoft.com...[vbcol=seagreen]
> There's only one step in the package. I know what and where the error is I
> just don't know how to fix it.
> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
|||That was a good suggestion. You were right about the error message being
misleading. The script you sent ran fine.
I have logging turned on for all of our packages but the message is
essentially the same. Here it is:
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Permission denied: 'CreateObject'
Error on Line 76
Step Error code: 800403FE
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4500
I'll get the programmer to build the code one piece at a time so we can find
out where the error is really happening.
Thanks for your help.
Dan D.
"Wm. Scott Miller" wrote:
> OK. Create a new package. Put an ActiveX script object in it and paste the
> following code into it:
> --Begin Copy--
> '************************************************* *********************
> ' Visual Basic ActiveX Script
> '************************************************* ***********************
> Option Explicit
> Function Main()
> Dim oFileSystem
> Set oFileSystem = CreateObject("Scripting.FileSystemObject")
> Set oFileSystem = Nothing
> Main = DTSTaskExecResult_Success
> End Function
> --End Copy--
> Now try to run this package as you did the first. Did it run? If so, your
> 76th line of code is not the problem and it is a problem somewhere else in
> the code. If it fails, try to get it to run using various computers (your
> desktop, server, etc.) and user ids (Administrator, your id, Agent id, etc).
> Let me know how it goes. You can also open up the registry and search for
> the phrase "Scripting.FileSystemObject" on the server to see if it is there.
> I'd still suggest turning logging on your package on. This gives much more
> detailed errors than the abbreviated errors given by the Job History viewer.
> I use it on most packages that I schedule as jobs. That way I can get
> detailed errors and exactly where in the package a failure occurred. Great
> development tool. You can always turn it back off and can always delete the
> logs if you wish.
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9BBEF554-FC57-4AA0-89A8-1A3CB520BF36@.microsoft.com...
>
>
|||I know this sounds crazy, but humor me. Cut your ActiveX script in its
entirety to notepad. Save your package without anything in it (may have to
just paste my code in there so it will save). Now select it all in notepad
and copy and paste it back. Does it run? If so, somehow in writing, you
got a special character embeded in the ActiveX script task. If not, it is
an actual coding error. I've had this happen twice to me so far in 5 years.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9C7F17A5-3A3E-4465-9A4E-B66B8D215B2D@.microsoft.com...[vbcol=seagreen]
> That was a good suggestion. You were right about the error message being
> misleading. The script you sent ran fine.
> I have logging turned on for all of our packages but the message is
> essentially the same. Here it is:
> Step Error Source: Microsoft Data Transformation Services (DTS) Package
> Step Error Description:Error Code: 0
> Error Source= Microsoft VBScript runtime error
> Error Description: Permission denied: 'CreateObject'
> Error on Line 76
> Step Error code: 800403FE
> Step Error Help File:sqldts80.hlp
> Step Error Help Context ID:4500
> I'll get the programmer to build the code one piece at a time so we can
> find
> out where the error is really happening.
> Thanks for your help.
> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
|||Good try but no cigar.
Same error.Dan D.
"Wm. Scott Miller" wrote:
> I know this sounds crazy, but humor me. Cut your ActiveX script in its
> entirety to notepad. Save your package without anything in it (may have to
> just paste my code in there so it will save). Now select it all in notepad
> and copy and paste it back. Does it run? If so, somehow in writing, you
> got a special character embeded in the ActiveX script task. If not, it is
> an actual coding error. I've had this happen twice to me so far in 5 years.
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9C7F17A5-3A3E-4465-9A4E-B66B8D215B2D@.microsoft.com...
>
>
|||Too bad. One should always try the easy fix first.... :-) Only other
suggestion is the cut and paste line by line or block by block and see which
paste causes the problem then go from there. That will at least give you a
clue where to look.
Good luck on fixing the task,
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:328C5286-92B5-4290-9C3E-FE9FD45974D6@.microsoft.com...[vbcol=seagreen]
> Good try but no cigar.
Same error.> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
dts package runs ok but job fails
Using SS 2000 SP3. I get this error message:
Executed as user: COLUSSUS\sqlserveragent. ...DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
(800403FE) Error string: Error Code: 0 Error Source= Microsoft
VBScript runtime error Error Description: Permission denied: 'CreateObject
'
Error on Line 76 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 450
0
Error Detail Records: Error: -2147220482 (800403FE); Provider
Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
VBScript runtime error Error Description: Permission denied: 'CreateObject
'
Error on Line 76 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 450
0
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 Error: -2147220440
(80040428); Provider Error: 0 (0) Error string: Package failed
becau... Process Exit Code 1. The step failed.
The line in the code is: set fsObj =
CreateObject("Scripting.FilesystemObject")
The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
that specific user security rights to read and execute to the entire drive
but I still get the error.
Any ideas?
Thanks,
--
Dan D.If I were you, I'd install SP4 first. I had a similar problem. Tasks
worked, ran, but at the very end of package execution it just dropped off
the end of the package code and crashed. SP4 fixed my problem. You might
have a different problem and you can find more by opening your package and
going into "Package Properties." Goto the "Logging" tab and turn on
logging. Run the task as normal and then open the log by right clicking on
the package name in EM and clicking on "Package Logs..." Goto the last one
on the list (more than likely "Version 1") and expand it. Open the last one
listed and see if any particular task failed with an error. If no tasks
actually failed, then SP4 is probably the only thing that will fix it. If a
task did fail, read the error and either post it here or fix it yourself.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
> Using SS 2000 SP3. I get this error message:
> Executed as user: COLUSSUS\sqlserveragent.
> ...DTSStep_DTSActiveScriptTask_1
> DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
> (800403FE) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> Error Detail Records: Error: -2147220482 (800403FE); Provider
> Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
> Error: -2147220440
> (80040428); Provider Error: 0 (0) Error string: Package failed
> becau... Process Exit Code 1. The step failed.
> The line in the code is: set fsObj =
> CreateObject("Scripting.FilesystemObject")
> The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
> that specific user security rights to read and execute to the entire drive
> but I still get the error.
> Any ideas?
> Thanks,
> --
> Dan D.|||Dan:
BTW, your sqlserveragent has way too many privaledges. If you want to know
more, check out this link:
http://msdn.microsoft.com/library/d.../>
ew_6k1f.asp
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
> Using SS 2000 SP3. I get this error message:
> Executed as user: COLUSSUS\sqlserveragent.
> ...DTSStep_DTSActiveScriptTask_1
> DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
> (800403FE) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> Error Detail Records: Error: -2147220482 (800403FE); Provider
> Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
> Error: -2147220440
> (80040428); Provider Error: 0 (0) Error string: Package failed
> becau... Process Exit Code 1. The step failed.
> The line in the code is: set fsObj =
> CreateObject("Scripting.FilesystemObject")
> The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
> that specific user security rights to read and execute to the entire drive
> but I still get the error.
> Any ideas?
> Thanks,
> --
> Dan D.|||There's only one step in the package. I know what and where the error is I
just don't know how to fix it.
--
Dan D.
"Wm. Scott Miller" wrote:
> If I were you, I'd install SP4 first. I had a similar problem. Tasks
> worked, ran, but at the very end of package execution it just dropped off
> the end of the package code and crashed. SP4 fixed my problem. You might
> have a different problem and you can find more by opening your package and
> going into "Package Properties." Goto the "Logging" tab and turn on
> logging. Run the task as normal and then open the log by right clicking o
n
> the package name in EM and clicking on "Package Logs..." Goto the last on
e
> on the list (more than likely "Version 1") and expand it. Open the last o
ne
> listed and see if any particular task failed with an error. If no tasks
> actually failed, then SP4 is probably the only thing that will fix it. If
a
> task did fail, read the error and either post it here or fix it yourself.
> Scott
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
>
>|||I realize this but since the problem is permissions I was trying to get the
job to run and then worry about cutting back permissions.
Thanks,
--
Dan D.
"Wm. Scott Miller" wrote:
> Dan:
> BTW, your sqlserveragent has way too many privaledges. If you want to kno
w
> more, check out this link:
> http://msdn.microsoft.com/library/d...
view_6k1f.asp
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
>
>|||OK. Create a new package. Put an ActiveX script object in it and paste the
following code into it:
--Begin Copy--
'***************************************
*******************************
' Visual Basic ActiveX Script
'***************************************
*********************************
Option Explicit
Function Main()
Dim oFileSystem
Set oFileSystem = CreateObject("Scripting.FileSystemObject")
Set oFileSystem = Nothing
Main = DTSTaskExecResult_Success
End Function
--End Copy--
Now try to run this package as you did the first. Did it run? If so, your
76th line of code is not the problem and it is a problem somewhere else in
the code. If it fails, try to get it to run using various computers (your
desktop, server, etc.) and user ids (Administrator, your id, Agent id, etc).
Let me know how it goes. You can also open up the registry and search for
the phrase "Scripting.FileSystemObject" on the server to see if it is there.
I'd still suggest turning logging on your package on. This gives much more
detailed errors than the abbreviated errors given by the Job History viewer.
I use it on most packages that I schedule as jobs. That way I can get
detailed errors and exactly where in the package a failure occurred. Great
development tool. You can always turn it back off and can always delete the
logs if you wish.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9BBEF554-FC57-4AA0-89A8-1A3CB520BF36@.microsoft.com...[vbcol=seagreen]
> There's only one step in the package. I know what and where the error is I
> just don't know how to fix it.
> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
>|||That was a good suggestion. You were right about the error message being
misleading. The script you sent ran fine.
I have logging turned on for all of our packages but the message is
essentially the same. Here it is:
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Permission denied: 'CreateObject'
Error on Line 76
Step Error code: 800403FE
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4500
I'll get the programmer to build the code one piece at a time so we can find
out where the error is really happening.
Thanks for your help.
--
Dan D.
"Wm. Scott Miller" wrote:
> OK. Create a new package. Put an ActiveX script object in it and paste t
he
> following code into it:
> --Begin Copy--
> '***************************************
*******************************
> ' Visual Basic ActiveX Script
> '***************************************
*********************************
> Option Explicit
> Function Main()
> Dim oFileSystem
> Set oFileSystem = CreateObject("Scripting.FileSystemObject")
> Set oFileSystem = Nothing
> Main = DTSTaskExecResult_Success
> End Function
> --End Copy--
> Now try to run this package as you did the first. Did it run? If so, you
r
> 76th line of code is not the problem and it is a problem somewhere else in
> the code. If it fails, try to get it to run using various computers (your
> desktop, server, etc.) and user ids (Administrator, your id, Agent id, etc
).
> Let me know how it goes. You can also open up the registry and search for
> the phrase "Scripting.FileSystemObject" on the server to see if it is ther
e.
> I'd still suggest turning logging on your package on. This gives much mor
e
> detailed errors than the abbreviated errors given by the Job History viewe
r.
> I use it on most packages that I schedule as jobs. That way I can get
> detailed errors and exactly where in the package a failure occurred. Grea
t
> development tool. You can always turn it back off and can always delete t
he
> logs if you wish.
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9BBEF554-FC57-4AA0-89A8-1A3CB520BF36@.microsoft.com...
>
>|||I know this sounds crazy, but humor me. Cut your ActiveX script in its
entirety to notepad. Save your package without anything in it (may have to
just paste my code in there so it will save). Now select it all in notepad
and copy and paste it back. Does it run? If so, somehow in writing, you
got a special character embeded in the ActiveX script task. If not, it is
an actual coding error. I've had this happen twice to me so far in 5 years.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9C7F17A5-3A3E-4465-9A4E-B66B8D215B2D@.microsoft.com...[vbcol=seagreen]
> That was a good suggestion. You were right about the error message being
> misleading. The script you sent ran fine.
> I have logging turned on for all of our packages but the message is
> essentially the same. Here it is:
> Step Error Source: Microsoft Data Transformation Services (DTS) Package
> Step Error Description:Error Code: 0
> Error Source= Microsoft VBScript runtime error
> Error Description: Permission denied: 'CreateObject'
> Error on Line 76
> Step Error code: 800403FE
> Step Error Help File:sqldts80.hlp
> Step Error Help Context ID:4500
> I'll get the programmer to build the code one piece at a time so we can
> find
> out where the error is really happening.
> Thanks for your help.
> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
>|||Good try but no cigar. Same error.
--
Dan D.
"Wm. Scott Miller" wrote:
> I know this sounds crazy, but humor me. Cut your ActiveX script in its
> entirety to notepad. Save your package without anything in it (may have t
o
> just paste my code in there so it will save). Now select it all in notepa
d
> and copy and paste it back. Does it run? If so, somehow in writing, you
> got a special character embeded in the ActiveX script task. If not, it is
> an actual coding error. I've had this happen twice to me so far in 5 year
s.
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9C7F17A5-3A3E-4465-9A4E-B66B8D215B2D@.microsoft.com...
>
>|||Too bad. One should always try the easy fix first.... :-) Only other
suggestion is the cut and paste line by line or block by block and see which
paste causes the problem then go from there. That will at least give you a
clue where to look.
Good luck on fixing the task,
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:328C5286-92B5-4290-9C3E-FE9FD45974D6@.microsoft.com...[vbcol=seagreen]
> Good try but no cigar. Same error.
> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
>
Executed as user: COLUSSUS\sqlserveragent. ...DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
(800403FE) Error string: Error Code: 0 Error Source= Microsoft
VBScript runtime error Error Description: Permission denied: 'CreateObject
'
Error on Line 76 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 450
0
Error Detail Records: Error: -2147220482 (800403FE); Provider
Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
VBScript runtime error Error Description: Permission denied: 'CreateObject
'
Error on Line 76 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 450
0
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 Error: -2147220440
(80040428); Provider Error: 0 (0) Error string: Package failed
becau... Process Exit Code 1. The step failed.
The line in the code is: set fsObj =
CreateObject("Scripting.FilesystemObject")
The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
that specific user security rights to read and execute to the entire drive
but I still get the error.
Any ideas?
Thanks,
--
Dan D.If I were you, I'd install SP4 first. I had a similar problem. Tasks
worked, ran, but at the very end of package execution it just dropped off
the end of the package code and crashed. SP4 fixed my problem. You might
have a different problem and you can find more by opening your package and
going into "Package Properties." Goto the "Logging" tab and turn on
logging. Run the task as normal and then open the log by right clicking on
the package name in EM and clicking on "Package Logs..." Goto the last one
on the list (more than likely "Version 1") and expand it. Open the last one
listed and see if any particular task failed with an error. If no tasks
actually failed, then SP4 is probably the only thing that will fix it. If a
task did fail, read the error and either post it here or fix it yourself.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
> Using SS 2000 SP3. I get this error message:
> Executed as user: COLUSSUS\sqlserveragent.
> ...DTSStep_DTSActiveScriptTask_1
> DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
> (800403FE) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> Error Detail Records: Error: -2147220482 (800403FE); Provider
> Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
> Error: -2147220440
> (80040428); Provider Error: 0 (0) Error string: Package failed
> becau... Process Exit Code 1. The step failed.
> The line in the code is: set fsObj =
> CreateObject("Scripting.FilesystemObject")
> The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
> that specific user security rights to read and execute to the entire drive
> but I still get the error.
> Any ideas?
> Thanks,
> --
> Dan D.|||Dan:
BTW, your sqlserveragent has way too many privaledges. If you want to know
more, check out this link:
http://msdn.microsoft.com/library/d.../>
ew_6k1f.asp
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
> Using SS 2000 SP3. I get this error message:
> Executed as user: COLUSSUS\sqlserveragent.
> ...DTSStep_DTSActiveScriptTask_1
> DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482
> (800403FE) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> Error Detail Records: Error: -2147220482 (800403FE); Provider
> Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft
> VBScript runtime error Error Description: Permission denied:
> 'CreateObject'
> Error on Line 76 Error source: Microsoft Data Transformation
> Services (DTS) Package Help file: sqldts80.hlp Help context:
> 4500
> DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
> Error: -2147220440
> (80040428); Provider Error: 0 (0) Error string: Package failed
> becau... Process Exit Code 1. The step failed.
> The line in the code is: set fsObj =
> CreateObject("Scripting.FilesystemObject")
> The user "COLUSSUS\sqlserveragent" is in the admin group but I even gave
> that specific user security rights to read and execute to the entire drive
> but I still get the error.
> Any ideas?
> Thanks,
> --
> Dan D.|||There's only one step in the package. I know what and where the error is I
just don't know how to fix it.
--
Dan D.
"Wm. Scott Miller" wrote:
> If I were you, I'd install SP4 first. I had a similar problem. Tasks
> worked, ran, but at the very end of package execution it just dropped off
> the end of the package code and crashed. SP4 fixed my problem. You might
> have a different problem and you can find more by opening your package and
> going into "Package Properties." Goto the "Logging" tab and turn on
> logging. Run the task as normal and then open the log by right clicking o
n
> the package name in EM and clicking on "Package Logs..." Goto the last on
e
> on the list (more than likely "Version 1") and expand it. Open the last o
ne
> listed and see if any particular task failed with an error. If no tasks
> actually failed, then SP4 is probably the only thing that will fix it. If
a
> task did fail, read the error and either post it here or fix it yourself.
> Scott
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
>
>|||I realize this but since the problem is permissions I was trying to get the
job to run and then worry about cutting back permissions.
Thanks,
--
Dan D.
"Wm. Scott Miller" wrote:
> Dan:
> BTW, your sqlserveragent has way too many privaledges. If you want to kno
w
> more, check out this link:
> http://msdn.microsoft.com/library/d...
view_6k1f.asp
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:AC07DDED-9AF4-481B-A896-4417800A9E4D@.microsoft.com...
>
>|||OK. Create a new package. Put an ActiveX script object in it and paste the
following code into it:
--Begin Copy--
'***************************************
*******************************
' Visual Basic ActiveX Script
'***************************************
*********************************
Option Explicit
Function Main()
Dim oFileSystem
Set oFileSystem = CreateObject("Scripting.FileSystemObject")
Set oFileSystem = Nothing
Main = DTSTaskExecResult_Success
End Function
--End Copy--
Now try to run this package as you did the first. Did it run? If so, your
76th line of code is not the problem and it is a problem somewhere else in
the code. If it fails, try to get it to run using various computers (your
desktop, server, etc.) and user ids (Administrator, your id, Agent id, etc).
Let me know how it goes. You can also open up the registry and search for
the phrase "Scripting.FileSystemObject" on the server to see if it is there.
I'd still suggest turning logging on your package on. This gives much more
detailed errors than the abbreviated errors given by the Job History viewer.
I use it on most packages that I schedule as jobs. That way I can get
detailed errors and exactly where in the package a failure occurred. Great
development tool. You can always turn it back off and can always delete the
logs if you wish.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9BBEF554-FC57-4AA0-89A8-1A3CB520BF36@.microsoft.com...[vbcol=seagreen]
> There's only one step in the package. I know what and where the error is I
> just don't know how to fix it.
> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
>|||That was a good suggestion. You were right about the error message being
misleading. The script you sent ran fine.
I have logging turned on for all of our packages but the message is
essentially the same. Here it is:
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Permission denied: 'CreateObject'
Error on Line 76
Step Error code: 800403FE
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4500
I'll get the programmer to build the code one piece at a time so we can find
out where the error is really happening.
Thanks for your help.
--
Dan D.
"Wm. Scott Miller" wrote:
> OK. Create a new package. Put an ActiveX script object in it and paste t
he
> following code into it:
> --Begin Copy--
> '***************************************
*******************************
> ' Visual Basic ActiveX Script
> '***************************************
*********************************
> Option Explicit
> Function Main()
> Dim oFileSystem
> Set oFileSystem = CreateObject("Scripting.FileSystemObject")
> Set oFileSystem = Nothing
> Main = DTSTaskExecResult_Success
> End Function
> --End Copy--
> Now try to run this package as you did the first. Did it run? If so, you
r
> 76th line of code is not the problem and it is a problem somewhere else in
> the code. If it fails, try to get it to run using various computers (your
> desktop, server, etc.) and user ids (Administrator, your id, Agent id, etc
).
> Let me know how it goes. You can also open up the registry and search for
> the phrase "Scripting.FileSystemObject" on the server to see if it is ther
e.
> I'd still suggest turning logging on your package on. This gives much mor
e
> detailed errors than the abbreviated errors given by the Job History viewe
r.
> I use it on most packages that I schedule as jobs. That way I can get
> detailed errors and exactly where in the package a failure occurred. Grea
t
> development tool. You can always turn it back off and can always delete t
he
> logs if you wish.
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9BBEF554-FC57-4AA0-89A8-1A3CB520BF36@.microsoft.com...
>
>|||I know this sounds crazy, but humor me. Cut your ActiveX script in its
entirety to notepad. Save your package without anything in it (may have to
just paste my code in there so it will save). Now select it all in notepad
and copy and paste it back. Does it run? If so, somehow in writing, you
got a special character embeded in the ActiveX script task. If not, it is
an actual coding error. I've had this happen twice to me so far in 5 years.
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:9C7F17A5-3A3E-4465-9A4E-B66B8D215B2D@.microsoft.com...[vbcol=seagreen]
> That was a good suggestion. You were right about the error message being
> misleading. The script you sent ran fine.
> I have logging turned on for all of our packages but the message is
> essentially the same. Here it is:
> Step Error Source: Microsoft Data Transformation Services (DTS) Package
> Step Error Description:Error Code: 0
> Error Source= Microsoft VBScript runtime error
> Error Description: Permission denied: 'CreateObject'
> Error on Line 76
> Step Error code: 800403FE
> Step Error Help File:sqldts80.hlp
> Step Error Help Context ID:4500
> I'll get the programmer to build the code one piece at a time so we can
> find
> out where the error is really happening.
> Thanks for your help.
> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
>|||Good try but no cigar.
Same error.--
Dan D.
"Wm. Scott Miller" wrote:
> I know this sounds crazy, but humor me. Cut your ActiveX script in its
> entirety to notepad. Save your package without anything in it (may have t
o
> just paste my code in there so it will save). Now select it all in notepa
d
> and copy and paste it back. Does it run? If so, somehow in writing, you
> got a special character embeded in the ActiveX script task. If not, it is
> an actual coding error. I've had this happen twice to me so far in 5 year
s.
> Scott
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:9C7F17A5-3A3E-4465-9A4E-B66B8D215B2D@.microsoft.com...
>
>|||Too bad. One should always try the easy fix first.... :-) Only other
suggestion is the cut and paste line by line or block by block and see which
paste causes the problem then go from there. That will at least give you a
clue where to look.
Good luck on fixing the task,
Scott
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:328C5286-92B5-4290-9C3E-FE9FD45974D6@.microsoft.com...[vbcol=seagreen]
> Good try but no cigar.
Same error.> --
> Dan D.
>
> "Wm. Scott Miller" wrote:
>
Sunday, March 11, 2012
DTS Package Errors
I have created several DTS packages that run if I execute them imidiatly, but error out if scheduled with the following error...
Executed as user: Domain\Username. DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.Most likely it's that it doesn't have access to the drive...
You need to set DTS up so that when you manually run, it will find the same location on the server.
When you run, it runs under the context of your client, when scheduled it runs under the context of the agent id.
Make sure there is the same directory stucture on the server as you have (or vica versa) and make sure to copy the file there...|||Both are being run from the same server.|||What user is the owner of the job. That user may not have rights to execute the DTS package. Also check who the owner of the DTS package is?|||Already verified those and they are good.
The error states which user it is using and it is the same user name that SQL agent is started with. and it has all needed privalges that I can see.|||How did you create the job? Did you right click the job and select schedule?|||Yes|||Is the server SQL 7??|||No, it is SQL server 2000 Enterprise.|||Connections in the package are good? Anything dynamic going on?? Did you get the error message from the job logs??|||I get the same error on all my scheduled DTS jobs, including a test job I created that drops a test table. I find the error in the history of the job after it has run.|||Sorry running out of ideas. Is the owner of the job SA?? not the sql agent|||nope.|||Can you log onto the machine that actually runs the package and execute the package from there? Turned out to be the trick for me -- if I executed from nearly anywhere else there was a DSN set up to map the DNS name to a connection. Just not on the box itself, so EM could execute the package anywhere but on the actual box. I know sounds odd, but it's true...
Executed as user: Domain\Username. DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.Most likely it's that it doesn't have access to the drive...
You need to set DTS up so that when you manually run, it will find the same location on the server.
When you run, it runs under the context of your client, when scheduled it runs under the context of the agent id.
Make sure there is the same directory stucture on the server as you have (or vica versa) and make sure to copy the file there...|||Both are being run from the same server.|||What user is the owner of the job. That user may not have rights to execute the DTS package. Also check who the owner of the DTS package is?|||Already verified those and they are good.
The error states which user it is using and it is the same user name that SQL agent is started with. and it has all needed privalges that I can see.|||How did you create the job? Did you right click the job and select schedule?|||Yes|||Is the server SQL 7??|||No, it is SQL server 2000 Enterprise.|||Connections in the package are good? Anything dynamic going on?? Did you get the error message from the job logs??|||I get the same error on all my scheduled DTS jobs, including a test job I created that drops a test table. I find the error in the history of the job after it has run.|||Sorry running out of ideas. Is the owner of the job SA?? not the sql agent|||nope.|||Can you log onto the machine that actually runs the package and execute the package from there? Turned out to be the trick for me -- if I executed from nearly anywhere else there was a DSN set up to map the DNS name to a connection. Just not on the box itself, so EM could execute the package anywhere but on the actual box. I know sounds odd, but it's true...
DTS Package Error: Login failed for user sa
I am trying to edit a DTS package which is a transfer of data between two tables (connections)
i can view the properties of either connection but i get this error when i try to edit the transformation section of a pakcage that is supposed to transfer data from one table to another.
Login failed for user 'sa'
i am running enterprise manager on the server itself so i shouldn't have any connection issues.
if i try to change the authentication on either connection from "use SQL authentication" to "use windows NT authentication" i get this error:
' Cannot generate SSPI context 'Note: There are too many unknowns here to intelligently troubleshoot the situation:
S1 [I am trying to edit a DTS package which is a transfer of data between two tables (connections)]
Q1 Are both tables on the same server or on different servers?
S2 [i can view the properties of either connection but i get this error when i try to edit the transformation section of a pakcage that is supposed to transfer data from one table to another.
Login failed for user 'sa' i am running enterprise manager on the server itself so i shouldn't have any connection issues.]
Q2 i Have you tried entering the login password for sa
ii What is the result then?
iii Can you sucessfully login using say, Query Analyzer as sa?
S3 if i try to change the authentication on either connection from "use SQL authentication" to "use windows NT authentication" i get this error:' Cannot generate SSPI context '
Q3 Are your Sql Server(s) set to use integrated, standard, mixed, etc. authentication?
i can view the properties of either connection but i get this error when i try to edit the transformation section of a pakcage that is supposed to transfer data from one table to another.
Login failed for user 'sa'
i am running enterprise manager on the server itself so i shouldn't have any connection issues.
if i try to change the authentication on either connection from "use SQL authentication" to "use windows NT authentication" i get this error:
' Cannot generate SSPI context 'Note: There are too many unknowns here to intelligently troubleshoot the situation:
S1 [I am trying to edit a DTS package which is a transfer of data between two tables (connections)]
Q1 Are both tables on the same server or on different servers?
S2 [i can view the properties of either connection but i get this error when i try to edit the transformation section of a pakcage that is supposed to transfer data from one table to another.
Login failed for user 'sa' i am running enterprise manager on the server itself so i shouldn't have any connection issues.]
Q2 i Have you tried entering the login password for sa
ii What is the result then?
iii Can you sucessfully login using say, Query Analyzer as sa?
S3 if i try to change the authentication on either connection from "use SQL authentication" to "use windows NT authentication" i get this error:' Cannot generate SSPI context '
Q3 Are your Sql Server(s) set to use integrated, standard, mixed, etc. authentication?
Friday, March 9, 2012
DTS package behaviour when used by > 1 User?
Hi all
I have a DTS package that users of the database can run which basically acts like a 'live update' (as the database is based on a values produced from another system) and it takes roughly 30 or so seconds to run...
The dts package is not going to have a particularly large hit rate but i am interested in knowing what will happen if a user (user 1) attempts to run the package when it is in already in use by another user (user 2) ?
Will User 1 simply have to wait untill the package completes for User 1?
OR
Will a new seperate 'instance' of the package be used by User 1?
Any info would be very helpful
CheersYou will have problems
the second DTS will start before the first stop
(maybe it's not problem it depends what they do)|||That was the answer i was hoping for really.
Basically this shouldn't be a problem for my scenario. The Users of the System are accountants scattered at various locations around the country and each of them Updates the their own locations data (via the dts package)and so this will not conflict with any other user updating the DB as it is a different locations data.
I was worried that if the user had to wait for the dts package to finish then i may occasionally have timeout issues (not that i haven't got a backup for this).
Thanks for your help, mucho appreciated.
I have a DTS package that users of the database can run which basically acts like a 'live update' (as the database is based on a values produced from another system) and it takes roughly 30 or so seconds to run...
The dts package is not going to have a particularly large hit rate but i am interested in knowing what will happen if a user (user 1) attempts to run the package when it is in already in use by another user (user 2) ?
Will User 1 simply have to wait untill the package completes for User 1?
OR
Will a new seperate 'instance' of the package be used by User 1?
Any info would be very helpful
CheersYou will have problems
the second DTS will start before the first stop
(maybe it's not problem it depends what they do)|||That was the answer i was hoping for really.
Basically this shouldn't be a problem for my scenario. The Users of the System are accountants scattered at various locations around the country and each of them Updates the their own locations data (via the dts package)and so this will not conflict with any other user updating the DB as it is a different locations data.
I was worried that if the user had to wait for the dts package to finish then i may occasionally have timeout issues (not that i haven't got a backup for this).
Thanks for your help, mucho appreciated.
DTS Package and ASP.NET
Hi all,
I need to export tables out of a Pervasive DB and into SQL Server 2K. I
have set up a DTS Package to do this when a user visits a web page
(which will then allow them to view a up to date report using MS
Reporting Services).
Currently my DTS package checks to see if the table exists in SQL
Server and then drops it, creates it, and then does the import of data
from Pervasive.
I am wondering if there is a way to get only the new records? There are
currently no PK defined (Pervasive does not make use of them). However,
I noticed that the DTS package can assign PK.
Does anyone have any advice/code snippets?
I greatly appreciate your help.
Thanks,
TonyHi
What do you do if the existing record has been updated? Even if there is no
primary key there should (hopefully!) be a unique way (set of columns) to
identify them, this should be the PK in the SQL Server database.
One method is to load into a staging table then work from there. If you
drive the transformation using a SQL command in the form
SELECT S.Col1, S.Col2, ...
FROM StageTable S
WHERE NOT EXISTS ( SELECT 1 FROM DestinationTable D WHERE D.PK = S.PK )
You will not insert the existing rows. You can also use an additional SQL
Command step before the insert to update existing rows.
UPDATE D
SET Col1 = S.Col1,
Col2 = S.Col2
FROM DestinationTable D
JOIN StageTable S ON D.PK = S.PK
WHERE D.Col1 <> S.Col1
OR D.Col2 <> S.Col2
John
"Tony" <tcarcieri@.rihousing.com> wrote in message
news:1109857630.729309.129570@.l41g2000cwc.googlegr oups.com...
> Hi all,
> I need to export tables out of a Pervasive DB and into SQL Server 2K. I
> have set up a DTS Package to do this when a user visits a web page
> (which will then allow them to view a up to date report using MS
> Reporting Services).
> Currently my DTS package checks to see if the table exists in SQL
> Server and then drops it, creates it, and then does the import of data
> from Pervasive.
> I am wondering if there is a way to get only the new records? There are
> currently no PK defined (Pervasive does not make use of them). However,
> I noticed that the DTS package can assign PK.
> Does anyone have any advice/code snippets?
> I greatly appreciate your help.
> Thanks,
> Tony|||Hello John,
Thanks for the reply.
Is this scenario possible (psuedo code)?
If table exists
1)run update on exisiting data
2)select from pervasive db where not exists
Else
1)create table
2)run select
Your thoughts?
Thanks so much!
Tony
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Hi Tony
I am not sure why you check the table existance, if you are in control
of the site then it should be know to exist or be part of an
installation. As previously stated, you can drive the data population
from a SQL statement, but doing this over your network may mean that
loading into a staging table may be quicker.
A different way to do this would be though a stored procedure and a
linked server.
John
Tony Carcieri wrote:
> Hello John,
> Thanks for the reply.
> Is this scenario possible (psuedo code)?
> If table exists
> 1)run update on exisiting data
> 2)select from pervasive db where not exists
> Else
> 1)create table
> 2)run select
> Your thoughts?
> Thanks so much!
> Tony
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
DTS Package
Hi,
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
NirajHow do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegroups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>|||I launch the dts package by sql server agent|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegroups.com...
>I launch the dts package by sql server agent
>
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
NirajHow do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegroups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>|||I launch the dts package by sql server agent|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegroups.com...
>I launch the dts package by sql server agent
>
DTS Package
Hello,Can i execute a DTS Package through a web form?I want when the user clicks on a link the DTS Package to be executed.Thank you in advance!
You can take a look atMicrosoft.SqlServer.Dts.Runtime Namespace
Google also gave me some examples:
http://www.sqldts.com/default.aspx?207
http://jaysonknight.com/blog/archive/2004/05/29/274.aspx
http://forums.aspfree.com/microsoft-sql-server-14/execute-dts-from-asp-net-19147.html
|||that helps!
Thank you :)
Wednesday, March 7, 2012
DTS Package
Hi,
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
Niraj
How do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegr oups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>
|||I launch the dts package by sql server agent
|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegr oups.com...
>I launch the dts package by sql server agent
>
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
Niraj
How do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegr oups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>
|||I launch the dts package by sql server agent
|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegr oups.com...
>I launch the dts package by sql server agent
>
DTS Package
Hi,
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
NirajHow do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegroups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>|||I launch the dts package by sql server agent|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegroups.com...
>I launch the dts package by sql server agent
>
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
NirajHow do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegroups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>|||I launch the dts package by sql server agent|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegroups.com...
>I launch the dts package by sql server agent
>
dts or xp_cmdshell permissions
How do i give a user permissions to execute XP_CMDSHELL or a DTS package?
Without compromising the systems security.
Basically what im trying to do is use an asp page on another domain to
access mssql and create a database. Everything works fine except that i
cannot create a folder on the server.
I need to first create a folder by passing the domain name to xp_cmdshell on
the local drive. Then creating the database.
The account accessing the mssql server is dbm.something.com which is in the
master database. This sends arguments to a stores procedure that creates the
database. I added a line to the stored procedure to run xp_cmdshell and
create a database. Once it gets to this line it gives me an error
xpsql.c:Error 1314 from CreateProcessAsUser on line: 432.
Please help me
Thank you
The error 1314 you are getting is:
A required privilege is not held by the client.
Could be that your SQL service account doesn't have the
correct rights to allow it to change security context to the
proxy account. The SQL service account needs Act as part of
OS, Increase Quotas, replace process level token and Login
as batch job.
-Sue
On Wed, 21 Sep 2005 16:15:04 -0400, "robert" <rob@.ms.com>
wrote:
>How do i give a user permissions to execute XP_CMDSHELL or a DTS package?
>Without compromising the systems security.
>Basically what im trying to do is use an asp page on another domain to
>access mssql and create a database. Everything works fine except that i
>cannot create a folder on the server.
>I need to first create a folder by passing the domain name to xp_cmdshell on
>the local drive. Then creating the database.
>The account accessing the mssql server is dbm.something.com which is in the
>master database. This sends arguments to a stores procedure that creates the
>database. I added a line to the stored procedure to run xp_cmdshell and
>create a database. Once it gets to this line it gives me an error
>xpsql.c:Error 1314 from CreateProcessAsUser on line: 432.
>Please help me
>Thank you
>
|||Yeah i read that somewhere, but i dont know how to give it the permissions.
Where do i do that ? act as part of OS and logon as batch are windows
permissions. I dont have a proxy account for SQL under the local users or
domain users. What am i missing here?
Thank for helping
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:feijj1dvrbpvrjepce3jrvqbkj2pdi6l6e@.4ax.com...
> The error 1314 you are getting is:
> A required privilege is not held by the client.
> Could be that your SQL service account doesn't have the
> correct rights to allow it to change security context to the
> proxy account. The SQL service account needs Act as part of
> OS, Increase Quotas, replace process level token and Login
> as batch job.
> -Sue
> On Wed, 21 Sep 2005 16:15:04 -0400, "robert" <rob@.ms.com>
> wrote:
>
|||First, your missing the rights for the service account. The
permissions are outlined in the following article but if you
set the service accounts through Enterprise Manager, the
rights and permissions are handled for you:
HOW TO: Change the SQL Server or SQL Server Agent Service
Account Without Using SQL Enterprise Manager in SQL Server
2000
http://support.microsoft.com/?id=283811
You can use the Local Security Policy snap in to view the
permissions. From the run command from the start button,
type in secpol.msc
If accounts other than sysadmin accounts or the service
accounts are going to be used to execute xp_cmdshell, you
need to setup a proxy account. You can use
xp_sqlagent_proxy_account
You can find more information in books online under
xp_sqlagent_proxy_account and xp_cmdshell.
-Sue
On Wed, 28 Sep 2005 12:18:24 -0400, <rvegas@.rogers.com>
wrote:
>Yeah i read that somewhere, but i dont know how to give it the permissions.
>Where do i do that ? act as part of OS and logon as batch are windows
>permissions. I dont have a proxy account for SQL under the local users or
>domain users. What am i missing here?
>Thank for helping
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:feijj1dvrbpvrjepce3jrvqbkj2pdi6l6e@.4ax.com.. .
>
|||Thanx for your help Sue, still a bit confused will have to read up on this.
Under enterprise manager >>management>sqlserver agent>job system tab.
I have "only sysadmins can run active scripting jobs" checked. I dont want
to change this. Is there another way?
Sorry for all the stupid questions. just dont want to mess anything up.
Thanx
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:55jlj1p4m2s30gcolq6i9ok7gqcs16vjjj@.4ax.com...
> First, your missing the rights for the service account. The
> permissions are outlined in the following article but if you
> set the service accounts through Enterprise Manager, the
> rights and permissions are handled for you:
> HOW TO: Change the SQL Server or SQL Server Agent Service
> Account Without Using SQL Enterprise Manager in SQL Server
> 2000
> http://support.microsoft.com/?id=283811
> You can use the Local Security Policy snap in to view the
> permissions. From the run command from the start button,
> type in secpol.msc
> If accounts other than sysadmin accounts or the service
> accounts are going to be used to execute xp_cmdshell, you
> need to setup a proxy account. You can use
> xp_sqlagent_proxy_account
> You can find more information in books online under
> xp_sqlagent_proxy_account and xp_cmdshell.
> -Sue
> On Wed, 28 Sep 2005 12:18:24 -0400, <rvegas@.rogers.com>
> wrote:
>
|||No problem. You could have the users execute the package
using the DTS object model. There are a few different
options with that and you could use another application such
as ASP. The following have some examples:
Execute a package with OLE Automation -
http://www.databasejournal.com/featu...le.php/1459181
Execute a package from ASP -
http://www.sqldts.com/default.aspx?207
Execute a package from VB -
http://www.sqldts.com/default.aspx?208
-Sue
On Fri, 7 Oct 2005 16:56:33 -0400, <rvegas@.rogers.com>
wrote:
>Thanx for your help Sue, still a bit confused will have to read up on this.
>Under enterprise manager >>management>sqlserver agent>job system tab.
>I have "only sysadmins can run active scripting jobs" checked. I dont want
>to change this. Is there another way?
>Sorry for all the stupid questions. just dont want to mess anything up.
>Thanx
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:55jlj1p4m2s30gcolq6i9ok7gqcs16vjjj@.4ax.com.. .
>
Without compromising the systems security.
Basically what im trying to do is use an asp page on another domain to
access mssql and create a database. Everything works fine except that i
cannot create a folder on the server.
I need to first create a folder by passing the domain name to xp_cmdshell on
the local drive. Then creating the database.
The account accessing the mssql server is dbm.something.com which is in the
master database. This sends arguments to a stores procedure that creates the
database. I added a line to the stored procedure to run xp_cmdshell and
create a database. Once it gets to this line it gives me an error
xpsql.c:Error 1314 from CreateProcessAsUser on line: 432.
Please help me
Thank you
The error 1314 you are getting is:
A required privilege is not held by the client.
Could be that your SQL service account doesn't have the
correct rights to allow it to change security context to the
proxy account. The SQL service account needs Act as part of
OS, Increase Quotas, replace process level token and Login
as batch job.
-Sue
On Wed, 21 Sep 2005 16:15:04 -0400, "robert" <rob@.ms.com>
wrote:
>How do i give a user permissions to execute XP_CMDSHELL or a DTS package?
>Without compromising the systems security.
>Basically what im trying to do is use an asp page on another domain to
>access mssql and create a database. Everything works fine except that i
>cannot create a folder on the server.
>I need to first create a folder by passing the domain name to xp_cmdshell on
>the local drive. Then creating the database.
>The account accessing the mssql server is dbm.something.com which is in the
>master database. This sends arguments to a stores procedure that creates the
>database. I added a line to the stored procedure to run xp_cmdshell and
>create a database. Once it gets to this line it gives me an error
>xpsql.c:Error 1314 from CreateProcessAsUser on line: 432.
>Please help me
>Thank you
>
|||Yeah i read that somewhere, but i dont know how to give it the permissions.
Where do i do that ? act as part of OS and logon as batch are windows
permissions. I dont have a proxy account for SQL under the local users or
domain users. What am i missing here?
Thank for helping
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:feijj1dvrbpvrjepce3jrvqbkj2pdi6l6e@.4ax.com...
> The error 1314 you are getting is:
> A required privilege is not held by the client.
> Could be that your SQL service account doesn't have the
> correct rights to allow it to change security context to the
> proxy account. The SQL service account needs Act as part of
> OS, Increase Quotas, replace process level token and Login
> as batch job.
> -Sue
> On Wed, 21 Sep 2005 16:15:04 -0400, "robert" <rob@.ms.com>
> wrote:
>
|||First, your missing the rights for the service account. The
permissions are outlined in the following article but if you
set the service accounts through Enterprise Manager, the
rights and permissions are handled for you:
HOW TO: Change the SQL Server or SQL Server Agent Service
Account Without Using SQL Enterprise Manager in SQL Server
2000
http://support.microsoft.com/?id=283811
You can use the Local Security Policy snap in to view the
permissions. From the run command from the start button,
type in secpol.msc
If accounts other than sysadmin accounts or the service
accounts are going to be used to execute xp_cmdshell, you
need to setup a proxy account. You can use
xp_sqlagent_proxy_account
You can find more information in books online under
xp_sqlagent_proxy_account and xp_cmdshell.
-Sue
On Wed, 28 Sep 2005 12:18:24 -0400, <rvegas@.rogers.com>
wrote:
>Yeah i read that somewhere, but i dont know how to give it the permissions.
>Where do i do that ? act as part of OS and logon as batch are windows
>permissions. I dont have a proxy account for SQL under the local users or
>domain users. What am i missing here?
>Thank for helping
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:feijj1dvrbpvrjepce3jrvqbkj2pdi6l6e@.4ax.com.. .
>
|||Thanx for your help Sue, still a bit confused will have to read up on this.
Under enterprise manager >>management>sqlserver agent>job system tab.
I have "only sysadmins can run active scripting jobs" checked. I dont want
to change this. Is there another way?
Sorry for all the stupid questions. just dont want to mess anything up.
Thanx
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:55jlj1p4m2s30gcolq6i9ok7gqcs16vjjj@.4ax.com...
> First, your missing the rights for the service account. The
> permissions are outlined in the following article but if you
> set the service accounts through Enterprise Manager, the
> rights and permissions are handled for you:
> HOW TO: Change the SQL Server or SQL Server Agent Service
> Account Without Using SQL Enterprise Manager in SQL Server
> 2000
> http://support.microsoft.com/?id=283811
> You can use the Local Security Policy snap in to view the
> permissions. From the run command from the start button,
> type in secpol.msc
> If accounts other than sysadmin accounts or the service
> accounts are going to be used to execute xp_cmdshell, you
> need to setup a proxy account. You can use
> xp_sqlagent_proxy_account
> You can find more information in books online under
> xp_sqlagent_proxy_account and xp_cmdshell.
> -Sue
> On Wed, 28 Sep 2005 12:18:24 -0400, <rvegas@.rogers.com>
> wrote:
>
|||No problem. You could have the users execute the package
using the DTS object model. There are a few different
options with that and you could use another application such
as ASP. The following have some examples:
Execute a package with OLE Automation -
http://www.databasejournal.com/featu...le.php/1459181
Execute a package from ASP -
http://www.sqldts.com/default.aspx?207
Execute a package from VB -
http://www.sqldts.com/default.aspx?208
-Sue
On Fri, 7 Oct 2005 16:56:33 -0400, <rvegas@.rogers.com>
wrote:
>Thanx for your help Sue, still a bit confused will have to read up on this.
>Under enterprise manager >>management>sqlserver agent>job system tab.
>I have "only sysadmins can run active scripting jobs" checked. I dont want
>to change this. Is there another way?
>Sorry for all the stupid questions. just dont want to mess anything up.
>Thanx
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:55jlj1p4m2s30gcolq6i9ok7gqcs16vjjj@.4ax.com.. .
>
Subscribe to:
Posts (Atom)