jkeri
#1
I am new to MSSQl, and here is what I need help with. I ned to do all the following form a BAT file.
1- connect to a database
2-load a datase table from a XLS file
3- run a stored procedure to populate a table
4- download the table into a CVS file onto a server in a specific directory.
Any help would be appreciated. Thanks in advance
yosiasz
#2
Welcome jkeri
So why do you want to load xls and export as csv and involve sql server with it? You can do this via script like powershell
jkeri
#3
I do not have those tools here. I am limited to SQL seRVER FUNCTIONALITY
Do you have access to SSIS (SQL Server Integration Services)? Everything you describe can be done with SSIS.