April 12, 2016 at 12:35 pm
I was using the Data Import task to do a one-time import of an Excel file. The import refused to function because a date column was formatted as a text column. I tried to change this in Excel, but the task editor had the file locked. So I saved the package with all of the mappings in it. I chose to save it in SQL Server (I figured I could find it in SSMS). After formatting the column in Excel, I then tried to find the package. I can't find it.
The Integration Services Catalogs folder in SSMS is empty. Is that where it would be? I also tried to connect to Integration Services on my machine (the server in question is a local SQL Server 2014 Developer Edition). I cannot connect and receive a long error message about administrative permissions. I have also tried to run SSMS as an administrator. That just leaves UAC repeatedly telling me "requires elevated permissions." Apparently I don't have those on my local machine.
Calling the company help desk is going to be pointless.
So where did my package get saved? Surely it's on disk somewhere that I can find? Or is it locked under administrative permissions? (Which raises the question: why can I save a package to SQL Server that I can't get back out?)
April 12, 2016 at 12:40 pm
I was able to find the package in Execute Package Utility.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply