Thank you for the detailed response, whenriksen.

You are right in thinking that this is for a work-queue table ... in this case, for queues of SSIS packages waiting to be...

arkiboys (10/28/2016)

---

Phil Parkin (10/28/2016)

---

arkiboys (10/28/2016)

---

Thom A (10/26/2016)

---

Instead of using variables in the child package, use parameters. You can then pass the variables within the parent package as parameters to the...

arkiboys (10/28/2016)

---

Hello,

What topic does...

I just tested using 2013 ACE drivers and, even there, there is a 256-column...

If you look at the Excel connection string, is it using JET or ACE drivers?

Lynn Pettis (10/28/2016)

---

One of the people I work with is trying to write an export (using the wizard) to pull data from 107 tables to an Excel spreadsheet that can...

ranala (10/28/2016)

---

Hi Sir , Madam,

we are developing SSIS ETL assets using visual studio 2010 , MS SQL Server version as 2012. my client is asking about language translations from Chinese,french,Spanish...

kyagi.jo (10/28/2016)

---

I have a server with SQL Server 2016 on it, using SSDT 2015, and I have tried using project deployment for one of my test packages. It looks like...

quinn.jay (10/27/2016)

---

Hello,

I'm new'ish to SQL Server and taking over an new/recent SQL Server 2012 with SSIS and SSAS, and VS 2013 w/DT. All development, testing and production occur on this...

philand3 (10/27/2016)

---

Dear All,

I would like to get query with page break which after each group(preffered_name) results end, my sample code given below which gives without page break ..

SELECT preffered_name ,ci.person_num,...

I suggest that you replace these rows

EXEC dbo.s_DropTempDBTable '#Error';

GO

with this

IF OBJECT_ID('tempdb..#error', 'U') IS NOT NULL

DROP TABLE #error;

Out of interest ... Temp tables get dropped automatically by the system ... why are you trying to do this manually?

Eirikur Eiriksson (10/26/2016)

---

homebrew01 (10/26/2016)

---

I'm considering upgrading our production server from 2005, at the same time we upgrade servers. I have not kept up on the most recent versions. No specific...

Any clairvoyants here today?

Good luck with that, as you've given us neither the text nor the expression.