Viewing 15 posts - 31 through 45 (of 51 total)
can you post the table DDL (including indexes/PK) and explain the process of inserting and updating this table BEFORE you try to do the update above.
what you say above...
October 18, 2022 at 11:54 am
Is this just a one-off, or are you designing a process which needs to run regularly and automatically?
Yes ultimately this will run on daily basis and automatically, but first...
October 3, 2022 at 10:41 am
Referring to staging tables as temporary tables is confusing!
For each of the staging tables, create a stored procedure. This stored proc should take care of 'changing the things you...
September 22, 2022 at 10:15 am
Are you inserting from the temporary tables to the same 'permanent' table in each case? Or are there different targets?
100,000,0 is not a number – please clarify.
I'd suggest doing...
September 22, 2022 at 9:25 am
A combination of DATEDIFF() and LAG() will get this done for you. If you are prepared to produce your sample data in consumable format (ie, in the form of...
September 15, 2022 at 7:10 am
Just do a BULK INSERT to import the XML file as a BLOB and parse it with the normal XML tools.
Doesnt work if XML files size is too big,...
August 30, 2022 at 4:37 am
Ok and what about Python? I heard somewhere that it can also be used as an alternative of SSIS tasks?
Yes it can... so can C#, Visual Basic, PowerShell,...
August 29, 2022 at 6:43 am
Ok and what about Python? I heard somewhere that it can also be used as an alternative of SSIS tasks?
August 29, 2022 at 4:40 am
I guess what is the best way depends on your background and your personality. I picked up C# by reading a book "Inside Visual C#", which is likely to...
August 23, 2022 at 9:48 am
They are the same language. 🙂 Just different syntax.
Joke aside, the main challenge is not learning the language as such, but .NET and .NET Framework, and that is the...
August 23, 2022 at 9:32 am
You asked how to use WinSCP in SSIS - the assumption would be that you are currently using WinSCP manually to synchronize the folders. Is that correct?
My next question...
August 12, 2022 at 8:56 am
Best practice is to archive unzipped files after processing them. Just move them to an Archive folder. That way, you know that anything in your updates folder has not...
August 5, 2022 at 7:31 am
Couldn't you just use NTILE() to split the file into a given number of pieces?
DECLARE @Tiles INT;
SELECT @Tiles = CEILING(COUNT(*)/10000)
FROM dbo.CovidData;
SELECT
bucketNo = NTILE(@Tiles) OVER (ORDER...
July 4, 2022 at 10:53 am
This question is strikingly similar to this one.
Perhaps the responses you received there were not to your liking? You did not even have the courtesy to respond to...
June 30, 2022 at 11:59 am
Viewing 15 posts - 31 through 45 (of 51 total)