Skip to main content
Question

Using FME with Microsoft SQL Server SSIS

darren
Contributor
Forum|alt.badge.img+6

Does anybody know if it is possible to trigger a SQL Server SSIS package from an FME workspace?

I have FME Professional Edition but not the version that can write directly into Microsoft SQL databases so I was hoping that a workaround might be to carry out the required transformations using FME, output the results to a file and then have SSIS pick up the file and import it into the database. It's a long way round but I haven't got a hope of getting budget approval for and upgraded version of FME (that would make life far too easy!)

I'm not a python programmer but was thinking that maybe the Shutdown Python Script might be of help here?

Many thanks

2 replies

bruceharold
Contributor
Forum|alt.badge.img+17
  • bruceharoldContributor
  • Contributor
  • July 26, 2016

It looks like you can use FME Cloud for this, while not free if your need is short term it will not cost much:

http://www.safe.com/solutions/for-databases/microsoft-sql-server/

darren
Contributor
Forum|alt.badge.img+6
  • darrenContributor
  • Author
  • Contributor
  • July 27, 2016
bruceharold wrote:

It looks like you can use FME Cloud for this, while not free if your need is short term it will not cost much:

http://www.safe.com/solutions/for-databases/microsoft-sql-server/

Thanks Bruce, unfortunately this isn't a one-off exercise so I will want to carry out this operation (and probably others) on a daily basis. I would love to upgrade my copy of FME Desktop (or even better upgrade to Server or Cloud) but budgets are non existent at the moment, although I'm going to continue to try using the argument that automating these processes will actually save us money.

Reply


Helpful Members This Week

Community Stats

31,299
Posts
118,687
Replies
38,878
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.