I also noticed though, if I set the Error Output to ignore truncation errors, I can process the original file as well, but it only imports the first 255 characters,...

Thank you again for the response, but unfortunately, setting the "DelayValidation" to True didn't help either.

When I go into Advanced Editor - Input and Output Columns for my Excel Source,...

As far as I could tell, I didn't see or notice any bad characters in the records that wouldn't import.  I also have the columns set to NVARCHAR(4000) just to...

• This reply was modified 3 years, 6 months ago by  AMCiti.
• This reply was modified 3 years, 6 months ago by  AMCiti.

I appreciate the response, but unfortunately, this didn't work.  The first file, with the "dummy" data loaded great.  I then changed the setting on the Excel Source step to "False"...

Mr. Gail:

I appreciate the response and not trying to be rude, but unfortunately I am not sure this helps.  I am not trying to export to an Excel file, but...

First:  thank you for the response.  To answer your questions:

When I say "the server has access to the path", it is a UNC path that I cannot access from my...

I tried it with the "Parentheses", but didn't have the "AS any_name" portion.  Greatly appreciate the help 🙂

Jeff:

My apologies.  I noticed that previously and attempted to use it, but it gives me an error about "Incorrect syntax near 'FIELDQUOTE'". As such, I do not believe our version...

My apologies.  I corrected the original question to say "double quotes".  Not sure why I did that, but definitely added to some confusion.  As to the second, unfortunately using field...

The format I had been using in Excel is:  Format Cells --> Custom --> m/d/yyyy h:mm:ss

Excel technically only lists the custom format as:  m/d/yyyy h:mm and I add the extra...

Thank you for the response but unfortunately, we are locked into this file type as it is directed from above this is how all files are created as it is...

I understand what you are saying.  I appreciate the help and information you gave 🙂

Unfortunately it does not exist in Table A 🙁

My apologies, but unfortunately, I am going to need more details.  Below is my stored procedure (at least the select portion causing this issue)

SELECT              
     [Site],             ...

The easy answer is that I didn't understand them to be the same and/or related.