I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows. I don't have a delimiter.
csv file: (First row is blank)
when I used the below command:
BULK INSERT tablename FROM 'c:table.csv'
WITH (firstrow = 1 ,ROWTERMINATOR = '/n' )
when I select the table, the o/p is not correct
I need to insert rows in to individual rows like
Please let me know how to do this.
Once, i copy the data in to the table, i need to rename the file adding the time to the csv.
Please let me know how to write the Xp_cmdshell rename.
Thanks for any help
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!