Perhaps 'randomly' is not wholly...

This should do it:

string fileDate = "2024-03-31";
 
DateTime someDate = DateTime.ParseExact(fileDate, "yyyy-MM-dd", CultureInfo.InvariantCulture);

• This reply was modified 2 years, 6 months ago by Phil Parkin.

Obviously a hierarchy of some sort. What sort of data do the rows in the table represent?

Did you refresh the Intellisense local cache? CTRL-SHIFT R

Never heard it called Abscess before!

• This reply was modified 2 years, 6 months ago by Phil Parkin.

Please clarify what you mean by this:

incremental time of the transaction day.

What is that, and how does it differ from 'time'?

… Or of...

I would use the following code to get 'last' Sunday. Seems a bit simpler than the current version.

SELECT DATEADD (wk, DATEDIFF (wk, 0, GETDATE ()), 0) -...

• This reply was modified 2 years, 6 months ago by Phil Parkin.
• This reply was modified 2 years, 6 months ago by Phil Parkin.

Duplicated reply!

• This reply was modified 2 years, 6 months ago by Phil Parkin.

Don't know anything about Netsuite, but if there's a REST API, then you can definitely do this in SSIS.

The trickiest part of setting that up will probably configuring the OATH...

thx, just the type of feedback i was looking for.  i've never seen an ssrs report ingest excel.  But i am very familiar with pbi ingesting excel.  do you...

No doubt you've considered this, but wouldn't a more-streamlined process be to ingest the spreadsheet data in SSRS (or in Power BI) and build the dashboard there?

I've just tried this, as I have a package structured like that.

They've certainly made it difficult! I can get to the point in debug mode where I can see a...

If you are prepared to take the time to provide your sample data in consumable format (ie, CREATE TABLE / INSERT ... VALUES), you might get a coded answer.

If it...

<Phil looks away, feigning agreement>

Are you able to post the query itself?