I don't think so.

You actually have to install SQL Server to make it work.

You mean like checkpoint?

It is not an instance wide command though.

In your second connection string you used the JET OLE DB, while this should be the ACE OLE DB.

That is correct.

MMartin1 (5/20/2014)

---

In SSIS 2008, you can right click the Project (top node) in the VS solution explorer. From there go to Properties , Debugging , Run64BitRuntime... set this property to...

SQL is delicious (5/1/2014)

---

brad.mccollum (5/1/2014)

To give you a little more insight as to the general nature of the SSIS package, it will basically be looping through a folder once nightly...

There has to be a SQL Server instance running somewhere that the application can access.

If you did not install SQL Server on the machine, where is the application connecting to?

Jeff Moden (5/20/2014)

---

I'll be the first to admit that I don't know much about SSIS but my personal feeling...

sparikh (5/19/2014)

---

Hello,

I am new with OLAP

I have almost followed all steps to create cube in BI.

But when i click on process button i got the following error.

The project could not...

Which provider exactly are you selecting from the drop down box?

What if you configure the password property itself with a configuration?

With a lookup component set to ignore failure, the number of rows is exact the same as the number of rows that go on.

If a lookup finds multiple matches, it...

What if you launch the set-up yourself and choose the repair option?

Do you have the installation media of SQL Server somewhere?

Normally Visual Studio 2012 works against SQL Server 2012.

Make sure the business intelligence templates (SSDTBI) are installed though, otherwise you cannot open SSRS projects.