Can anyone suggest tools which can upload a variety of files (csv, xls, etc.) to SQL Server?
I can create similar tools in .net but want to save开发者_如何学运维 time on it and would rather buy a tool which can validate the file for the correct data types, required columns, etc.
Why don't you look into SSIS: http://msdn.microsoft.com/en-us/library/ms141026.aspx It seems to be the standard etl tool in sql server environments.
精彩评论