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

Never heard it called Abscess before!

• This reply was modified 1 year, 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 1 year, 6 months ago by Phil Parkin.
• This reply was modified 1 year, 6 months ago by Phil Parkin.

Duplicated reply!

• This reply was modified 1 year, 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?

I think that you might have to split things up, such that one of the two different versions of the T-SQL is executed, depending on SQL Server version.

If you're not...

Hello everyone,

I hope I'm in the right place here. If not, please let me know where I can post this question.

Here's my question:

With this call dtsRuntime.Package package = app.LoadPackage(Etl_package,...

I meant it merely as a diagnostic tool, not a permanent change. But taking out the dirty reads sounds like a good idea too.