Viewing 15 posts - 1 through 15 (of 13,390 total)
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) -...
April 15, 2024 at 9:56 am
Duplicated reply!
April 15, 2024 at 9:54 am
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...
April 12, 2024 at 1:22 pm
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...
April 12, 2024 at 1:03 pm
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?
April 12, 2024 at 11:30 am
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...
April 11, 2024 at 4:53 pm
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...
April 11, 2024 at 8:27 am
... and no-one gets excited by a fridge.
<Phil looks away, feigning agreement>
April 10, 2024 at 11:10 am
Are you able to post the query itself?
April 9, 2024 at 12:45 pm
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...
April 9, 2024 at 8:19 am
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,...
April 9, 2024 at 8:14 am
I meant it merely as a diagnostic tool, not a permanent change. But taking out the dirty reads sounds like a good idea too.
April 8, 2024 at 4:53 pm
Are you using a third-party library to convert PDF to Excel? If not, how are you doing it?
April 8, 2024 at 10:47 am
Have you considered redirecting error rows to an error table, rather than simply failing the package? This could help you track down what's happening.
April 8, 2024 at 7:48 am
Thanks allot for reply @Phil , Yes its same,
Also I suspect this might be due to expired license for Kingsway Soft. I raised this concern with management.
Sounds like you've...
April 8, 2024 at 7:45 am
Viewing 15 posts - 1 through 15 (of 13,390 total)