declare @command varchar(8000)

set @command = 'rename c:\sgrs\SGRS_SGCTCentral_7_20111111102846.rar verificadoSGRS_SGCTCentral_7_20111111102846.rar'

...

To be honest with you I would use PowerShell for this task.

This URL will get you started

http://newsqlblog.com/2011/08/05/dynamic-excel-posh/

Assuming the original poster meant to load the stuff into a SQL server table rather than into another excel file?

You can ZIP your files and attach...

Hi,

Would you mind sharing your package so that one could have a look who is interested in the above topic?

http://pragmaticworks.com/help/dtsxchange/index.htm#page=FAQ%20-%20What%20are%20the%20advantages_disadvantages%20of%20storing%20SSIS%20packages%20to%20MSDB%20vs%20File%20System.htm

No, I did not.. :unsure:

Dave Ballantyne (10/3/2011)

---

First off , look at the execution plan to see what has happened rather than guessing.

If you are not upto speed , then i would recommend Grants free...

Dave Ballantyne (10/3/2011)

---

They are an *indicator* as are Reads Writes and Cpu usage in a trace session.

But those durations are quite short , so

A) is the quantity of data...

Thanks.

So when do do you usually look at the time stats if it is "not a way of measuring performance at all" ? Thank you.

What does the below query return?

SELECT wait_type, wait_time, last_wait_type

FROM sys.dm_exec_requests

WHERE session_id = 123

1, max 4GB (10GB for 2K8 R2)

2, you can have multiple instances

Understood. Thank you very much!

edited:

And what about the publication dbs?? thank you.

Thanks for your response.

Yeah, but wouldn't that affect replication?

You never worked as a DBA and looking for a junior position? In the meantime you are a MCTS and MCITP?!

How did you do that?? I have around 2 yrs...