 | |
How do I connect an SSIS data flow to an existing SQL Server 2005
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: How do I connect an SSIS data flow to an existing SQL Server 2005 -
05-27-2008
, 02:38 PM
|
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, Do you really have to do this by using functions as opposite to the |
straightforward process and you can do it for all rows by a single
operation .
#12
| |||
| |||
|
|
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, Do you really have to do this by using functions as opposite to the |
straightforward process and you can do it for all rows by a single
operation .
#13
| |||
| |||
|
|
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, Do you really have to do this by using functions as opposite to the |
straightforward process and you can do it for all rows by a single
operation .
#14
| |||
| |||
|
|
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, Do you really have to do this by using functions as opposite to the |
straightforward process and you can do it for all rows by a single
operation .
#15
| |||
| |||
|
|
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, Do you really have to do this by using functions as opposite to the |
straightforward process and you can do it for all rows by a single
operation .
#16
| |||
| |||
|
|
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, Do you really have to do this by using functions as opposite to the |
straightforward process and you can do it for all rows by a single
operation .
#17
| |||
| |||
|
|
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, Do you really have to do this by using functions as opposite to the |
straightforward process and you can do it for all rows by a single
operation .
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.