Martin, your solution worked.

Thanks,

Jeff, format date is not the issue.

If you are willing to waste your time, do it on the real problem, the variable is the issue.

DECLARE @todays AS VARCHAR(20) SELECT @todays...

Hi, this is what I am trying to do,

DECLARE @todays AS VARCHAR(20)

SELECT @todays = format(cast(getdate() as date),'yyyyMMdd')

EXEC xp_cmdshell

'copy C:\Test\@todays\ *.* C:\Newtest\';

But, I can figure out the syntax to pass the...

• This reply was modified 2 years, 3 months ago by  josetur12.

Jeff, thank you.

I ran the query you provided and it does delete the intended rows.

I will run it against a test table with a lot more data to select the...

I am sorry, what I mean by "delete or update" is I can use any of the options.  But, to be more specific, I need to update Removed = 2...

I want to share what worked for me.
This command, will copy the ssis package to the E drive.

exec xp_cmdshell 'dtutil /SQL PackageName /decrypt password /COPY FILE;E:\Foldername\PackageName.dtsx'

Thank you, I will take a look at it.

Thank you, it worked!!

Thank you all, I will try pietlinden 's code.

Hi, the data involved in this task is fairly small. So, I think the cursor would not be very costly.
I have this other query,
SELECT DISTINCT
[EmployeeID]

Thank you, I think I just got it...

Okay, thanks.

Thank you!!!

I agree with your suggestions. I will re-consider my approach.

Thanks,

Thank you, this works.