You need to use another SQL statement (DML, so insert, update, insert or merge) that actually uses the CTE.

WITH CTE_Test (ID)

AS

(

SELECT CAST(id AS VARCHAR(60)) FROM cat_transaction

EXCEPT

SELECT ext_reference FROM Patricia.dbo.BUDGET_LINE

)

SELECT...

Ryan1 (6/17/2014)

---

I am building a cube in 2008r2 analysis services (BIDS) which requires me to link two views. The first view contains only measures (these measures are calculated by...

NVARCHAR is when you store your data as unicode.

I expect this might give less issues, but you still need to do the conversion at sybase or in SSIS.

chandan_jha18 (6/17/2014)

---

Thanks for your great solution using recursion. Now, I am in a spot of bother due to my own question. If I pre-populate the time frames lets say 1...

sugnu iu (6/17/2014)

---

Hi all

I got a question which i could not find answer given my knowledge of SQL.

one of my users performed a DROP TABLE on a table with 96...

It is like any other email system.

People who have access can send emails. (unless you...

Suresh Arumugam (6/17/2014)

---

I have so far tried with 50222 and 932 code pages for OLE DB Source and still see the junk data issue.

Thank you for taking time to...

And that is why, ladies...

Suresh Arumugam (6/17/2014)

---

Hi Koen,

SSIS OLE DB Source by default has taken the data type as DT_STR which I did not change. I have tried with AlwaysUseDefaultCodePage property also TRUE. Still...

The information schema views are...

Duplicate post.

Original question with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1582202-146-1.aspx

You can use INFORMATION_SCHEMA.columns for the same purpose. Filter on the table and check if the column exists.

The Send Mail Task in SSIS uses an SMTP connection manager, meaning it connects to the mail server specified in that connection manager.

Database mail is managed inside SQL Server, but...

What is the data type used in the SSIS data flow?

Koen Verbeeck (6/11/2014)

---

martiankeeper (6/11/2014)

---

What I find slightly confusing is the line in this Article here

SQL Server 2014 - What's New in Analysis Services and Business Intelligence

http://msdn.microsoft.com/en-us/library/bb522628.aspx

Multidimensional models now also support...