Super_Grover (11/20/2016)

---

Hi, sorry in advance for the n00b questions, but I'm very new to SSIS.

Here's the story: for my work I need to transfer around 200 tables over VPN to...

You may need an additional index or two to help speed up those queries.

I'd consider adding one on the Records table (OtherId, RecordId, ACTIVE).

Did you add variable 'User::ValidationErrorMessage' to the list of ReadWrite variables in the Script Task's properties?

homebrew01 (11/18/2016)

---

For testing, should I be able to do an "In-Place" upgrade from SQL 2005 to 2016 ?? Or is that too big a jump ?

This is only for...

caspersql (11/18/2016)

---

Thanks for the reply Thom. How do you think people generally work with these servers then? If they can't connect through SSMS due to not having the...

planetmatt (11/18/2016)

---

Phil Parkin (11/18/2016)

---

I suspect that the ? is not a ? in the data ... it's some other non-printable character.

This code snippet shows that ?+ is no problem:

IF OBJECT_ID('tempdb..#test',...

I suspect that the ? is not a ? in the data ... it's some other non-printable character.

This code snippet shows that ?+ is no problem:

IF OBJECT_ID('tempdb..#test', 'U') IS NOT...

--Edit: removed silly question

planetmatt (11/18/2016)

---

I have a simple package that takes data from a SPROC and puts it in a .CSV file.

Until today, it ran without issue.

The error it's now throwing is

"The data...

tocy1980 (11/18/2016)

---

I have tried this:

and it doesn't work.

Get this error: he multi-part identifier "Linked Servers.DATA STORE LINKED.'ET NEW$'.Parts Used" could not...

tocy1980 (11/18/2016)

---

I mean update (fill with some values) one table column from another table column.

the trick is here I don't know how to connect Linked Server e.g.

update Server_FINAL

set Server_FINAL.Parts =...

I've read your post a couple of times, but don't understand the problem. What do you mean by 'column data'?

Please make a note to put it back again tomorrow evening :smooooth:

Jerid421 (11/17/2016)

---

Hi All,

This is more a question of theory than a technical one, but here it goes. I need to mirror (23) SQL tables in one database over to...

Eirikur Eiriksson (11/17/2016)

---

The execution plan for my version is significantly...