Hope I'm in the right Newsgroup for this question. I'm sure someone will put
me right if I'm not

I'm trying to build a SQL Server 2005 SSIS package in VS2005.

The package, on the face of it, is fairly straightforward. It needs to
import an Excel worksheet into a temporary data structure and then feed a
couple of columns of this data to two existing SQL Server 2005 database
functions that will generate a Username and a Password from the 'FirstName'
and 'LastName' inputs. Finally the original data plus the new Username
Password are to be inserted as new rows in a SQL Server 2005 database table.

Problem is I just can't figure out the penultimate step - i.e. how to feed
the 'FirstName' and 'LastName' columns as parameters to the functions. I must
have looked at every data flow component but to no avail. So have taken a
break until my head stops spinning.

Was wondering if someone could point me in the right direction?

Regards,

YaHozna.

Hi YaHozna,

How does your function work? Is it a SQL function stored in the SQL
Server database?

If so - you'll need to put an OLE DB Command task in your data flow to
run the function statement row-at-a-time and capture the return
values. These can then be inserted into the DB using a OLE DB (or SQL
Server) Destination task.

Good luck!
J

Hi YaHozna,

How does your function work? Is it a SQL function stored in the SQL
Server database?

If so - you'll need to put an OLE DB Command task in your data flow to
run the function statement row-at-a-time and capture the return
values. These can then be inserted into the DB using a OLE DB (or SQL
Server) Destination task.

Good luck!
J

Hi YaHozna,

How does your function work? Is it a SQL function stored in the SQL
Server database?

If so - you'll need to put an OLE DB Command task in your data flow to
run the function statement row-at-a-time and capture the return
values. These can then be inserted into the DB using a OLE DB (or SQL
Server) Destination task.

Good luck!
J

Hi YaHozna,

How does your function work? Is it a SQL function stored in the SQL
Server database?

If so - you'll need to put an OLE DB Command task in your data flow to
run the function statement row-at-a-time and capture the return
values. These can then be inserted into the DB using a OLE DB (or SQL
Server) Destination task.

Good luck!
J

Hi YaHozna,

How does your function work? Is it a SQL function stored in the SQL
Server database?

If so - you'll need to put an OLE DB Command task in your data flow to
run the function statement row-at-a-time and capture the return
values. These can then be inserted into the DB using a OLE DB (or SQL
Server) Destination task.

Good luck!
J

Hi YaHozna,

How does your function work? Is it a SQL function stored in the SQL
Server database?

If so - you'll need to put an OLE DB Command task in your data flow to
run the function statement row-at-a-time and capture the return
values. These can then be inserted into the DB using a OLE DB (or SQL
Server) Destination task.

Good luck!
J

Hi YaHozna,

How does your function work? Is it a SQL function stored in the SQL
Server database?

If so - you'll need to put an OLE DB Command task in your data flow to
run the function statement row-at-a-time and capture the return
values. These can then be inserted into the DB using a OLE DB (or SQL
Server) Destination task.

Good luck!
J

Hi YaHozna,

How does your function work? Is it a SQL function stored in the SQL
Server database?

If so - you'll need to put an OLE DB Command task in your data flow to
run the function statement row-at-a-time and capture the return
values. These can then be inserted into the DB using a OLE DB (or SQL
Server) Destination task.

Good luck!
J

On May 27, 9:39*am, YaHozna <YaHo... (AT) discussions (DOT) microsoft.com> wrote:
store procedures? With the procedures it should be rather simple and
straightforward process and you can do it for all rows by a single
operation .