I'm with the DBA: the true version of code is what's in Production.

And if your development and release processes are strict enough, the version in SC will match what's in...

What have you tried so...

Hugo is heading in the right direction. This is quite tricky. Here is an outline solution.

Create a flat file connection pointing to your source file. Set the connection to have...

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