Call 3rd party software within package

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Call 3rd party software within package

Call 3rd party software within package

Rate Topic

Display Mode

Topic Options

Author

Message

Lookup_BI

Posted Wednesday, November 28, 2007 9:45 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 31, 2009 7:53 AM
Points: 150, Visits: 642

Hi,

I am not sure if this is possible within an SSIS package

1) I have a txt file coming in [source] .
2) Data coming in goes through a number of transformation [Data Conversion / Sorting / Derived Column]and is loaded to a Staging table in SQL.
3) This Staging table is loaded back into a txt file.
4) Text file is sent out through [Send Mail Task] to respective party.

My company has purchased an Address Cleansing Tool[3rd party software].This tool is to perform cleansing on my staging table in SQL on a column [Address].After tool is executed, Staging table in SQL is updated with corrected values for the [Address] column.

My task is to, call the 3rd party software within my SSIS package after task 2) and before task 3) takes place.Task 3) should only be executed if [3rd party software] execution is a success.

The Address cleansing tool is written in .Net.

Greatly appreciate suggestions as I have not got a clue on how to solve this and if this is possible.Thank You in advance !

“I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison

Post #426954

Norman Kelm

Posted Wednesday, November 28, 2007 10:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 04, 2012 1:34 PM
Points: 130, Visits: 322

Hopefully this 3rd party tool has a command line interface.

If so, then the Execute Process Task will do the job.

Norman

DTS Package Search
http://www.dtspackagesearch.com/

Post #426991

Lookup_BI

Posted Wednesday, November 28, 2007 2:18 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 31, 2009 7:53 AM
Points: 150, Visits: 642

Now I know what Execute Process Task does.Let me get my hands dirty with it.Shall post my ouput soon.Thanks

“I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison

Post #427103

« Prev Topic | Next Topic »

Permissions