So i got my first working SSIS package made and

Yahoo Archive
1
Some options:

1. psexec (via sysinternals)

e.g. psexec \\targetComputer -c dtexec.exe <package>

2. Programmatically (VB.NET or C#) via Sql Server Agent:

http://msdn.microsoft.com/en-us/library/ms403355(SQL.90).aspx

3. With a Web Service wrapper and lots of options:

http://pedrocgd.blogspot.com/2008/02/ssis-execute-package-from-aspnet-page.html

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of rob.bucek
Sent: Friday, March 27, 2009 3:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] so i got my first working SSIS package made and...

How do I get an end user tool out there. The individual prepares his flat file and then goes into sql manager and..thats the sound of madness! I read something about possibly launching packages remotely through a web service. I dont have any experience creating web services and have only ever done a couple console applications (something else I read in conjunction with this solution). How does everyone out there handle that? Or is this something that should always remain in the hands of a DB administrator?



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
How do I get an end user tool out there. The individual prepares his flat file and then goes into sql manager and..thats the sound of madness! I read something about possibly launching packages remotely through a web service. I dont have any experience creating web services and have only ever done a couple console applications (something else I read in conjunction with this solution). How does everyone out there handle that? Or is this something that should always remain in the hands of a DB administrator?