SSIS can do it - you do need to ensure you set the Text Qualifier to Double Quotes

on those items mentioned, dv360_Line_Item_ID, Date and Event look unique - but you would need to check all your data.

normally you would analyze the data by doing group by in...

use a construct like the following

select *
from tablename
cross join (select hashbytes('SHA1', concat(field1
               ...

I say again - you will never remove that warning from your plan unless the underlying type is the same as your destination column

stop wasting time on things that can't...

that individual its a waste of time - even the last comment - how to fix that particular conversion to code - was told how - can't do it obviously...

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 4 years, 4 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...