Did you refresh the metadata of the data flow?

Tabular and/or multidimensional?

This book covers tabular well:

Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model

It's not easy though and I think they use their own code examples.

From the same...

venkat5677 (5/14/2014)

---

Hi,

I got below error when I upgrade SSIS Package from 2005 to 2008r2.

Truncation may occur due to inserting data from data flow column "ColXXX" with a length of 255...

I guess sqlConn = cm.AcquireConnection(Dts.Transaction) is the code that breaks, as you get an invalid cast error.

When I look for sample code - Use Connections Properly in an SSIS Script...

yuvipoy (5/14/2014)

---

If i use NEWSEQUENTIALID() then there will be less fragmentation ok good, but how about the join behavioural ?

for the test of 1000 record on a table with...

Withing...

Unless you have a very good and specific reason for using GUIDS (like distributed databases or...

Maybe.

You can only know for sure by testing it.

Do you load the data in parallel?

Yeah, the fonts for URLs are really subtle.

You need to hover over the functions I mentioned with your mouse.

Well, there must be something wrong.

Are you connecting to the correct server?

Did you read the documentation I linked to?

ronan.healy (5/14/2014)

---

well i dont no how to pull back what i want

you mentioned use right in one of your messages so i tired it.

im new to ssis so have no...

Just for kicks, does it work when you use a proxy in the SQL Server Agent job?

RTRIM removes trailing whitespace,...

Or you can use RIGHT instead of SUBSTRING, even easier.