Stretch Database in SQL Server 2016

Comments

Post a Comment

Popular posts from this blog

Error Rule Same Architecture Installation Failed

I got the error message saying that “Rule Same architecture installation failed” while installing business intelligence tools for visual studio 2012. Then after few minutes of surfing I found the solution in online. The root cause of this error is, you probably selected add additional features to the existing instance. You need to change to new installation and do the installation steps and this time you won’t get any error.
Read more

Generate Data Time Dimension Table in SAP HANA

Image
We can generate the Date Time dimension table in SAP HANA very easily by existing feature. In the Quick Launch option you can able to see “Generate Date Time Dime” Follow the options and create a table either fiscal or Gregorian. The created tables will be reside under _SYS_BI schema.If the you are chosen Gregorian option then the table name will be “"M_TIME_DIMENSION”. Table name may change based on the granularity that you selected. If you are choose week as granularity then table name will be “M_TIME_DIMENSION_WEEK”. If the option is Fiscal then table name will be “M_FISCAL_CALENDAR”
Read more

SSIS BULK INSERT–“fetch a row from OLE DB provider "BULK"…”

Image
I created a simple SSIS Package using “Bulk Insert Task”, here am trying to upload the data from text file into my database. I have configured everything and ready to go, while execute the package, the error was thrown “[Bulk Insert Task] Error: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information”. Then i checked the column delimiter and fixed the issue, If you are using comma separated value then use “Comma {,}” as column delimiter.
Read more