Calling a function using lookup in SSIS
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I have a datasource that pulls a IP address. I need to call a function in SQL does the same as the asp class, that converts it to a non dotted format http://www.maxmind.com/app/csv[^] which I can insert into my destination. I tried using a lookup data flow item with SELECT [LogTracking].[dbo].[sfnConverIp] (?) but I can not map it to a column with the dotted IP. There has to be a simple way right?