What do you mean by the following?

Lynn Pettis (1/28/2016)

---

Hey Phil, can you add a rollback in the CATCH block? I just noticed that I forgot that in the code I uploaded.

I fixed the code I...

Lynn Pettis (1/28/2016)

---

Tried posting how I might approach writing this update, but couldn't do it directly from work. When I got home last night, didn't even get on my...

Yes there is.

Here is a design pattern for you. This assumes that you keep the date created and date modified columns from your source database in your target database too.

1)...

ringovski (1/27/2016)

---

The end result i am trying to achieve is to export the XML into another table or tables depending on the data structure, then write some reports via SSRS.

select...

ringovski (1/27/2016)

---

Orlando Colamatteo (1/27/2016)

---

It is still not clear to me what you are trying to do.

Or are you looking to copy data from an XML column in one...

kavithaje (1/28/2016)

---

Hi,

I know CDC is the best way to do incremental load from source to destination. But since my source DB is Read only and i do not have sufficient...

utekjunk (1/27/2016)

---

Thanks Phil for the suggestion. I will go back and review my approach.

I am new to SSIS and don't know what the best practice is...

that's something...

utekjunk (1/27/2016)

---

Yes, I put break points in every event in the main SQL task. It shows that presultCustomText1 is still "default" at the onError() call.

I notice that, the event...

Have you verified (use breakpoints) that the variables' values are correctly being set by the ExecuteSQL task?

Just expanding on this discussion a little: if there are people here who know both AWS and Azure, it would be nice to hear their views on pros and cons...

ringovski (1/26/2016)

---

Hi All,

I have a SQL table with a column data type 'Column Set,XML(.),null) called tp_columnset and not all the rows have data but some <XML> entries. I am trying...

Igor Micev (1/27/2016)

---

Phil Parkin (1/27/2016)

---

kavithaje (1/27/2016)

---

Hi,

Am new to SSIS. I have 2 different tables lying in 2 different DB on 2 different Servers.

I need to merge both the tables to...

kavithaje (1/27/2016)

---

Hi,

Am new to SSIS. I have 2 different tables lying in 2 different DB on 2 different Servers.

I need to merge both the tables to single destination table which...

As I suggested; give them values.