SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Call 3rd party software within package


Call 3rd party software within package

Author
Message
Lookup_BI
Lookup_BI
SSC Veteran
SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)

Group: General Forum Members
Points: 266 Visits: 642
Hi,

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

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
Norman Kelm
Norman Kelm
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 325
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/



Lookup_BI
Lookup_BI
SSC Veteran
SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)

Group: General Forum Members
Points: 266 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search