Error in Transfer Objects Task

[jcoira]

Hi,

I have a DTS package with one Transfer Objects Task to extract data from a transactional system into a data warehouse. The transactional system is in a different server than the DW one. They are linked servers.

When I run the package I get the following error

Error string: [SQL-DMO]CreateFile error on 'NAMF222130-NAMF222140.UMDB.LOG'. Access is denied.

where NAMF222130-NAMF222140 is the server alias and UMDB is the DB name.

I wonder why it is trying to create a log file in the source database and what I need to do to get rid of the error.

I am running SQL server SP3.

Any ideas?

Thanks,
// jc

 

[nigelrivett]

Sounds like this is a log file it is trying to create rather than a table in a database - have a look at the package logging

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[jcoira]

Thanks !! DTS creates a log file to script the objects it has to move. The proxy account which executes the DTS did not have access to that "log" file. My problem is solved now.