Viewing 15 posts - 106 through 120 (of 149 total)
---This is a draft that I have yet to work on, but should tell you about the approach...
logging_tbl is the logging table with a flag called bulk_insert_flag
table stricture:
file_key int,
file_location varchar(1000),
file_path...
July 10, 2009 at 12:26 pm
bumping this up... thanks!
July 10, 2009 at 10:41 am
How about failures like file was not found or file format was wrong? Can we log the failure in the logging table and proceed to next one? Thanks for your...
July 10, 2009 at 7:49 am
Use group by and max or min for each field to get unique record for each ID... not exactly sure what the question is though.
June 24, 2009 at 10:18 pm
hey Waynes,
Thanks for your help...this process works great with delimited file with first row as header... How can we deal with fixed width file? They will provide us the fieldnames...
June 15, 2009 at 3:34 pm
Workaround I am thinking would work:
--- we can bulkinsert first record in #temp
--- create table temp using that info
--- bulk insert entire data into temp using delimeter and text qualifier
June 4, 2009 at 10:21 am
I was wondering if varchar(max) can handle more than 2gb of data in a file as the entire file will be loaded in one varchar(max) field? Few files will be...
June 4, 2009 at 9:12 am
Thanks Waynes.... this is great. It will certainly save me loads of my time. I guess I can also manipulate this to work with comma delimeted with quotes as text...
June 3, 2009 at 8:57 pm
Hey Waynes,
Thanks for the response... Let me see how much you can bendbackword for this...
sample of file will be:
id, fname, lname, add1, add2
111, scott, tiger, 123 your way, apt 1
................................................
another...
June 3, 2009 at 6:31 pm
Thanks a lot... we had log in the dts and I was able to run your query for last run and that at least gave me task numbers that...
February 26, 2009 at 4:03 pm
thanks a lot tfoley.... good to know that. Thanks a lot!
December 15, 2008 at 12:11 pm
using cursor is the only option?
November 10, 2008 at 7:51 am
Viewing 15 posts - 106 through 120 (of 149 total)