Import and Export Data Package

Question

Import and Export Data Package

Dave62

SSCertifiable

Points: 7459
More actions
March 16, 2018 at 1:23 pm

#336574

I created a package (AccessData) using the SQL Server 2014 Import and Export Data (32-bit) tool. I can see the AccessData package with the SQL Server 2014 Execute Package Utility. I have not tried to execute it yet.
I went into SSMS to try to find and delete the package but am unable to locate it.
Is there a way to see and/or delete the package with T-SQL?
Thanks
Dave

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

Dave62 - Friday, March 16, 2018 1:23 PM
I created a package (AccessData) using the SQL Server 2014 Import and Export Data (32-bit) tool. I can see the AccessData package with the SQL Server 2014 Execute Package Utility. I have not tried to execute it yet.
I went into SSMS to try to find and delete the package but am unable to locate it.
Is there a way to see and/or delete the package with T-SQL?
Thanks
Dave

You should be able to connect Object Explorer to Integration Services in SSMS - you need to use the SQL Server 2014 version of SSMS and you need to do Run As Administrator when opening SSMS. When connected, under Stored Packages there are two folders - File System and MSDB. You should be able to find it in one of those. Right click and delete.

Sue

Dave62 SSCertifiable Points: 7459 More actions · Answer 2

Sue_H - Monday, March 19, 2018 11:23 AM
You should be able to connect Object Explorer to Integration Services in SSMS - you need to use the SQL Server 2014 version of SSMS and you need to do Run As Administrator when opening SSMS. When connected, under Stored Packages there are two folders - File System and MSDB. You should be able to find it in one of those. Right click and delete.
Sue

Thanks for your reply. I'm not able to use the Object Explorer because we do not have the SSIS service running on our server. The import/export utility and the execute utility both seem to work without the service running. So I was just looking for a T-SQL way to view and/or delete the package created by the utility.

I did find what I was looking for in the msdb database. The dbo.sysssispackages table has 1 record with all the information for the package that was created. I can view and/or delete that record.

Dave