Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to run DTS packages in Management Studio? Expand / Collapse
Author
Message
Posted Tuesday, April 28, 2009 2:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 3, 2014 5:46 AM
Points: 114, Visits: 404
Hi All,

I need to run my DTS packages in Mangement studio. Actually, I was able to get the packages loaded under Mangement -> Legacy -> Data Transformation Services (I did this by right clicking on Data Transformation Services and chose "Import Package File..."). How ever, I could not see any option to run the package when I right click on the package. Could any one help me to find the run option?

Thanks in advance,
Suresh


Regards,
Suresh Arumugam
Post #705570
Posted Tuesday, April 28, 2009 9:31 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:01 AM
Points: 4,064, Visits: 5,364
You have to open the package and execute it withing DTS Designer. Alternatively, you can create a SQL Agent job with DTSRun in a job step.

Greg
Post #705982
Posted Tuesday, April 28, 2009 9:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 3, 2014 5:46 AM
Points: 114, Visits: 404
Thanks Greg. I have installed DTS designer and executed the package.

Regards,
Suresh Arumugam
Post #706008
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse