Viewing 15 posts - 601 through 615 (of 623 total)
How would the script handle invalid data in a datetime field. It's not null or empty, but contains something other than a date
thanks
July 18, 2018 at 7:45 pm
Sorry didn't see all your post.
July 10, 2018 at 1:33 pm
What would have to change in script if Staging table was altered so the char fields defaulted to hold a larger value. Will the $EmptyValueIsNull(which is needed) still be slow?
July 10, 2018 at 1:31 pm
When using $TruncateLongValues -or $EmptyValueIsNull the process slows way down. I have a 168 row csv and loads perfectly, but
is there anything that could speed up the process?
July 10, 2018 at 10:47 am
I created a view so my csv matches my sql schema(staging table). I used these switches
-TruncateLongValues -EmptyValueIsNull
Message from script I got this for all rows
July 9, 2018 at 7:34 pm
Awesome!!!
Will run some test cases.
Thanks again.
July 9, 2018 at 5:45 pm
How would script handle:
What about input files where the absence of a value...
July 9, 2018 at 11:59 am
I was testing If I use the switch TruncateLongValues it gets this error.
ForEach-Object : Cannot index into a null array.
July 9, 2018 at 11:28 am
If not to much trouble could you post the entire script adding in the piece for Headers I tried to add in the extra code, but maybe a copy paste...
July 9, 2018 at 9:16 am
Does the order of the csv have to match sql schema and what about if schema has 8 fields and csv has 4 fields.
Many thanks again!!!
July 6, 2018 at 12:04 pm
many thanks!!!
From this reply
"The actual column names in the datatable are now determined from the table schema so it doesn't matter what the headers are in...
July 6, 2018 at 6:13 am
agreed.. Staging table is the preferred method before loading live(Prod) table.
What the best solution for files with "No Headers"?
Thanks again for the script and...
July 6, 2018 at 3:33 am
Is there a way to force a value(N/A) to a SQL field defined for NOT Null if the csv field is empty?
error
does not allow DBNull.Value.
July 5, 2018 at 7:46 pm
very cool.. I'll run some test and report back results
Thanks again.
July 5, 2018 at 7:25 pm
Viewing 15 posts - 601 through 615 (of 623 total)