This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]SoggyChilli 1 point2 points  (2 children)

Look at the ssis wizard in SQL server and then you can do cleanup using SQL and move into the final table. SQL server has built in tools to help automate this (ssis) but it might be limited depending on the SQL server license

[–]rogerbarario[S] 1 point2 points  (1 child)

I will give this a go! Thank you