DTS Protection

I'm trying to protect a package... using an owner password.
After I create an owner password and generate a dts command line from
DTSRunUI... it puts the package password in the string.
Basically if someone goes into the job and looks at this line they have the password to open the package...

DTSRun /S "svr-eqanalysis" /N "OrgExtract Rename" /M "password" /G "{2E2B6F07-0E56-4212-A894-B85A4EAA6C8C}" /W "0" /E

We can not remove the builtin administrators group from the machine
therefore system admins that want to poke around into our work can do so...
any suggestions.....

thanks,

jonathanRight click on the package, and select schedule. SQL Server automatically encrypts the whole command line for you. You may have to recover this from the job itself.|||Perfect.... !!!
thank you.....
jonathan|||Mcrowley
How would one stop a person from messing with the sql server agent... under the same circumstances...
stopping from someone changing a particular job...
more then one dba or system admin has a job
you want to secure just your job from others...
possible... ?

DTS package problem

Hi guys, I really have a strange problem that I have no where to look for
answer. I have a DTS that generate a text file with data queries from sql
server 2K then stores it in a local drive. The last step of that DTS is to
copy that file to a network drive using a batch file called by the Process
Task. The commands in the batch file is basically create a network drive,
copies the file over, then delete the source. The file gets copy over when
I manually run the whole package in Enterprise Manager at the DTS designer.
But this DTS package is scheduled to run once a week automatically. It runs
sucessfully during the scheduled time, the file is generated, but it doesn't
copy over to the network drive. I'm not sure why it doesn't do the copying.
In fact, all command in that batch file was executed but the copying part.
I don't think the problem is in the batch file b/c when I run the batch file
alone either by Execute Step or run in command line, the file gets copied
over. So I just don't get it why the file is not copying over when it's
being run at schedule time. Does this has anything to do with security?
Any comments is appreciated. thanks

WeiSound like a proxy acct problem. Please see if this article helps:
http://support.microsoft.com/?id=264155

--
-oj
http://www.rac4sql.net

"WKC" <wchen@.eibilling.com> wrote in message
news:Xm_Kb.64762$Cs3.8068955@.news4.srv.hcvlny.cv.n et...
> Hi guys, I really have a strange problem that I have no where to look for
> answer. I have a DTS that generate a text file with data queries from sql
> server 2K then stores it in a local drive. The last step of that DTS is to
> copy that file to a network drive using a batch file called by the Process
> Task. The commands in the batch file is basically create a network drive,
> copies the file over, then delete the source. The file gets copy over when
> I manually run the whole package in Enterprise Manager at the DTS designer.
> But this DTS package is scheduled to run once a week automatically. It runs
> sucessfully during the scheduled time, the file is generated, but it doesn't
> copy over to the network drive. I'm not sure why it doesn't do the copying.
> In fact, all command in that batch file was executed but the copying part.
> I don't think the problem is in the batch file b/c when I run the batch file
> alone either by Execute Step or run in command line, the file gets copied
> over. So I just don't get it why the file is not copying over when it's
> being run at schedule time. Does this has anything to do with security?
> Any comments is appreciated. thanks
> Wei|||"WKC" <wchen@.eibilling.com> wrote in message
news:Xm_Kb.64762$Cs3.8068955@.news4.srv.hcvlny.cv.n et...
> Hi guys, I really have a strange problem that I have no where to look for
> answer. I have a DTS that generate a text file with data queries from
sql
> server 2K then stores it in a local drive. The last step of that DTS is to
> copy that file to a network drive using a batch file called by the Process
> Task. The commands in the batch file is basically create a network
drive,
> copies the file over, then delete the source. The file gets copy over
when
> I manually run the whole package in Enterprise Manager at the DTS
designer.
> But this DTS package is scheduled to run once a week automatically. It
runs
> sucessfully during the scheduled time, the file is generated, but it
doesn't
> copy over to the network drive. I'm not sure why it doesn't do the
copying.
> In fact, all command in that batch file was executed but the copying part.
> I don't think the problem is in the batch file b/c when I run the batch
file
> alone either by Execute Step or run in command line, the file gets copied
> over. So I just don't get it why the file is not copying over when it's
> being run at schedule time. Does this has anything to do with security?
> Any comments is appreciated. thanks

