Post reply

SQL 2005 export/import wizard

  • December 29, 2008 at 9:24 am

    #128862

    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

    #918480

    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

    #918930

    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

    #919106

    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

    #919111

    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