question

gaurav_suri avatar image
gaurav_suri asked

directly or indirect insertion in table

i have a powwershell script which saves output in csv format. now i have two options- either to import from csv file to sqlserver table or without creating a csv file, insert into table by sql command by making sql connection. which choice is better keeping security issue ? ps. space issue seems to be in favour of later option
powershellbulk-insert
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
From a security stand point, just moving the data over without storing it in an interim step would be the better approach.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.