True about the other ways to get this kind of data, and I use both of those fairly frequently as well. This is for those times when I have several...

That got it. Thank you for all the help.

If someone comes across this post later, and wants to see a walk through, I'll upload the screen capture of what I...

Glad I posted this, because my brilliant idea caused the system to crash.

I tried the Tasks > Copy Database option. I made it most of the way through, but that...

Ok, I have a solution for my first question. I am sure there must be a better way to do this, but this is what I've got so far:

Exec dbo.upObjectQuickDrop

...

Still have to add the line that removes / in the first character....

Lowell (4/26/2012)

---

very simiar to mine;

i put this proc in master, adn whenever i need to refresh myself with date conversions, i just run "sp_dates" in SSMs, to get a quickie...

I found the solution on another forum.

Script Task code:

Public Sub Main()

Dim vFTP_Loc As String

Dim vFile As Object

Dim vFileObject As Object

Dim vFolder As Object

Dim FSO As Object

Dim vFileCount As Integer

Dim vConnection...

I found the solution on another forum.

Script Task code:

Public Sub Main()

Dim vFTP_Loc As String

Dim vFile As Object

Dim vFileObject As Object

Dim vFolder As Object

Dim FSO As Object

Dim vFileCount As Integer

Dim vConnection...

I have done both the full restore (listed in first post with time taken to complete the restore) and now Restore VerifyOnly, and all of those tests show the files...

The links already given above will work a great deal better than what I'm about to show, but...

My wife says I love complicated things, and I'm sure that will show...

If you mean do I know that the files work during a restore, yes they do. What other way would you...

Perfect, that seems to have gotten it so far. Now I'll see if this works in an SSIS package. I'll post an update about how it goes when I test...

Elliott Whitlow (2/24/2012)

---

SQLRNNR (2/24/2012)

---

Jeff Moden (2/24/2012)

---

I finally started doing the same thing and had to stop. They really took serious offense to me hitting the server...

Thank you all for your responses. You've given me a great deal to think about, and a greater focus on my research for this weekend.

I want to make sure that...

Ok, I believe I've figured it out, and I feel a touch foolish for missing such a simple solution:

TestString = Chr(34) & "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec.exe" & Chr(34) &...