There's no issue with the file still being in use while trying to copy it as the filename ends with ****tmp.csv while it's still being written. When the "tmp" section...

Hi Jeff

I've stepped through the code as it is and, in the watch window, the times are the correct format in both cases.

It appears to be only when the package...

At a quick glance, you're trying to load an Excel Binary file (the xlsb) but the SSIS package is expecting an Access file (mdb,accdb, etc).

It sounds like it would affect mirroring as well then.

Looks like we will have to wait for the maintenance window if that's the case.

Thanks Perry

Our next maintenance window is in around 4 weeks so it might have to wait for that.

At worst case scenario, what would happen if we did this without turning...

Thanks Perry

But can we run them when the databases are always being written to (unless we turn off the feeds)?

I did think we'd have issues when they first proposed doing it like this.

Looks like someone (probably me) has a lot of work to do shortly to try and sort...

The server with ID 0 is still listed with the 02 ending.

Quick thought......

If I stop the SQLServer service, do the dropserver followed by addserver and then restart the service would that work?

I get the feeling I'm going to have to stop...

Solved it!

Apparently, if you set the path to the root of the drive, SQL tightens security automatically and removes the permissions. If you set up a folder and use...

Not as far as I am aware.

I do know we're getting ready for an software upgrade of the 3rd-party application in the near future but my understanding is nothing is...

Thanks for that idea.

I'll have a word with our server/SAN team and see if they've got time to sort me out another server.

It'll be interesting to find out if it...

I think we got the image from an MSDN subscription.

Looks like it will probably be coincidence then.

Thanks for the info.

Hi all

Thought I'd resurrect this thread rather than starting a new one.

The powers-that-be have decided to use transactional replication as previously discussed on this thread.

I'm trying to set up the...

Apologies for the formatting......

Here's how they come directly out of the database.

As you can see, they are just numbers and I have to format them manually to get them into...