Viewing 15 posts - 256 through 270 (of 313 total)
I am confused. Are you running 2005 or 2000. Are you using DTS or SSIS? Is the SQL Server 64 Bit or Oracle?
--I have the option of...
April 13, 2006 at 7:42 am
So I went on with what you were saying about security and installed on another machine. Go pretty much the same error.
Found a site that said permissions...
April 12, 2006 at 5:51 pm
That would be huge. thanks if you live in MO I will buy you lunch
April 12, 2006 at 4:44 pm
Under Agent properties it is running as (This Account) User ppp\Administrator PWD XXXXXX
PPP\Administrator is a group. I belong in that group. It has the same set up as...
April 12, 2006 at 4:27 pm
Also if it was a permission issue is it throwing me a bogus error?
Executed as user: PPP\Administrator. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart:...
April 12, 2006 at 4:09 pm
I actually was not cross posting. I currently have two servers. I one is running 2k5 and one 2000. So I thought if I could figure out a...
April 12, 2006 at 4:07 pm
I am confused then. why am I passing the admin password in the script
exec
master.dbo.xp_cmdshell 'DTSRUN /S SQLPDC /U DW_MASTER /P Password /N...
April 10, 2006 at 12:16 pm
Ya know I guess I was making a mountain out of a mole hill. Yes that will work. I appreciate you helping me with that
March 20, 2006 at 8:03 am
Got it to work. Code is below. Make sure on the script task, the readWrite Variable is put in there
If CInt(ds.Tables(
March 3, 2006 at 2:25 pm
This is as far as I got. It runs but it never stops. I created a variable called iEmail so if there are records i know whether or not to...
March 3, 2006 at 2:02 pm
I am having the same issue using a script task. I can not figure out how to select the variables I have created and put a value in them
March 3, 2006 at 1:08 pm
Sorry about the delay. I had the flu and was sleeping a lot. The server job is running as builtin/administrator.
The folder is shared just in case.
There are backup files from...
March 1, 2006 at 8:50 am
I was playing with this since I could use it also and I get
'srvinfo' is not recognized as an internal or external command,
I installed the win2k resoure tools in the...
February 24, 2006 at 10:27 am
Viewing 15 posts - 256 through 270 (of 313 total)