I am using the wizard in SQL Server to import csv files to a table.
I want to save the import steps to make the import of multiple files quicker.
I saw that you can click on the SSIS checkbox in the last step
How do I use this to import further files?
It will save the file as a package and then you can create a SQL Server job to run the package.
When creating the job step chose "SQL Server Integration Services Package" for the type and "File System"
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…