We help IT Professionals succeed at work.

SSIS Package Execution on SQL Server

indy500fan
indy500fan asked
on
Medium Priority
587 Views
Last Modified: 2010-07-27
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
Comment
Watch Question

run dtexec /sq pkgOne /ser productionServer
thru dos prompt


Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Ah, okay, I was trying to run it from a Qry.

Author

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

Author

Commented:
I was waiting to award points after the second part of my question was answered, but...
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

Author

Commented:
Do you know what directory they will be in.

Author

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?
lemme check
tell me the steps u carried out..

Author

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

....


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...

Author

Commented:
Interesting....I'll try it via the file system method...
try under
Management >> Maintainence Plans..

Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.