.xlsx is supported in SQL Server 2012, but not in earlier versions.

You can build 21 data marts in SSAS and still link them through linked measure groups and linked dimensions (for example: Linked Measure Groups). However, I usually advice against these...

Brandie Tarvin (8/27/2013)

---

Koen Verbeeck (8/21/2013)

---

In the category of "Are the posted answers getting worse?"

http://www.sqlservercentral.com/Forums/Topic1485861-1063-1.aspx

From now on I shall answers questions in the following manner:

"I have no flipping clue. Please post...

You use the CTE before the MERGE statement.

WITH myCTE AS

(

...

)

MERGE ...

Why is it so important to know the exact algorithm?

No problem, glad to help.

Maybe you can locate the missing assembly on your local computer and copy it over to the server?

Do you get this error when running in BIDS?

=iif(Fields!FROM_LOC3.Value = "", iif(Fields!FROM_LOC2.Value = "", Fields!FROM_LOC1.Value, Fields!FROM_LOC2.Value), Fields!FROM_LOC3.Value)

subbareddy542 (8/27/2013)

---

whev ever i had run package through command prompt below sitution.

when ever i have created connection in project level

that time package was failed.

when ever i have created connection in...

GilaMonster (8/27/2013)

---

When they finally make it mandatory, T-SQL that's not terminated by a ; will indeed break (hence mandatory)

What version they'll do that is however is another matter.

I...

http://en.wikipedia.org/wiki/Globally_unique_identifier

If you deployed them to the filesystem, you can see them by going to that directory.

If you deploy to the filesystem (and not in MSDB or the SSIS package folder),...

Where did you deploy them to? Which version of SSIS are you using?

Jeff Moden (8/27/2013)

---

Glad some things never change.

I edited my post without realizing that you had responded. Isn't there some "For Each" loop that can get and loop through files...