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 2008 Forums
 SSIS and Import/Export (2008)
 Package Saving

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2010-02-18 : 04:29:31

When using the simple import tool from Excel / Flat File into SQL Server, and choosing to save the package automatically generated, this has in the past saved it in MSDB as a job I can then edit / improve / expand on.... Recently, the usual import process doesn't create the job at all. Is there a different option I need to set?. Always checking the 'save SSIS package' box, running it now, or not.... Does it save anywhere other that MSDB? It's not my database. Could it be a permissions problem? No warning to say it can't save it...

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-18 : 04:34:33
it can be saved in SQL server itself which is when you can find it in MSDB. Alternatively you could save it in a local filesystem of your machine
see

http://msdn.microsoft.com/en-us/library/ms186943.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

mikebird
Aged Yak Warrior

529 Posts

Posted - 2010-03-01 : 05:24:29
Problem was that I didn't have access to that with no SS service instance on my machine - just the interface software
Go to Top of Page
   

- Advertisement -