I am working with Sql Server 2005. I have been asked to create a new job. In looking at an already existing job properties, I see the Category is one of our packages. I'd like to see the configuration for the package, but have no idea where it is located. I've done a search on the package's name as it is listed on the Job Category, but still cannot find it. How can I find this package? Thanks!

See this walkthrough: How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005 - http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspxArthur My Blog

Don't need to create a new package, need to find one already created.

Is the job calling package using command line? If you can you paste the commad here.

(See screen shot below). I want to find the location of Package so I can take a look at how customer_active_last_six_months is configured and then use that as a model to create another entry in the package. These entries export a tables data into an Excel spreadsheet.

Two approaches: You can simply double click the package on a machine where SSIS is installed - it will attempt to open it with DTExecGUI in which you will be able to see the package configurations settings. Another would be to open it is BIDS and then see the config by clicking the SSIS item from the tool bar menu.Arthur My Blog

I see what you need: Ok, use SSMS to connect to SSIS (not the database engine and see if you can locate the package in the package store). If not in the package store, then just search for file name customers_active_last_six_months.dtsx A package can be in a database (MSDB) or as a file.Arthur My Blog

When I attempt to access SSIS through SSMS the "Authentication" fields are disabled and I cannot enter the system administrator user name and password. I don't have rights with my windows authentication.

There is no mixed authentication for SSIS. what is the error on logon?Happy to help! Thanks. Regards and good Wishes, Deepak. http://deepaksqlmsbusinessintelligence.blogspot.com/

No error. Just trying to locate a package's definition/configuration in SSIS so I can use it to create a similar entry for another step in my Job in SSMS.

Hi Donna, Please try to switch to the administrator and login the server, access SSIS through SSMS, you will find the package in Stored Packages--MSDB--customers_active_last_six_months folder. Thanks, Sharp Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

I am unable to login directly onto the server. However, I resolved the issue in SSMS by using the Import and Export Wizard to create my export file and selecting to Save SSIS Package. Then the package was available when creating a new job step. Thank you!

Please do not look for back-doors. I am afraid to comfortably being able to manage and/or develop SSIS packages you need to be granted the proper access rights to SSIS.Arthur My Blog

Arthur, I understand your position and thank you for your response. I am not looking for back doors but working within the confines of the organization for which I am working. I will work to get proper access rights. Again, thank you!

Hi Donna, Please try to switch to the administrator and login the server, access SSIS through SSMS, you will find the package. Thanks, Sharp Please remember to mark the replies as answers if they help you and unmark them if they provide no help.