December 29, 2008 at 9:24 am
Using Export/Import wizard..i have created package in save in sql server 2005 itself and not as ' dtsx ' package.
how to execute it?
December 29, 2008 at 10:45 am
In Management Studio, connect to Integration Services, expand stored packages, expand MSDB, right-click the package and select "Run Package". You can also create a SQL Agent job and run the package in a job step.
Greg
December 30, 2008 at 4:58 am
Thank you:) Is it possible to run through the query.. because i need to run it often say once a week from front end...
December 30, 2008 at 9:23 am
You can run it using sp_cmdexec and dtexec or you can put it in an unscheduled job and just run the job when you want.
See this article from BOL: http://msdn.microsoft.com/en-us/library/ms141708(SQL.90).aspx for various options for running packages.
Greg
December 30, 2008 at 9:28 am
I am new to this...i will check and let u know.
..thanks a lot...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply