Where are you running the package? BIDS or on the server?

Did you do the correct mappings in the OLE DB Destination?

Did you select the correct table in the OLE DB...

Strange. The error says it's looking for ACE OLE DB 12, while the documentation says ACE OLE DB 14 is needed.

Data Sources Supported (SSAS -Tabular Models)

Are you sure the ACE...

Regarding the cube:

did you deploy the cube? If you right-click on the SSAS database, select properties and go to the Deployment tab, what's listed for database in the target section?

To...

Very nice article. The FORMAT function seems very promising!

One small remark: maybe include a link to the BOL page of CONVERT you're referring to. (although it's pretty easy to find...

Did you install 32-bit AND 64-bit providers?

How are you selecting the data and the header?

Do you use a query somewhere?

There is no screen shot.

marlon.seton (3/22/2012)

---

I'm probably exposing my ignorance here but with a view on just one table is there any difference between having an index on the view and having an index...

paul.knibbs (3/22/2012)

---

kapfundestanley (3/22/2012)

---

The typo costed me for real,what is 'SQLAgentAgentRole' thought that was a trick any the only meaningful and true answer was the first one,although it did include...

As long as the connection manager is not used, it will not fail the package.

It's no problem if the flat file is no longer available, otherwise we couldn't use the...

Just guessing here, but what if you store e -aoa in a variable?

So your arguments expression is:

@[User::Arguments] + @[User::FileName]

Otherwise, whip out the plain old script task. 🙂

Can you be a bit more specific? Are there errors or do you not get the desired...

Charmer (3/21/2012)

---

Hi friends,

i try to run some T-SQL statements in ssms like insert and update left outer join with 5 tables...due to large records it takes too much time..

so if...

Indeed, small typo in the correct answer.

However, very nice question, thanks Steve.

(you read that MSDN page one day and you thought: "I shall make 5 QotD of this!"? :-D)

Jeff Moden (3/12/2012)

---

My answer would be "whatever it takes". ...