Ken - that's exactly what I was trying to do - thank you very much.

Here you go. So I want to go through all the dates and figure out how many other dates happened within a set timeframe - 3 minutes - for...

Sorry for the question - It appears that a file can be moved between remote directories using the Rename action in the CozyRoc component.

Drew,

Excellent solution. I highly appreciate your help.

Travis

Sorry for the vagueness and I appreciate your help. There is no criteria for how the Code is assigned to a name as long as it doesn't repeat.

In sequence...

I'd recommend looking into finding a good beginner's book on ADO.NET as well. It focuses on data access and data services. A lot of the script coding focuses...

Would recommend using an environment variable in your package configurations as well if you plan to transport packages between servers. Prod to Dev and Dev to Prod for example.

Thank you so much! I modified your code a bit to get what I needed:

SELECT

X.x.value('../../@viewName','varchar(50)') AS result1,

X.x.value('@subItemType','varchar(50)') AS result2

FROM KSession a CROSS APPLY

[SData].nodes('/views/view/viewEvents/viewEvent') as X(x)

What would be...

You can build a cube with your metric being the count of students. Might be able to even get away with 1 as StudentCount as a column in your...

My approach would be to have 3 dimensions and a fact table.

Dimensions: DimStudent, DimDate, and DimSubject.

This would allow you to provide data/reports by student, by date, and...

Did you configure the error output to redirect the row? The default is to fail the component.

Sounds like the error is occuring before runtime. Which means that the package hasn't read your source so therefore can't write anything that errors.

Post the error message...

I don't see how creating a dimension for each separate schema would be more difficult on the developer. In fact, if designed and developed correctly, it is something that...

My apologies, I replied to the wrong thread 🙁 You need to give us more specifics. What is happening when you are running your package? Are rows...

Is 64 bit Oracle provider installed?