I have something similar, but I need to restore from ServerA to ServerB. Using Restore filelistonly... I've tried: \\serverA\shared drive\folder structure\file --while on ServerB

restore ...move 'logical' to ...

folder structure\file...

When I do that I receive the error::crying:

"Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 72

An INSERT EXEC statement cannot be nested."

There are 'INSERT' statements in various other procedures...

I am using the same source and destination files in both the Bulk Load and Data Flow. Is there a reason the data flow would stop after 20K rows?

I tried that and got this message when I executed the task:

The element cannot be found in a collection. This error happens when you try to retrieve an element from...

Okay, I got the folder create to work, I didn't know things were case sensitive. However, now I can't pass the variable to an FTP task. What the...

I'm using Visual Source Safe. It's not bad if you can set up the project structure correctly; I'm still trying to find the optimal structure. Do you put...

Sorry, that won't work. I'm trying to put everything together in the package so I can load it into version control and everything stays together an in sync.

Tim

The encryption is one of the solution properties.

Thanks for the advice. I've never used them since any kind of a failure has always been an issue that had to be addressed. I've just started working...

Are you trying to connect to a UNIX FTP server? If so, I've heard that there's a problem when you try to "put" files. "Get" works fine, but...

:w00t: Outstanding...Thank you :blush:

Tim

This was on the database when I tried to do the detach itself.

I was using SSMS to detach the database. I don't remember the exact error, but it wqas something along the line that the database could not be detached because...

Thanks, but due to the critical business need, no downtime is allowed. Log Shipping and Replication are not a feasible option due to the number of databases and the...

It now works for some reason. I had restart the SQL service on that server for another reason and when I ran my test it worked just fine. ...