Quick thought, use the OUTPUT clause, here is an example

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @GUIDINSERT TABLE

(

GUID_ID UNIQUEIDENTIFIER NOT NULL

...

Quick thought, having a Named Pipe as a protocol there looks odd, have the client network configurations changed on the server?

😎

Named Pipes Provider: Could not open a connection to SQL...

itmasterw 60042 (4/3/2015)

---

Hi,

Someone was telling me that they had a text file that was both comma and piped delimited and that they used BCP to import it.

While they did not...

Quick question, as looks like the HTTP Connection Manager is not correctly configured, can you post the connection configuration?

😎

As SSIS does not have the concept of implicit type conversion you will...

Further on Sean's answer, seriously suggest you look into some database design patterns, what you got there is just awful

😎

ZZartin (4/3/2015)

---

My favorite was coming across a system...

t.mounika01 (4/3/2015)

---

Hi

I am trying to use multiple hash in my ssis package and after the multiple hash, i added a lookup column to check if the record exists...

Not certain I...

Now this can easily be mis-understood:hehe:

😎

If I understood the question correctly this should be a trivial task using a ForEach folder enumeration, have a look at this article: Implementing Foreach Looping Logic in SSIS[/url]

😎

Alan.B (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

At the...

Grant Fritchey (4/3/2015)

---

You should be able to simply run CAST against the data to put it into the right data type in the view. But, if the data is not...

Jeff Moden (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

I know I'm somewhat late to the show, haven't read through the whole trail and therefore might be missing something, but my approach would be...

Quinn-793124 (3/31/2015)

---

I am planning on upgrading to ArcGIS server 10.3. We are currently at sqlserver 2008 and and want to upgrade to SQLserver 2014. Has anybody here done that? Is...