Viewing 15 posts - 4,381 through 4,395 (of 13,877 total)
Found out what the problem is.
My PC is hosed. Something (we're not sure what)...
June 6, 2018 at 10:26 am
Use a Conditional SSIS Expression to do this.
June 6, 2018 at 10:23 am
Could the pre-2018 tables be loaded using a backup of the db on a separate server?
June 6, 2018 at 9:12 am
June 6, 2018 at 7:36 am
June 5, 2018 at 1:30 pm
The SQL Server table is not the problem here.
Check the Advanced properties for your Flat File Source component and check the input and output columns.
June 5, 2018 at 12:24 pm
June 5, 2018 at 10:27 am
On my...
June 5, 2018 at 5:30 am
imani_technology - Monday, June 4, 2018 10:36 AMThe problem is, the full file could be partially wrong at times.
You're going to have...
June 4, 2018 at 10:55 am
WebTechie - Monday, June 4, 2018 9:48 AMI tried the IGNORE_DUP_KEY = ON and that failed also.
Try it for yourself:
CREATE...
June 4, 2018 at 10:12 am
June 4, 2018 at 10:08 am
Not exactly considered best practice, but if you don't care which dupe gets dumped,...
June 4, 2018 at 10:02 am
Not exactly considered best practice, but if you don't care which dupe gets dumped, you could consider setting IGNORE_DUP_KEY = ON on your PK to ignore dupes silently (
June 4, 2018 at 9:06 am
Does anyone know or suggest a way to extract column information from the Json...
June 1, 2018 at 12:55 pm
Viewing 15 posts - 4,381 through 4,395 (of 13,877 total)