What you are trying to achieve is possible via SSIS configurations. That said the best way I have found to getting it working is to store the config info in...

Hi,

In order to use transactions within SSIS you need to have MSDTC running and running on the same machine that is executing the package.

HI Sharon

it should work if you:

configure the filewatcher to look for the *.ldb file (dir provided by a variable)

set the timeout to be 1 (minute)

timeout warning as false (this will...

Hi

create a variable to hold the drive you want to loop over

open the "foreach loop" container ensure the enumerator is set as "Foreach File Enumerator"

under the "expressions" click the...

try renaming the parameter to a numeric. The first being 0 and subsequent ones increasing by 1 each time. Reference by ? in the SQL shoudl work fine

Hi Sharon,

I don't know if you are having issues with this still or not but if so it may be worth checking out the file watcher task. It is available...

Thanks - you are quote right about the DR, and have confirmed my own thoughts re: splitting the LUN.

As for the warehouse I imagine tempdb will see more action than...