sql server dts: importing data from ssis with exe file -- sql server dts

importing data from ssis with exe file

Bob Yang
6/18/2007 7:20:34 PM

sql server dts: some users need to import the data once a while. instead of running
from the server all the time, I am thinking to create an *.exe tool
for them to run in their own machines. after create SSIS imorting
tool, may I use it to create exe file or is it possible to create and
winform *.exe application to call SSIS and upload the *.mdb data to
the SQL server.

thank you!

Re: importing data from ssis with exe file

Allan Mitchell
6/19/2007 4:44:38 AM

Hello Bob,

You can certainly buld a tool (winform, web) that can call SSIS in whatever
way you thiink (Object Model/cmdline). You need to be aware of licencing
though as this may affect your design

http://groups.google.com/groups?q=ssis+licensing&start=10&sa=N&hl=en&

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]