Thanks for the suggestion, I understand SQL query would be much simpler in this case, the purpose of doing SSIS is to get ready to cope with complex scenario...

you could check for bad values by running something like 

SELECT * FROM MyTable WHERE ISNUMERIC(currencyfield) = 0
or if using a newer version of MSSQL, use TRY_PARSE instead.

Your problem is likely caused by a bad value in the currency field. 

Having said that, if all you're trying to do is extratc and aggregate, why not aggregate...

I think what you're wanting to do is shred XML (which has been done before, see here [/url]plus a google search will return a lot of results). My concern would...

Can you connect to the SSAS Instance from SSMS (local, not on the VM)?

As a generalized statement, i would think you'd either need federation and/or use of Azure AD, or...

I saw that but to me it looks like you have used one part of the solution and then the other part of the solution but never both parts together....

HOpe this helps --> link

You should be able to convert this answer to ssis derived column script.

http://stackoverflow.com/questions/31977933/sql-ssis-how-to-convert-from-yyyyddd-format-to-regular-datetime

looks like you have colons (for the time separator) in your filename, not sure windows likes those...

Yes. Like i said though, the BillTo FK in the fact becomes superfluous though, because you can get to the analysis of BillTo simply by using the top level of...

Not saying it's the best or only way to do it, but, I'd be tempted to:

1. Create a dimension with Ship To and Bill To customers in it.

PK can...

Phil P we really need a "+1" button 😀

try casting your string (the datetime) to a datetime. From memory it's like (datetype_i_want)"mystring" but you can pick these from the function list anyways.

So what have you tried and what messages do you get back?

it looks like you might need to use the original type and the new type in the unwind call...

When you say the javascript works, what does this mean? You get data? do you get a single record? or at least a flattened recordset?