abhish_216 (4/3/2012)

---

Apart from the above one i have the following errors also

Error: 0xC020901C at Data Flow Task 5, OLE DB Command [177]: There was an error with input column "ename"...

You mean connect directly to the universe? Not sure if that is possible with SSIS. SSIS...

Is that the only error that you get?

nilesh-652355 (4/2/2012)

---

Hello...

I have following records....

CompanyID.......Quantity......Sales Year

123.................12..............2011-12

123.................34..............2011-12

123.................12..............2011-12

123.................15..............2012-13

123.................12..............2012-13

123.................12..............2012-13

Now, I want to write a view so I can get the following output

with sum of Quantities with...

Easy one, thanks!

sqlserver8650 (4/2/2012)

---

Hi

Connecting to Oracle is not a big deal

Just you have to do down load the client tools on your dev and prod box

Use the ODBC connection to get...

We're building the...

If the data is stored in a relational database engine, chances are good that you can get it with SSIS.

Try the following expression:

RIGHT((DT_WSTR,18) "000000000000000000" + REPLACE((DT_WSTR,18) myInputColumn),".",""),18)

I can also recommend this book:

Smart Business Intelligence Solutions with Microsoft SQL Server 2008

What errors do you get?

What is the source? SQL Server, Analysis Services?

Can you show us both queries?

Maybe try a Reporting Services forum, this one is actually for Integration Services.

Hi-la-rious!

I do admire your patience.

I would probably already stopped looking at that thread after 3 or 4 posts.

You're right.

This makes copy/paste a...

Well, the wizard will create multiple dataflows if you import a lot of sources.

I believe the wizard puts around 5 sources in one dataflow, and then creates a new one.

I...