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

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