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.

mcfarlandparkway (10/26/2016)

---

I have a table of ssisconfig table where I stored all the connection strings with a type column.

In the package I took execute sql task and queried with ssis...

dramaqueen (10/26/2016)

---

I am currently looking at identifying duplicate names and looking for behavior patters. A duplicate in this case is very high level and there is risk involved as you...

BWFC (10/26/2016)

---

jasona.work (10/26/2016)

---

Brandie Tarvin (10/26/2016)

---

jasona.work (10/26/2016)

---

Phil Parkin (10/26/2016)

---

HanShi (10/26/2016)

---

BLOB_EATER (10/26/2016)

---

I liked Eric's response - "get a job...

kesavan.rv (10/26/2016)

---

Hi Friends,

All off sudden in my PROD SQL server memory was reduced to zero(As the minimum memory was set to 0).

Is there any way to find which one...