Sounds very much like a security issue: access rights on the remote
machine drive directory need to be granted appropriately to the
service doing the writing. I'd firstly coodinated/check:

the ownership of the DTS step (and task),
the service SQL Agent login account, and
the remote access restrictions (other machine).

Good luck,

Pete Brown
Falls Creek
Oz

DTS Network Traffic

Hi,
I am trying to confirm a hypothesis on the Network traffic that a certain
DTS will generate, my environment is configured as follows:
Server A: SQL Server Instance to act as source
Server B: SQL Server Instance to execute DTS Package
Server C: File Server at remote location to be target server
If I run a DTS package in Server B to extract information from Server A
and generate a fixed length flat file in Server C. Is it valid to say that,
all the information required to build the flat file will travel on my network
from Server A to Server B first and then it will be dumped in the flat file
on Server C?
Is there any way to still use Server B to execute the DTS package but, have
the network traffic go directly from Server A to Server C?
Thanks a lot!
Ignacio
why dont you just have serverA execcute the DTS job straight to C?
"i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
> Hi,
> I am trying to confirm a hypothesis on the Network traffic that a certain
> DTS will generate, my environment is configured as follows:
> Server A: SQL Server Instance to act as source
> Server B: SQL Server Instance to execute DTS Package
> Server C: File Server at remote location to be target server
> If I run a DTS package in Server B to extract information from Server A
> and generate a fixed length flat file in Server C. Is it valid to say
> that,
> all the information required to build the flat file will travel on my
> network
> from Server A to Server B first and then it will be dumped in the flat
> file
> on Server C?
> Is there any way to still use Server B to execute the DTS package but,
> have
> the network traffic go directly from Server A to Server C?
> Thanks a lot!
> Ignacio
|||They are on different newtorks and have different administrators, Server A's
security is much more strict than Server B which I administer.
"Immy" wrote:

> why dont you just have serverA execcute the DTS job straight to C?
> "i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
> news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
>
>

DTS Network Traffic

Hi,
I am trying to confirm a hypothesis on the Network traffic that a certain
DTS will generate, my environment is configured as follows:
Server A: SQL Server Instance to act as source
Server B: SQL Server Instance to execute DTS Package
Server C: File Server at remote location to be target server
If I run a DTS package in Server B to extract information from Server A
and generate a fixed length flat file in Server C. Is it valid to say that,
all the information required to build the flat file will travel on my networ
k
from Server A to Server B first and then it will be dumped in the flat file
on Server C?
Is there any way to still use Server B to execute the DTS package but, have
the network traffic go directly from Server A to Server C?
Thanks a lot!
Ignaciowhy dont you just have serverA execcute the DTS job straight to C?
"i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
> Hi,
> I am trying to confirm a hypothesis on the Network traffic that a certain
> DTS will generate, my environment is configured as follows:
> Server A: SQL Server Instance to act as source
> Server B: SQL Server Instance to execute DTS Package
> Server C: File Server at remote location to be target server
> If I run a DTS package in Server B to extract information from Server A
> and generate a fixed length flat file in Server C. Is it valid to say
> that,
> all the information required to build the flat file will travel on my
> network
> from Server A to Server B first and then it will be dumped in the flat
> file
> on Server C?
> Is there any way to still use Server B to execute the DTS package but,
> have
> the network traffic go directly from Server A to Server C?
> Thanks a lot!
> Ignacio|||They are on different newtorks and have different administrators, Server A's
security is much more strict than Server B which I administer.
"Immy" wrote:

> why dont you just have serverA execcute the DTS job straight to C?
> "i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
> news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
>
>