|
Job -> xp_cmdshell 'DTSRun ' - Access Denied !
Hi Friends,
I have a SQLServer Job that try to execute a command
DTSrun using the proc xp_cmdshell, but I receive "Access
Denied" when the DTSrun are executed
my configuration:
SQL Server 7.00 - 7.00.1063 (Intel X86) - SP4
Windows 2000 - Service Pack 4
Someone can help me ?
thx
Johnny ...
Thu, 23 Dec 2004 04:42:46 -0800
|
Populating a global variable.....
How to populate a global variable by reading the data from a database.
Basically I want to find out the max date from a field and poulate the
variable.
SQL2K.
Thanks
Brian
...
Wed, 22 Dec 2004 20:03:58 -0800
|
Win Server 2003 Web Edition Problem
Hi all
I have a Windows Server 2003 Web Edition running. No i have one problem...I
can't install the Enterprise Manager on the Web Edition of Windows Server
2003. How can i still get a DTS running on a SQL 2000 MSDE Version? how can i
copy it or move it over to that machine?
thanks for your help
m.ahre ...
Wed, 22 Dec 2004 11:21:02 -0800
|
SQL DTS Job Status
I have a DTS Job that is scheduled to run daily on our SQL Server 2000
server. Is there an easy way for me to determine if the DTS job ran
successfully?
Does DTS provide anything for this or must I use DMO to look at the jobs
collection?
220 55002
...
Wed, 22 Dec 2004 11:19:07 -0600
|
"Invalid Class String" on Custom .NET DTS Task
Hello all!
I've created a custom DTS task in the .NET Framework 1.1 and have it
installed and partially working on the server it will be residing on. If I
log into the machine using my account and manually open and run the package,
everything works. If I log in and use the limited SQL Server account, the ...
Wed, 22 Dec 2004 10:47:42 -0500
|
How to export a table into .xml and .xsd
Hello All
I want to create a export of a given table as a .xml file with a .xsd
Can somebody please point me in the right direction how I can do it.
Also, once I have created a .xml and .xsd how do I import the table
structure and contents after having dropped the table to recreate it
from the .xsd defin ...
22 Dec 2004 03:35:48 -0800
|
DSN vs Dynamic Properties Task
Problem at hand: Moving / Migrating jobs from development to test to
production.
Current situation: SQL servers are instances in many cases and not
necessarily "local". A "common" SQL database is used to store connection
information that is read using dynamic properties task to modify the SQL
Server / us ...
Tue, 21 Dec 2004 18:17:02 -0800
|
syntax error or access violation in DTS Execute SQL Task
I needed to run a conditional SQL that include a value from a global variable
set prior to the task. For some reason, the conditional (IF) and the global
variable couldn't work together. One or the other by itself is OK. Below
are the SQL I am using:
Case 1 works (with IF):
IF ((SELECT COUNT(*)
FROM v ...
Tue, 21 Dec 2004 16:31:02 -0800
|
dtsrun in sql server 7.0 reports success even though task fails
There is a sql task in a dts package that runs a stored procedure which fails
on a primary key constraint while inserting a duplicate row.
If the package is run from the dts designer, it reports an error and follows
the 'on failure' path.
If the package is run with the dtsrun command from a job. the pac ...
Tue, 21 Dec 2004 09:21:01 -0800
|
DTS question-- overwriting existing records, keeping new ones
I'm fairly sure this question falls in the "DTS 101" category, so forgive me
if it's as basic as they come....I have a source and destination table, each
with the same schema. I'd like to copy the contents of the source into the
destination, overwriting those destination records with matching primary
key ...
Tue, 21 Dec 2004 09:04:14 -0800
|
Scheduling Problem - Duplicate Attachments
I have a nice DTS extract from SQL to Excel setup where I pull the data and
load into a spreadsheet. I then have a SendMailTask which mails the result
set in Excel to a maillist.
My Problem: Somehow, in setting schedules I get duplicates of the Excel
file attached in the e-mail. I've actually even had q ...
Tue, 21 Dec 2004 08:37:07 -0800
|
Excel - named ranges
Hi Kayda,
There isn't a GUI method within SQL Server 2000 DTS to enable this
functionality, however you can build in custom Transact-SQL logic instead.
For example, you can create a DTS package status table that gets logged to
at the beginning and the end of your DTS package execution. Create 'Execute
...
Tue, 21 Dec 2004 10:11:35 -0600
|
Isolating a DTS package
Hello:
Simple question from a relative DTS newbie. When a DTS package is
running, I want to make sure that the only thing that can update the
tables is the package, and that the package cannot be run by anyone
else while that instance of the package is running. What is the best
setting for this?
Thanks,
...
21 Dec 2004 02:55:07 -0800
|
DTS, ActiveX and Global Variables in SQL 2005
This is from a Microsoft FAQ from July:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/dtsfss05df.asp
[CLIP]
Q. Why Aren't Global Variables Available in the ActiveX Script Task?
A. Access to global variables is not supported in Beta 2.
Are Global Variables going to be avail ...
20 Dec 2004 16:31:30 -0800
|
Converting a date string to a date field
I have a txt file that contains the date in a string format. I import this in
directly and it comes up a vchar instead of a date field. I need to convert
it to a date so I can do an index on it. I don't know if it is possible to do
in the DTS or if I should leave it how it is and then use a conversion in the ...
Mon, 20 Dec 2004 11:43:10 -0800
|