December 9, 2013 at 2:47 pm
I often have to import data from a CSV file into SIS. I have been doing this manually, using the Import and Export Wizard. I would like to save the import package, instead of having to go through the wizard every time. However, whenever I try to save the package using the wizard, I get the following error:
TITLE: SQL Server Import and Export Wizard
------------------------------
Save to SQL Server failed.
The SaveToSQLServer method has encountered OLE DB error code 0x80040E14 (Access to Integration Services package 'ImportNames' is denied.). The SQL statement that was issued has failed.
------------------------------
ADDITIONAL INFORMATION:
The SaveToSQLServer method has encountered OLE DB error code 0x80040E14 (Access to Integration Services package 'ImportNames' is denied.). The SQL statement that was issued has failed.
------------------------------
BUTTONS:
OK
------------------------------
I have tried both Windows authentication with an admin account, and SQL Server authentication with an admin account, and I get the same error both ways.
Any ideas as to what I need to do to make this work?
Thanks.
December 9, 2013 at 4:28 pm
mattward (12/9/2013)
TITLE: SQL Server Import and Export Wizard
------------------------------
Save to SQL Server failed.
The SaveToSQLServer method has encountered OLE DB error code 0x80040E14 (Access to Integration Services package 'ImportNames' is denied.). The SQL statement that was issued has failed.
On the page that allows you to save the package, you probably have the radio button set to save the package to 'SQL Server' instead of 'File System'. The page that follows will allow you to provide a location where the file should be saved.
December 11, 2013 at 5:22 pm
That was the problem. Thank you, kl25.
December 12, 2013 at 7:39 am
Glad you got it to work. 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply