The demo I say of always on was like clustering on steroids.. Love the idea, hope to try it..

And that article was good knowledge..

CEWII

SQL can be running when diskpart is used.

Run into this a number of times and SQL doesn't even need to be restarted..

Win 2008/Win 2008R2 for sure.

CEWII

I have seen issues with VM tools causing this error. But in your case it sounds more like AD permissions. Try to run the setup.exe as an administrator....

Are you trying to install this on a VM?

If so uninstall the VM helper tools (guest additions) and try again.. Re-install them after..

CEWII

You certainly can back it up directly to a UNC path.. However you need to have a security context to get there and LocalSystem isn't going to give it to...

Actually it isn't real clear.. Sorry..

I'm not sure what you mean by direct link, there are references but I'd like to understand what you mean.

Also you reference...

I generally agree, but what you are trying to do and what technology you are trying to do it from have a big effect here, as well as the availability...

In reality there are quite close.

When a package opens it tries to verify all the items in the package unless Delay Validation is set to True, I believe this includes...

I'm thinking Delay Validation = TRUE would help, otherwise it will try to verify it and fail..

CEWII

jason_selph (3/22/2012)

---

You can pass credentials when attaching to a UNC

--clear any ipc$ connections

net use \\server\share /delete

--map the drive

net use \\server\share /user:domain\username password

--do whatever you want

--cleanup

net use \\server\share /delete

it can also...

rudy komacsar - Doctor "X" (3/22/2012)

---

is not necessarily correct ... unless 'threads' are are construed to mean 'logical CPUs' or...

Before we go down that path why don't you explain why you don't want to do this from your prod box? Are these big extracts? Why don't you...

Yep, it is very possible and really no more difficult than a named instance..

CEWII

You have to add the connection to the package first.. The option is something like add connection from data source. I don't have BIDS open right now but...

You can add a Row Count component to a data-flow.

However, I like code for a certain level of paranoia so I don't trust simple record counts. I will often...