[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 562
  • Last Modified:

SSIS Package Execution on SQL Server

Friends,

This is going to sound really silly, but how do I execute a SSIS Package stored on the sql server?

I looked in the help and found this:

dtexec /sq pkgOne /ser productionServer

However, when I run this, I get "Could not find stored procedure 'dtexec'."

Do I need to install something, or is there something I'm missing?

Also, I created the SSIS package, but where is it hiding in the Microsoft SQL Server Management Console?

Thanks in advance!

Best Regards,
Eric
0
indy500fan
Asked:
indy500fan
  • 7
  • 6
1 Solution
 
pai_prasadCommented:
run dtexec /sq pkgOne /ser productionServer
thru dos prompt


0
 
indy500fanAuthor Commented:
Ah, okay, I was trying to run it from a Qry.
0
 
indy500fanAuthor Commented:
Excellent, that does work running it from the command line.  Seems like a backwards way of doing it, and I would have thought that you could have run it from a qry window as a sql command, but...okay.  

Now, about the second part of my question, where is the SSIS package hiding in the Microsoft SQL Server Management Console?

Thanks,

Eric
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
indy500fanAuthor Commented:
I was waiting to award points after the second part of my question was answered, but...
0
 
pai_prasadCommented:
SSIS packages are .dtsx files...
i dont think they wud show up in the console..
u wud have 2 look up in the windows dir
0
 
indy500fanAuthor Commented:
Do you know what directory they will be in.
0
 
indy500fanAuthor Commented:
When prompted to save them in either the File System or SQL Server, I choose SQL Server.  Will they still be in a windows directory?
0
 
pai_prasadCommented:
lemme check
0
 
pai_prasadCommented:
tell me the steps u carried out..
0
 
indy500fanAuthor Commented:
From Server Management Studio:

1.  Right-click on the database that the data is being transferred from, choose Export Data

2.  Choose the data-source

3.  Choose the data-destination

4.  Choose: "Copy one or more tables or views"

5.  Check the table that I want to transfer

6.  Uncheck "Execute Immediately"

7.  Check "Save SSIS Package"

8.  Chose SQL Server

....


0
 
pai_prasadCommented:
this is irritating..
i keep getting the error
"No description Found"  when i execute the above steps!!!!
but if i select File System it works...
0
 
indy500fanAuthor Commented:
Interesting....I'll try it via the file system method...
0
 
pai_prasadCommented:
try under
Management >> Maintainence Plans..

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now