|I discovered that I couldnt be granted BULKADMIN or SYSADMIN role on my hosted sql server db and trying to bypass the bulk insert operation by creating a .sql file containing insert statements. The insert statements are created using a xls macro, so theres some bit of manual bodyshopping work that I am doing now. So let me draw the problem here.|
I have a text file with the following contents -
10/05/2011 01:21 PM 1-16332-1008261.psa
10/05/2011 01:21 PM 1-16332-1011698.psa
10/05/2011 01:21 PM 1-16332-1023151.psa
10/05/2011 01:21 PM 1-16332-1035695.psa
10/07/2011 03:36 PM 1-16332-1023193.psa
10/07/2011 03:36 PM 1-16332-1035694.psa
6 File(s) 8,933,754
2 Dir(s) 1,675,268,096 free
What I want to achieve in my final output file is this -
insert into xyz.abcd values('10/05/2011', '1-16332-1008261.psa');
insert into xyz.abcd values('10/05/2011', '1-16332-1011698.psa');
insert into xyz.abcd values('10/05/2011', '1-16332-1023151.psa');
insert into xyz.abcd values('10/05/2011', '1-16332-1035695.psa');
insert into xyz.abcd values('10/07/2011', '1-16332-1023193.psa');
insert into xyz.abcd values('10/07/2011', '1-16332-1035694.psa');
Note that the last two lines from my input text file are dinged in my final output sql file. Its kind of automating the xls macro I am manually doing now by dos scripting where the 'insert into xyz.abcd values' is considered to be a constant string which is written to each new line before the actual date and filename from the file been read.
I will name my final output file as a .sql and execute it remotely from my computer.
Can somebody please help me if this can be doable in DOS programming or not.