dbTalk Databases Forums  

SSIS Pkgs

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS Pkgs in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ferg
 
Posts: n/a

Default SSIS Pkgs - 09-13-2006 , 04:01 PM






I am new to 2005 and am in the process of moving a developers pkg to
the server and scheduling it. I got it moved and scheduled the pkg but
it did not execute. Where do I go to see the pkg and execute myself vs
the scheduler


Reply With Quote
  #2  
Old   
Charles Kangai
 
Posts: n/a

Default RE: SSIS Pkgs - 09-27-2006 , 10:44 AM






Go to SQL Server Management Studio but do not connect to the Database Engine
on connection. In the Connect to Server drop-down, be sure to choose
Integration Services. The default is likely to be Database Engine, the one
you last connected to.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk


"Ferg" wrote:

Quote:
I am new to 2005 and am in the process of moving a developers pkg to
the server and scheduling it. I got it moved and scheduled the pkg but
it did not execute. Where do I go to see the pkg and execute myself vs
the scheduler



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.