Using a Script to pull from an SSIS database

[peter.zanetti]

From a previous topic (http://support.nagios.com/forum/viewtop ... 16&t=32968) we have a script that will now take a CSV and add new devices based off what is in the CSV.

In this SSIS package we are collecting data from our inventory repository and from our nagios repository and comparing daily what needs to be added to nagios.

Is there a way to use this script to make a SQL Database call and use the results it gets back as its arguments instead of feeding the arguments via CSV?

[tmcdonald]

Is there a way to use this script to make a SQL Database call and use the results it gets back as its arguments instead of feeding the arguments via CSV?

There should be a way, but this is getting pretty far into custom development. Looking over that last thread you linked, we went well outside the scope of what this forum is intended to cover. We can help with specific problems you are having with our products, and we don't mind a little back-and-forth on custom scripts, but at a certain point we are stepping on the toes of our developers.

Broadly speaking, what are you having trouble with? We can give some high-level guidance on what the general steps should be, but at some point we need to refer you to Sales for a consultation quote.

[ssax]

If you are interested in custom development, you can contact [email protected] to request more information.

You might want to look into the command line utilities freeTDS (tsql) or sqlcmd for connecting to a remote SQL server.

https://msdn.microsoft.com/en-us/librar ... 10%29.aspx

http://www.freetds.org/

[peter.zanetti]

My apologies, I didn't realize this was outside the scope. Thank you for the guidance though.