register ,go to downloads, search for "sql server" and both versions appear

and try this link - may or not work https://myprodscussu1.app.vssubscriptions.visualstudio.com/Downloads?q=sql%20server

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