Viewing 15 posts - 1 through 15 (of 13,680 total)
If you read the help for sp_ExecuteSQL, you can see that this point is explicitly mentioned:
sp_executesql has the same behavior as EXECUTE regarding batches, the scope of names, and database context. The...
December 24, 2024 at 12:38 am
Great master, thank you very much :).
I have been dealing with it a long time. You did it in a very short time. Impressive
Thank you. While I may have...
December 21, 2024 at 7:13 am
That all makes sense! Thanks for explaining and well done on solving it.
December 21, 2024 at 7:10 am
That is not a query … it looks more like a proc. definition.
Does it time-out from within SSMS, or is this called from somewhere else?
December 21, 2024 at 7:08 am
Sure. This method creates a temp table containing the desired results & then modifies the main table via a DELETE followed by an INSERT.
If there are millions of rows in...
December 21, 2024 at 5:12 am
You have set things up using the legacy method of deployment. Have you done this deliberately? If not, please consider deploying your packages to SSISDB and configuring parameters using SSISDB...
December 21, 2024 at 4:42 am
This gives you close to what you have asked for (but using a temp table, for convenience):
DROP TABLE IF EXISTS #Priority;
CREATE TABLE #Priority (Airplane NVARCHAR(50) NULL,...
December 21, 2024 at 4:34 am
Running out, I'm afraid. I haven't used packages deployed to the file system for years. I would guess that there's something going on with .NET versions, but the errors you...
December 19, 2024 at 9:15 am
OK, got it!
My next suggestion would be to create a simple script task that does nothing external, eg
int z = 1;
and delete the script component and then try running it...
December 19, 2024 at 2:02 am
December 18, 2024 at 11:42 am
For the current day, what data changes are being made? Inserts, updates, deletes or all three?
December 18, 2024 at 3:37 am
Not that it helps you particularly, but the error message indicates that it is a script task which failed, not a script component, which is a different thing.
I would suggest...
December 18, 2024 at 3:33 am
That explains it. Copy of an old post with spam link added, perhaps. Thanks!
December 12, 2024 at 5:09 pm
I have query which is filling TEMPDB
I need suggestion how to modify this query to which can minimize the TEMPDB space to fill
update #TempShow1 set Name = case when...
December 11, 2024 at 5:57 pm
I copied the above sql ( as it is )....in a ssis variable and called it from execute sql task....it is still not working 🙁
You misunderstood my suggestion.
Create an...
December 3, 2024 at 4:07 pm
Viewing 15 posts - 1 through 15 (of 13,680 total)