sorry but yes - it is still available there to download - you do need to register (free) for web essentials and it is then available

I think you can download both from dev essentials - https://www.visualstudio.com/en-us/products/visual-studio-dev-essentials-vs.aspx

two possibilities

1 - package runs with a config file or /set parameters that enable those steps when running on sql server - this may either be from the dtexec command...

restore needs to be done using option keep_cdc.

you now either need to do the restore again and apply any new transaction to that db if required or you can enable...

Interpretation on one my my clients, a major enterprise, is that as soon as the data is restored to a non prod environment it is no longer production data. And...

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