Viewing 15 posts - 2,026 through 2,040 (of 2,701 total)
March 19, 2019 at 3:25 am
Today, after I changed the relational database that feeds the cube from compatibility level 100...
March 18, 2019 at 4:12 pm
March 18, 2019 at 11:23 am
March 18, 2019 at 3:24 am
March 18, 2019 at 2:57 am
This is really the bases of ETL processing.
Following is a standard pattern to load data from staging into one or more destination tables
1 - Load...
March 17, 2019 at 9:43 am
March 16, 2019 at 10:54 am
I would say its not so much the SQL but the VM and the Host config that matter.
How many CPU's does the Host have and how many are...
March 16, 2019 at 7:53 am
As I mentioned before OpenXML is an option. Didn't tried with larger contents but likely to work.
a tool that implements OpenXML and can be used from SSIS (in...
March 16, 2019 at 3:39 am
March 15, 2019 at 3:19 pm
Steve does mention the constraint on the answer "Note, if the file is not empty, you cannot remove it.)
March 15, 2019 at 5:00 am
March 15, 2019 at 2:42 am
hum.. I've used this even with higher than 4k and never an issue.
from docs - For SQL Server 2014 (12.x) and earlier, allowed input values are limited to 8000 bytes.
March 14, 2019 at 1:07 pm
March 13, 2019 at 8:40 pm
this is one of the issues with using the ACE driver - and many more issues can be found if you processing same file layout with changing contents.
March 13, 2019 at 3:47 pm
Viewing 15 posts - 2,026 through 2,040 (of 2,701 total)