Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nairsanthu1977
Starting Member
2 Posts |
 Posted - 2012-07-16 : 09:46:56
|
| Hello,It's SQL server 2005 64bit standard edition with SP4 (Windows 2003 Enterprise 64 bit)I am trying to import data from cube into OLTP database table.My source MDX query contains "Instr" function for filtering data.I am getting the below error when the query is parsed.The statement could not be parsedPrepare is not safe during execution of the Instr stored procedure. (Microsoft OLE DB Provider for Analysis Service 2005)Can anyone please help !. It's urgent, got stuck with it now.. In fact I want to save it as package and schedule as job.. When I put a single filter it works fine... The moment I add "INSTR" function it throws error.I also tried to pull all the data without any filter.. Even that also doesn't work.. It just hangs.Thanks in advance.San. |
|
|
|
|
|
Importing data from cube into CSV