Viewing 15 posts - 16 through 30 (of 72 total)
select
a.dataareaid
,a.ledgerdimension
,a.inventtranspostingtype
,a.inventtransorigin
,a.voucher
,a.transdate
from
Inventtransposting a
where a.transdate >= ?
transdate is a datetime type
April 22, 2024 at 11:46 am
Adding the option (recompile) slows it down even further , taking an additional 30 seconds to start the dataflow
April 22, 2024 at 9:18 am
Customer rebuild the .dsv and query expression within the model. Redeployed and the problem appeared to be solved.
April 5, 2024 at 12:30 pm
Thank you for this extensive reply. I think it does make a lot of sense.
Next friday I'm going to test through VPN to the clients server.
The really weird thing is ...
April 3, 2024 at 6:23 pm
Well, in this case customers are upgrading and expect old solutions to migrate seamlessly. We are trying to make the best of it 🙂
September 28, 2020 at 10:06 am
You are absolutely right. However, the missing DLL's are part of the MSFT 2008R2 operating system, which means that our predecessor never evaluated the chance future operating systems might work...
September 28, 2020 at 8:09 am
I took the following approach:
...
September 27, 2020 at 8:00 pm
Well sidebar or not, we live in a world crowded with legacy solutions inherited. My team inherited everthing developed based on SSIS from way back when. As much as I...
September 27, 2020 at 6:59 pm
I just checked. The rights on the specific package that is causing trouble is identical for all other packages for the user defined for SQL server Agent.
August 14, 2017 at 1:27 am
Spoon is the GUI of Kettle, the design tool. Kettle nowadays is called PDI (Pentaho Data Integration)
October 22, 2013 at 2:30 pm
Koen,
Download Pentaho Community Edition from sourceforge.net, unzip it to the folder of your choice, create a file or db repository (for example within SQL server 🙂 ) and...
October 22, 2013 at 2:13 pm
I can understand developers picking up SSIS cause it ships with SQL server and is therefore considered 'free' . It may suffice if you have no comparison.
What I do not...
October 22, 2013 at 10:55 am
vidalst (10/22/2013)
October 22, 2013 at 5:27 am
We ran similar performance tests, in this case between Pentaho (PDI ,also Java based) and SSIS. With SQL server SSIS is faster (about 10%), perhaps due to native OLE-DB connectivity....
October 22, 2013 at 4:01 am
Thanks..
I took the project to a Standard Edition server and processed - with translations - to the SE Analysis Database without any problems. When I open the database...
January 16, 2013 at 1:33 pm
Viewing 15 posts - 16 through 30 (of 72 total)