Have you tried running a full processing on the cube. That might work in the short term but take a long time if you have billions of rows. I think...

In

select @DT = start

from openxml ( @idoc, '/root', 1 )

with ( start datetime2 'start' )

Try changing the DATETIME2 portion to DATETIME2(0) to see if keeping the data type consistent...

How did you only pick those items with a count of 1 or 2 in the batch? Did you use a CTE /inner view ?

Thanks

Would the data only be for one specific date? To span it across multiple days it is a...

One interesting illustration you can do against SQL Server and Oracle is compare the results of a cursor to a triangular join, on each system. I think we all agree...

That would be worth one - two hours per month 🙂

The XML data type is not intended to be comma delimited, it is a different way of structuring data. So you are not able to pass the whole xml data...

Just for any one else interested, with an ETL issue like this you can add a Data Viewer to the data flow and see the rows thrown at the destination...

I think you mean to say that you want one variable to hold three values... and pass this to one method on the web service.

You can pass the values...

Where do you see the identity property for a column? I did not see it under sp_columns.

It would help if you presented a representation of your recordset ... what you have... and what you want the final output to look like. As I see it you...

Start by right clicking the detail row and select to add a parent group. In the popup dialogue you select the column to group by and if you want to...

Note that in your dataflow, click the green arrow and see that you can add a data watcher. You'll see the data as it flows from the source and BEFORE...

Very awesome. I'll try it out, Thanks!

Else, I found out the ssis package first import the data into a table that has raw data, meaning no constraints defined, then import from raw table to the real...