User Profile

Collapse

Profile Sidebar

Collapse
Ganesh Kumar
Ganesh Kumar
Last Activity: Nov 2 '07, 06:03 AM
Joined: Nov 1 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Ganesh Kumar
    replied to Executing SQL Package
    in SQL Server
    Hi

    Thanks for your response.

    When I create package from Business intelligence wizard, It was created as Package1.dtsx. Now , How can I invoke package1.dtsx from query analyzer?.

    As far as I know, In oracle, a package will contain main and a body procedures. We can invoke the main procedure from any command prompt. But I am new to SQL packages. Can you suggest me in this regard.

    Thanks,...
    See more | Go to post

      Leave a comment:

    • Ganesh Kumar
      started a topic Executing SQL Package
      in SQL Server

      Executing SQL Package

      Hi

      I have created a DTS package in SQL 2005 which will pull the data from oracle and pushes into SQLServer. I am able to execute the package from business intelligence wizard.

      Is there anyway to trigger this package manually apart from the wizard?.

      looking for responses.


      Thanks
      Ganesh
      See more | Go to post
      No activity results to display
      Show More
      Working...