Principale utente con più risposte
I am using the partition management tool from codeplex. I posted this blog question there too. We want to use this tool to allow for dynamic partition switching out. It simplifies the tsql we would need to write otherwise. Cna we use the exe for remote databases?
We have an ETL server that runs our SSIS packages. Our DW database is on another server. When I run ManagePartition on the ETL Server in our SSIS package (and from the command prompt) it looks like it expects our database to be on the same server as where the executeable is located. Is this true? We do have a sql instance on the ETL server but the databases there are more for logging (Not our DW database). I get this error on the ETL server.
I even tried using the executeable on the db server from the ETL server and got the same error.
E:\3rdPartyExecuteables>\\server\d$\3rdPartyExecuteables\ManagePartition.exe /C:ClearPartition /d:DW/s:DW /A:FactAux /t:Fact /p:1 /K:+
Object reference not set to an instance of an object.
- Modificato SSAS is Fun mercoledì 3 luglio 2013 16:40