SQL Job as SSIS Package - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

SQL Server Administration (2012)

SQL Job as SSIS Package

Author

Topic

ksr39
Posting Yak Master

193 Posts

Posted - 2014-12-10 : 13:47:41

Hi Experts,

I need a small help, I have created a job and saved it as a SSIS package to run at scheduled time every day. I have saved the package in the SQL Server. Now I want to modify the package where should I check, I am not able to find the package in the server.
Please help me in this regards.

Thank you

Thank You All In Advance
KRS39

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-10 : 13:50:06

In Management Studio, select "Connect" in the Object Explorer and then select "Integration Services". Connect to your server. You should be able to find the package now and even export it so that you can modify it.

But please do start saving your packages in source control!

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

ksr39
Posting Yak Master

193 Posts

Posted - 2014-12-10 : 14:05:45

Thank you Tara,
There is no Integration Service on my server. There is no SSIS server in the environment.

Thank You All In Advance
KRS39

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-10 : 14:10:04

I am confused then. Are you referring to a maintenance plan?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

ksr39
Posting Yak Master

193 Posts

Posted - 2014-12-10 : 14:21:06

I have created a job manually not with MP. I have saved that job as SSIS package so that it can run as per the scheduled time.

Thank You All In Advance
KRS39

ksr39
Posting Yak Master

193 Posts

Posted - 2014-12-10 : 14:31:57

I have a query which fetches the data from few tables, I used the export wizard on the database and used this query to get the required results, I am saving the results in a text file and saving the job so that I can use it again and again.
Now I am creating a job manually taking this package to get executed.
Now I want to modify that package I could not see that in the server. But when I try to create a new package again it says the package is already exist and showing the package, but not the path.

Sorry if I confused or misguided any one.

Thank You All In Advance
SRK39

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-10 : 14:44:51

It should be stored in Integration Services. Even Maintenance Plans are stored in there.

What do you see in the Connect menu in Object Explorer?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

ksr39
Posting Yak Master

193 Posts

Posted - 2014-12-10 : 16:47:10

Only Database Engine

Thank You All In Advance
SRK39

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-10 : 16:56:11

I think you need to install SSDT on the client machine. I am not positive though.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

sz1
Aged Yak Warrior

555 Posts

Posted - 2014-12-24 : 06:04:10

I have loads of SSIS jobs running from the SQL agent using SSIS package from a deployed project using BIDS. You then deploy projects to the server under the SSISDB folder under Integration Services Catalogs, then you can create scheduled jon via SQL Agent after you have created a credential for the permissions. What do you mean manual package?

We are the creators of our own reality!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources