Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem Saving SIS Import Package Using Import and Export Wizard Expand / Collapse
Author
Message
Posted Monday, December 09, 2013 2:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 11:39 AM
Points: 3, Visits: 42
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.
Post #1521312
Posted Monday, December 09, 2013 4:28 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 467, Visits: 1,694
mattward (12/9/2013)
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:

[quote]
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.
Post #1521350
Posted Wednesday, December 11, 2013 5:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 11:39 AM
Points: 3, Visits: 42
That was the problem. Thank you, kl25.
Post #1522105
Posted Thursday, December 12, 2013 7:39 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 467, Visits: 1,694
Glad you got it to work.
Post #1522316
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse