assuming that what you say is fully correct and that you are using the CRM SDK to extract the data from CRM then it would seem that someone managed to...

phanithota26 (5/28/2016)

---

Hi All,

My SSIS package getting blocked at Pre Execure for more than 14 hours which is not at all acceptable in real time.

My source pulling 90 millions of records,...

Hi Mike,

group by cube and group by rollup do not give same results. so cube is the correct one for this purpose.

as for why the 3 num and not just...

I would also try the following sql to see what you get.

select top 10 tbl.BusinessDate

from dbo.TableNameT1 tbl

where tbl.BusinessDate < '17530101'

you may have two possible issues on your table

column may have a default other than null and if so that is what you are getting

whatever method you are...

code formatted for clarity and the incorrect alias fixed for year part of date

Answer in english even though I am Portuguese so others may benefit of the answer if it...

SQL-DBA-01 (5/10/2016)

---

Hi,

When I try to run the below command, the variable ($pk_key2) comes as NULL.

Can you suggest if something is going bad?

[string] $pk_key2 = invoke-sqlcmd -query "SELECT column_name FROM...

issue is using Oracle.ManagedDataAccess.Client; -- don't use the managed class.

Example from John should work but it will be slow depending on the volumes.

if you can it might be better to...

DiabloSlayer (5/9/2016)

---

Hi There,

My mistake, I just went back and checked, the hours are like '3.5' and '4' instead of 03:30 and 04:00 as initially stated.

So when I ran the

convert(datetime,STARTDATETIME)...

Ah.. if it was that easy.. 1 to 1 mapping.. (sigh).

On the migration I did 1 segment was converted to 200+ Tables, each with their own set of primary key...

the original developer has most likely defined a expression to build the connection string - on the properties of the connection, look for expressions and see what is there.

Most common...

it is such a small program that any programmer will be able to do it - and if not then hire one to do it either in c# or vb.net...

no Oracle isn't better suitable - and SQL Server Express will still hold with that volume. what you need to find out is exactly how many records each table that...

Because you have CLOB/BLOB data my advise is to use a C# program that reads from sql server and loads to Oracle directly using the OracleBulkCopy http://docs.oracle.com/html/E10927_01/OracleBulkCopyClass.htm

Note...

Rankerg (5/3/2016)

---

Thanks Again and see my inline response

frederico_fonseca (5/3/2016)

---

going to reply to your 4 comments.

1 - you do not need to migrate to Microfocus - I was just stating what...