PSB (1/22/2016)

---

I have used a data conversion task and converted to DT_TEXT and then mapped it back to the destination. However the error still persists.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED....

As I do not have a couple of hours to burn today, I did not go through all of your code 😎

However, I suggest that you look into SQL Server's...

PSB (1/22/2016)

---

Hi,

I am trying to bring in two fields from a SQL database (Comments,Description) stored as varchar(MAX) NULL . My destination table also has the same data type.

I am using...

g.britton (1/22/2016)

---

I'm using SSIS RAW files in one application. However, I can't see how to dynamically configure them. There are no Expressions in the RF components that I...

You could try something like this.

Not very elegant, to say the least.

SQL!$@w$0ME (1/22/2016)

---

Hello Guys,

I was trying to see if it's possible to get the current process for a table update(stored proc/query) and log to an audit column using an update trigger....

MMartin1 (1/21/2016)

---

Brilliant work Orlando. It makes sense that the execute sql task is returning the results of a SELECT. That will be in the form of a result set,...

Try to imagine yourself reading this thread for the...

PearlJammer1 (1/21/2016)

---

Phil

We made a change in the stored procedure which the package call and it now does a cast to the non unicode datatype (varchar) and this package is using...

What's your question?

As we do not know where you are from, we do...

Tim ffitch (1/21/2016)

---

Phil Parkin (1/21/2016)

---

Tim ffitch (1/21/2016)

---

I can see where this would be useful for multiple environments on the same server. When dealing with multiple servers then it would be...

I love a good understatement.

I get very irritated when we run out...

Tim ffitch (1/21/2016)

---

I can see where this would be useful for multiple environments on the same server. When dealing with multiple servers then it would be better to create your...

Eirikur Eiriksson (1/20/2016)

---

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb...

Asterix.

Asterisk.

😀