quote:

---

When he uses the wizard it cannot see the test box.

---

What wizard? What test...

It would seem that permissions are OK. "login unknown or wrong password" would indicate that sql is using the wrong credentials. Has someone changed the Adminstrator password since sql was...

...Administrator account of the machine.../code]

I suspect that there is a permission/access problem to do with the local Administrator account. Did you login as Administrator to create the mapped drive? Was...

The problem with above is the 8k limit and if the numbers are > 1 digit. Using '%REC%:%' should cater for this.

The code below will give you the number of...

In the same package create a new step to do the email (remove code from first step) and change the properties of the first step to quit on failure so...

Duplicate post.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17997&FORUM_ID=5&CAT_ID=1&Topic_Title=Remote+Folder+in+Linked+Server&Forum_Title=Administration

Are you sure the mapped drive exists, you will get this error if not.

Test with

xp_cmdshell 'dir F:\descarga\00005\'

Alternatively use UNC

Edited by - davidburrows on 11/07/2003 ...

What account is sql server running under. If it is set to localsystem then you will not be able to access across a network.

quote:

---

select count(*) from master..sysprocesses

where dbid = db_id('dbname')

---

This will give you then number of...

Hi Frank,

quote:

---

I have very basic skills only in DTS, just enough to get my jobs done.

---

November 6, 2003 at 4:24 am