February 24, 2020 at 2:21 am
I'm really terrible at SSIS, so I figured I would try something simple.
I imported data from a text file using the text connection manager, and it worked just fine. Same with importing from an MDB file - used Jet4.0 and it worked like a champ. When I try to import from Access ACCDB files, it all goes to hell in a handbasket. It's odd, because now the text columns are of type NVARCHAR() in Access(?). If I try to import into a regular VARCHAR(n) column, it fails and I get a conversion error. How do I convert from NVARCHAR to VARCHAR in SSIS? (Am I missing something obvious, or is this just a huge hassle?) What's super odd is that I can push the data from Access and it does the conversion under the covers apparently, because the inserts work. I could mimic SSIS by doing something like this:
Has anyone here gotten SSIS to read from Access ACCDB tables? If so, could I have a hint? It's just baffling.
February 24, 2020 at 3:51 pm
I've not tried importing an accdb before, so can't help with specifics.
But converting NVARCHAR to VARCHAR is straightforward enough – a Data Conversion component is what you need. This will allow you to take an NVARCHAR 'input column' and create a suitably converted 'output column', which can be mapped to your destination column in place of the NVARCHAR version.
February 24, 2020 at 8:06 pm
Oh, okay. I'll try it out. Thanks, Phil!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy