you are never going to go past that error - you are converting from a nvarchar(255) to an int - to avoid the issue you will need to change the...

you likely also should change the BatchSize - 10k is normally way short of the best value - and optimal value also depends if your destination table is a HEAP,...

the thread above is one you created before with the particular csv file for treasury - I gave you a functional powershell example to download it for their site and...

did you try the script I posted on your previous post ?

https://www.sqlservercentral.com/forums/topic/get-data-from-internet-directly-into-sql-server#post-3969507

this new plan does is not using the same query as the original actual plan you supplied - neither do the tables seem to be the same (record count is...

on top of what Sergiy said do have a look at the indexes as well - some can likely be removed as follows - and this will remove one of...

• This reply was modified 3 years, 8 months ago by frederico_fonseca.

it was me - had already clicked button when I noticed mistake - did send the OP a message apologizing.

and yes it was pressure due to the spam abuse over...

and.... SA user should not be enabled at all!!!

and should not be used by ANY application either.

been cleaning/blocking users as fast as I see them - but site managers should look at automatic rules as all those I did over last 3 days would be easy...

one of those I refuse to help now - ignores suggestions and fails to supply requested information and just wishes for...

I would look at PowerBI and Excel. You can use stored procedures and views as data sources if you want. What kinds of graphs etc did you want...

if I got it correct the following likely to perform better - do look at the comment inside it - and as with everything test test and test again.

            
February 15, 2022 at 12:31 am
            
#3983632

            
            
                                                
        

on top of using a non supported configuration - and potentially some licensing issues on that also (Office is not licensed to run on a server).

but that aside move that...

you can't - dynamic sql required to do it and its not possible on user functions - see https://docs.microsoft.com/en-us/sql/relational-databases/user-defined-functions/create-user-defined-functions-database-engine?redirectedfrom=MSDN&view=sql-server-ver15

and even if you could it likely would not be advisable at...

he/you can extract all packages to an .ispac, extract the .dtsx files from this (its just a .zip file) and then search/parse the packages for it. - that will give...