Not 100% sure, but I thinks this is how you should do it:

1. Take an Execute SQL Task and execute your stored procedure there with the following code:

EXEC my_stored_procedure my_par1...

Try running the package in 32-bit mode. 64-bit and Excel gives problems.

If it still fails, let us know.

honza.mf (5/20/2010)

---

da-zero (5/20/2010)

---

You should specify which environment is used in the question. As a SQL 2005 user, I saw that there would be an error. You even don't have to...

honza.mf (5/19/2010)

---

Maddy...! (5/19/2010)

---

hello frnds....

wht ever it may be in order to run completely a block of t-sql code it should be syntax error free

i think there is no...

| --> %7C hex and | unicode

¦ --> %A6 hex and ¦ unicode

Nope, that is the | symbol, while the original file has...

As I see it, the symbol ¦ is not listed as one of the delimiters in the dropdown menu of the flat file configuration manager.

You have 3 possible solutions:

* let...

I think you can do pretty much the same with SSIS.

Read the file and perform a lookup on a lookup table containing the "bad" files.

Redirect your error output to a...

Why the double post?

I think you are using the wrong tool for the job. SSIS is a data movement tool, an ETL tool.

I believe it is far easier to just...

Nice question. Of course I got it wrong, as I thought it would be the same answer as the QotD from 13th of May. 🙂

Set the OrderBy property to Key of your month attribute.

Reprocess the dimension and see if it works.

That is odd.

Can you give a more detailed description of what you're doing, how you're doing it and what you are trying to accomplish?

1) It is only for 2008 or higher (unless it will be tossed away, as this blog post is hoping for: http://sqlblog.com/blogs/jamie_thomson/archive/2010/05/11/five-things-ssis-should-drop.aspx)

2) Create a variable that will hold the filename...

I don't think that SSIS has built-in features to get that sort of information, so I think you'll have to script in .NET to obtain that info.

andrew.ingram

---

Recently a number of users have asked whether it would be possible to browse the cubes on-line rather than using Excel as especially while working...