You're correct, the import wizard uses SSIS behind the scenes.

I'm still quite curious as to why Visual Studio hangs. The ACE OLE DB provider only samples a few rows to...

robin.pryor (1/6/2014)

---

I'm setting up a maintenance plan on a development server and I have to create a cleanup step.

The bak files get created on the DEVSQL02 E:\ drive and then...

hjvegt1960 (1/6/2014)

---

OK, sounds do-able

I will purchase this edition

Maybe an additional question: like I mentioned in my 1st thread: I have created a linked server to another database (mySQL)

If I install...

Gabe T. (1/6/2014)

---

Hi SSC,

The extent of what I've used SSIS up till now has pretty much been moving data between environments (truncate table, insert from source to dest), but I...

What if you don't use the Excel source, but the OLE DB source?

(you can write a SQL query to get data out of Excel)

You are using the service account to process the cube, but this account doesn't have permission to read data from the source.

3)OLE DB error: OLE DB or ODBC error: Login...

You can re-run the SQL Server set-up, add features to an existing installation and check what is already installed.

You can achieve this functionality when using slicers instead of filters.

Grant Fritchey (1/6/2014)

---

Ed Wagner (1/6/2014)

---

I think I'd have to vote for the 270-column table where the upload is not working properly. It...

When exactly do you get the error?

Are the client tools connectivity installed?

Nice question, thanks.

Nice question, thanks.

Great question.

Happy 11111011110 to you all!

Nice one, thanks!

Thanks for the question.