L' Eomot Inversé (11/7/2011)

---

It was last time I looked.

But how about local loopback connections (TCIP to 127.0.0.1:1443)? ...

MuraliKrishnan1980 (11/7/2011)

---

[font="Tahoma"]

Thanks Koen.. It worked exactly the way that i was looking for.. Thanks for your help.. I was trying my best without any help, but could not find the...

I would keep the packages as small as possible. That way you won't have to wait 15 minutes to open a package and wait for the validation to finish.

82 different...

My first guess:

get a dataflow inside a for (each) loop. Loop as many times as you need to generate output Excel files (so I guess hundreds?)

Inside the dataflow, read the...

By changing the property DefaultMeasure on the cube? It...

No, but there is a general SSIS forum in the Data Warehouse section 🙂

(to be honest, that forum is not used frequently....

Jim Murphy (11/4/2011)

---

Congratulations Jack! I am very happy to see your award. Just...

Stefan Krzywicki (11/3/2011)

---

Anyone know a good source for on-line SSIS help?

I'm having a problem with the speed of my main SSIS load package and would love to find out what...

Excellent article, thanks!

I'm starting to learn MDX, and this article is a great start.

On to the rest of the articles of this stairway series!

abhijeet.send2me (11/2/2011)

---

SELECT

{[Date].[Calendar].[Calendar Quarter].&[2007]&[1],

[Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),

[Reseller].[Reseller Type].[All Resellers] ON AXIS (1)

FROM [Adventure Works]

where [Measures].[Reseller Sales Amount]

and

SELECT

{[Date].[Calendar].[Calendar Quarter].&[2007]&[1],

[Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),

[Reseller].[Reseller Type].[All Resellers] ON AXIS (1)

FROM [Adventure...

It does. You have two options to store packages on the file system:

* in the SSIS package store: this is a specific secured folder in the SQL Server directory. In...

In the child report, how did you configure the parameters? These should be set as hidden or internal. That way users cannot modify parameters and thus there is no need...

Here's how:

1) You create a table with nothing in it. You drag Color and StandardCost to the two columns on the right, which leaves you with one empty column at...

Apparently, the account that SQL Server Agent uses to execute jobs on the production server doesn't have sufficient rights to access the folder where the package is located.

Either give that...