RE: basic SSIS 2016 import fails - ACE OLEDB driver errors

SSC Guru

Points: 246712

April 24, 2017 at 1:54 pm

#1939643

pietlinden - Monday, April 24, 2017 1:33 PM
Just to make sure I wasn't doing something really stupid, I ran the Import wizard from SSMS, and tried to import the same data saved as a Text file. The Wizard goes through the first few steps and then I get "Connection String cannot be initialized" error. I was digging around and one article said to set "Allow Remote Connections = True", which was set already. <scratching my head>
Any thoughts about what else I could be missing?

That error doesn't exactly give the game away. Have you considered installing SSDT and developing a 'grown up' SSIS package? It's much more fun than using the wizard & you'll learn more in the process. The errors which you get will be more verbose and informative too.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.