that is the reason why whenever looking at this type of data I use a replace(field, char(0), ' ') to look at the contents - in addition to the convert(varbinary...0...

j-1064772 (6/21/2016)

---

[h3]select convert(varchar(max), val) as NormalConvert -- gets obliterated as second byte is NULL[/h3]

"Obliterated" ?

Isn't the 00 byte a terminator as in other languages ? So the conversion simply stops...

2 comments.

when looking at a file that may contain invalid chars always use a hex editor - notepad++ and similar are not really good at this.

regarding the "empty" record try...

komal145 (6/15/2016)

---

Since Stage table is raw data and destination is key columns we cannot merge Stage and destination.

my package is something like below

Stage(Column1 , column2)

|

|

Lookup1(get Column1key1)

|

|

Lookup2(get Column2key2)

|

|

Destination (...

no need for the reverse.

first byte is the size of the string

second byte is null - maybe on longer strings it gets populate

declare @MyTable table

(id int identity (1, 1)...

sample code to replace carriage returns and linefeeds from a column

generic and will go through all columns - test conditions for property.name can allow you to restrict the replacement just...

ram302 (6/11/2016)

---

Hi all,

I'm trying to replace text in a CSV.

The CSV line looks something like this:

"Field One","Field Two","Field

Three","Field Four"

So I tried something like:

(Get-Content $csvfile) -replace "Field`n", "Field" | Set-Content $csvfile

But...

very raw example

insert into table7

select column1

from OldTable1

where columnx = someconditionvalue1

order by desiredordercolumns

insert into table24

select column1

, column3

, column9

from OldTable1

where columnx =...

tomd-982312 (6/8/2016)

---

drew.allen (6/7/2016)

---

This type of processing is referred to as RBAR (Row By Agonizing Row), because it is a HORRIBLY inefficient approach in the vast majority of cases. Why don't...

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...