Right. That wasn't entirely clear from your original post.

I guess they're about the same performance...

This article explains how you can do it:

http://bennyaustin.wordpress.com/2011/02/04/ssis-name-of-errorcolumn/

You can always make up a table with sample data with the same structure as the actual table.

You need...

The SSIS package needs to be stored and executed somewhere right? Create a SQL Server Agent job on that machine and start the job from the Unix box.

I would simple schedule the package with a SQL Server Agent job (use the SSIS jobstep) and use a proxy.

Why not just do the following?

select product from tablea WHERE brand_id IN (1,2);

What if you try with the command line?

Install SQL Server 2012 from the Command Prompt

Here you go:

DECLARE @AsonDate DATETIME = '2013-08-11';

SELECT CASE WHEN DAY(@AsonDate) < 7

THEN DATEADD(d,6,DATEADD(d,-(DAY(DATEADD(m,-1,@AsonDate))-1),DATEADD(m,-1,@AsonDate)))

ELSE DATEADD(d,6,DATEADD(d,-(DAY(@AsonDate) - 1),@AsonDate))

END;

Interesting question. I haven't used MDS yet, so definately learned something.

Curious why SSIS is in the title though. At first sight it doesn't have to do anything with the MDS...

Tim Mitchell (9/5/2013)

---

You won't find that information in the package itself. If you have logging set up on the package, the logging information will give you that information. ...

Formatting should be done in...

pmscorca (9/5/2013)

---

Perhaps it could be enough to install the Oracle Data Access Components (ODAC) for Windows and not an Oracle client, isn't it?

However, it should be useful to know any...

How do you report?

If you use Reporting Services, this article explains number formatting:

Formatting Numbers [SSRS][/url]

pmscorca (9/5/2013)

---

Hi Koen, thanks for your reply.

SSIS 2012 runs on a db server with SQL Server 2012 64-bit and Windows Server 2012 64-bit: however do I need to install also...

On what criteria do you select those 4 rows?