Getting this error

'gt' is not recognized as an internal or external command.

I can copy a file successfully.

exec xp_cmdshell 'COPY ............test.txt...test3.txt

It does work at the commend prompt directly on the server.

dtexec /sq Test /ser MyServer

Thanks for your help on this!

Works fine. xp_cmdshell can read the contents of that directory.

Seems to be something specific to calling dtexec...

>> If you add read/write permission to the folder to the SQL Server Service account it should work

That is what I tried first which didn't work leading me down the...

>>dont the files that DTEXEC runs need to have the Dtsx extension and I think you also have to put the fiel name in double quotes, though I may be...

This returns two records, one is NULL and the other is the SQL Server server account.

This would be a good start.

http://www.sqlservercentral.com/articles/Administration/64582/

>>Is there any need (I can't think of any from my end) to keep the Access and SQL Databases on separate servers?

Best practice is not to put anything on a...

A second restore over the same database seems to have taken 20 minutes vs 3 hours for the first restore.

Would file initialization create this discrepancy? Meaning that once the space...

I found the problem. It looks like user tables were being created in the master database accounting for the large size of master.

The Foreach Loop method is the standard, out of the box way to retrieve and act on an indeterminate number of files in a folder. It will retrieve each filename...

Can you store your list in a table and have the package reference the table?

Other wise you will need to parse out the individual data items from you list, certainly...

Thank you both. ROW_NUMBER ( ) OVER is what I needed.

Revised DDL/DML.

The data structure seems reasonable but I don't have an additional table that Tom suggested I may need.

My initial attempt to write a select statement to solve a group...

Thank for for your response. I was using Stars as sample data, my actual data is much more mundane.

I expect my groups to contain at most 100 hundred members...