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 2005 Forums
 SSIS and Import/Export (2005)
 Schedule a DTS Package

Author  Topic 

Lainkes
Starting Member

3 Posts

Posted - 2007-05-22 : 04:15:20
Hey,

I created a DTS package on my SQL server (2005).
It copies my data to an excel-file.

How can I run this package every night?

Thanks

Lainkes

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-22 : 10:04:55
Right click on jobs in under sql server agent in ssms and choose new job, go to steps tab and click on new. Choose sql server integration services package as type then finish rest part.
Go to Top of Page
   

- Advertisement -