I have created an SSIS export package by right-clicking on a database, choosing 'Export Data', specifying all settings using the wizard, and choosing to Save the SSIS Package, with the SQL Server option checked.
I now want to run the package, and schedule it to run on a regular (daily) basis. The problem I am having is that I can't find the SSIS Package anywhere! I have looked in Microsoft SQL Management Studio, at virtually every element in the tree, and I don't see 'SSIS packages' anywhere. How do I run this package again Is it only available through a stored proc, or via the DTEXEC command Also, how do I modify it, other than going all the way through the wizard and overwriting it
I am using SQL Server 2005. Thanks in advance!
Modify SSIS Package
Hot Topic
- problem with non additiv measures
- In 2005, finding users who have context in a database?
- ASPNETDB Connection Problems - Please Please Help!
- Package Migration Wizard error -- Index was out of range
- "product level is insufficient" message during flat file import
- Error in SQL Server Management Studio Express when Attach DB
- Problem to view OLAP data on web
- Set initial sort direction using Interactive sort.
- Solve order
- SQL Server Express Licensing
SQL Server
- Temporary tables
- deploy to another server
- Can't install SSIS on an XP machine
- I can not enter non english text in SQL express...
- is it possible to pass a report table column in sql reporting serivces
- How to show KPIS on a webpage?=
- Cannot open database
- SQL Server 2005
- Merge Replication IIS Worker Process Error
- Update conflict
Modify SSIS Package
JonathanTew
I must say, when I first learned SQL Server 2000, I hated the fact that there were two interfaces, Query Analyzer and EM. But I got used to it. Now that MS has made it into one app, again I feel lost.
Thanks for the info.
bubberz
That's great, it helped me too, but now, how do you edit the package through Management Studio
Thanks
Jim
gebhartj
To view packages in Management Studio you need to connect to the Integration Services Server in Object Explorer. This is different to SQL Server.
I think Microsoft have made a bit of a boo boo in asking the user if they want to save to SQL Server - it should be "Save to Integration Services Server".
-Jamie