I've had a dts package scheduled for about 2 months that runs every day with no problem. All of the sudden, it errors out today. In the job history, this is what's displayed:
The job failed. Unable to determine if the owner (LLC\dan) of job automated_clientv7_daily_pull has server access (reason: Could not obtain information about Windows NT group/user 'LLC\dan'. [SQLSTATE 42000] (Error 8198)).
Here is the xp_cmdshell statement I am running:
DECLARE @FileName varchar(50),
@Command1 varchar(2000)
SET @FileName = convert(varchar, getdate(), 112)
SET @Command1 = 'copy \\dan\projects\version7\clientname\daily_data_pulls\reports.xls \\Conus\Clients\clientname\daily\reports_' + @filename + '.xls'
EXEC master.dbo.xp_cmdshell @command1
as I said, it worked fine until this afternoon. Any insight would be appreciated.
thanks
-Dan
The job failed. Unable to determine if the owner (LLC\dan) of job automated_clientv7_daily_pull has server access (reason: Could not obtain information about Windows NT group/user 'LLC\dan'. [SQLSTATE 42000] (Error 8198)).
Here is the xp_cmdshell statement I am running:
DECLARE @FileName varchar(50),
@Command1 varchar(2000)
SET @FileName = convert(varchar, getdate(), 112)
SET @Command1 = 'copy \\dan\projects\version7\clientname\daily_data_pulls\reports.xls \\Conus\Clients\clientname\daily\reports_' + @filename + '.xls'
EXEC master.dbo.xp_cmdshell @command1
as I said, it worked fine until this afternoon. Any insight would be appreciated.
thanks
-Dan