Read A Table Row Into A Variable 1

[Skittle]

I would like to read a single row table from SQL Server into a SSIS package variable. I want to use the variable as part of an expression in a container. I know I could set it as a configuration parameter but I don't want to go down that route if I can avoid it.

Can anybody suggest a way of doing this?


Dazed and confused

 

[RiverGuy]

You can use an Execute SQL Task (see here

http://msdn2.microsoft.com/en-us/library/ms189419.aspx).

Or if you need more flexibility, then you can always rely on the good ol' Script task and write VB code.

 

[Viass]

1. create a variable

>Define a variable 'var1'
>Datatype as 'object'
>Value as 'System.Object'

2. Right Click Execute SQL Task
and choose EDIT

General TAB
SQLSourceType : Direct input
SQLStatement : Select 'column1' from 'Table1'

Result Set TAB
>set 'Result Name' to 0
>set 'Variable Name' to user::var1


In your For EaCh Loop Container,
choose :
>ForEach ADO Enumerator
and
>user::var1 as ADO source variable

Hope this helps

 

[Skittle]

Thanks dude.

Dazed and confused