Ah yes, you need to use jobtokens for that.

Use Tokens in Job...

In my opinion, it's incorrect usage of the term.

It's a...

Euhm. A tabular model is not a cube, if that is what you are going at.

A tabular model are...

I guess you can just adapt the code that creates the file.

Is it located in the sp?

Could you give an example?

chamindak (7/1/2014)

---

I have student table store in student contact number ,parent contact number , name address ,etc. and need to pivot parent contact number and student contact number separately and...

You should create a system DSN first on the machine, using a Postgresql driver.

Don't you mean ODBC instead of OLE DB?

It is possible, sure.

Matt Crowley (6/30/2014)

---

For this procedure, no. Anyone who runs it would need to own the table (or the database), in order for no error to be returned. There...

SQLTougherGuy (6/30/2014)

---

Hello all,

Quick question... I am in the process of moving my 2005 SSAS cubes to 2012. From what I understand, 2012 has a tabular model now (currently researching this)....

Seems like a bit of overkill for such a simple statement.

Maybe they just don't want SQL code inside the SSIS packages.

ps_vbdev (6/30/2014)

---

Additionally

If i have one mini-dimension for both color and size this would still give about 5million combinations so could i split this further down to having two mini-dimensions, one...

Sometimes I answer: "I'm a consultant. I get paid to pretend that I know better than you do." 😀

Some people have mentioned the "free tech support" problem. Anyone who had...

annjunk (6/30/2014)

---

I know this is an old topic, but this seems to be a known "feature" with flat files with empty strings going into a SQL table in SSIS.

The work...