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.

rsampson (1/25/2016)

---

Hi:

SSIS 2010 fairly simple process, had to hardcode flat file source and OleDb Destinations.

Note: Entire package has delayed validation = TRUE

Want to move...

TAman (1/22/2016)

---

I have SSIS package created in 2005v for loading excel source data to OLE DB destination. In my Data Flow Task I have Excel as source. I...

OK, but could...