Viewing 15 posts - 2,386 through 2,400 (of 2,567 total)
when checking that the data is stored on the db do convert to varbinary to confirm. A x00 value will truncate the output on SSMS so its not a valid...
June 20, 2017 at 10:36 am
June 11, 2017 at 9:14 am
I would revise that approach - most likely you only need to do that for the fact table, not the dimensions as those should be by their own nature smaller.
June 10, 2017 at 4:06 am
CRM can be a pain for this.
I assume that this CRM database is either OnPrem or Cloud PaaS.
If not then no access to the database will be...
June 8, 2017 at 2:19 pm
a option that I like is as follows.
requires 3 tables
1 - main table
2 - staging table
3 - intermediary table to allow for alter table switch...
June 8, 2017 at 1:45 pm
in order to link to 8i max oracle client version is 10g
see http://www.dba-oracle.com/t_oracle_client_versions_higher_lower_database_release.htm for full compatibility list - may be outdated but for your purpose it is enough
June 6, 2017 at 6:29 am
By Using SSIS I presume you are aware that it is a licensed SQL Server tool that requires the computer where it is being executed to be fully licensed? meaning...
May 29, 2017 at 5:18 am
Do read the following paper https://download.microsoft.com/download/9/C/6/9C6EB70A-8D52-48F4-9F04-08970411B7A3/SQL_Server_2016_Licensing_Guide_EN_US.pdf.
It does go into detail on how the whole licensing works. And even after reading it you should confirm with Microsoft so ensure...
May 18, 2017 at 12:04 pm
error is quite clear - did you install the ACE driver on the server where you are running the package? and if it is a server why not install and...
May 15, 2017 at 11:40 am
With standard even if you set max memory higher it will only use the 128 so do not worry about that aspect. So the correct thing to do here is...
May 11, 2017 at 2:25 pm
128GB is max that SQL Server instance will use for its buffer pool - and this is per instance.
but as there are other things that can use the...
May 11, 2017 at 12:52 pm
Lets assume the following example
Standard process would be
- dataflow -
Input file to Final table
Approach I am suggesting is
-...
May 9, 2017 at 4:14 pm
May 9, 2017 at 2:53 pm
What is the Oracle client you are installing? link to Oracle download if you can.
And where have you seen that the 32 bit driver will only be released...
May 9, 2017 at 1:22 am
I use the following to get my dependencies.
Only works with objects within the same database - so if there are references to external databases it won't find dependencies...
May 7, 2017 at 5:33 pm
Viewing 15 posts - 2,386 through 2,400 (of 2,567 total)