adamfewtrell (4/6/2016)

---

Thank you for your suggestion.

I believe the three options I have are to increase the server memory, rewrite the package, or reduce the amount of data it is...

Hi Nic,

This...

adamfewtrell (4/3/2016)

---

I have a data flow that has failed on a merge (left outer join) with :

15 0xC0047048 error codes

2 0xC0047012 error codes (Description: A buffer failed while allocating 10483200...

From BOL:

To Uninstall an Instance of SQL Server

To begin the uninstall process, go to Control Panel and then Programs and Features.

Right click...

C# is not exactly my forte, but can you not just use Process.Start? Like:

Process.Start("dtexec.exe", "Arguments here");

More...

GonnaCatchIT (4/4/2016)

---

Hi Team,

I have windows server 2008 r2 64 bit box where I have setup my Integration services.

The SSIS packages are called via .net c# 2.0 directly connection to SSIS...

tejalchaudhari89 (4/4/2016)

---

Thanks for your help.

#1 is something I would like to use. But I have one additional requirement to the solution proposed in it. I need to get value of...

You need the full version of SQL Server, not Express. I was mistaken about Advanced Services.

You seem to have installed SQL Server Express. This does not include SSAS unless it is the "Advanced Services" version, which this doesn't seem to be.

tejalchaudhari89 (4/1/2016)

---

I could have used a Data Flow Task directly, but there are 2 concerns : 1) The SQL command to execute is dynamic and 2) I need to fetch...

You can get to it if you are able to install the ASSP assembly on your instance (https://asstoredprocedures.codeplex.com/). Then the following (or a variation of it) will return your connection...

sqlchuck4 (3/29/2016)

---

After looking at your response, I figured out that the issue is that for character fields where a case statement in the source view is used to calculate the...

sqlchuck4 (3/28/2016)

---

We are working on building cubes in SSAS using GreenPlum as a source. We are using an OLE DB driver created for GreenPlum to pull the data. ...

Brandie Tarvin (3/24/2016)

---

Brandie Tarvin (3/24/2016)

---

PB_BI (3/24/2016)

---

I have not. And now I will. Thank...

Brandie Tarvin (3/24/2016)

---

Hrm... If I delete the .vb reference in the Script Task, will it rebuild when I rebuild the task itself?

Or am I just asking for a world of...