Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 query in expression

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-11-10 : 09:04:34
i have variable in his expression i add this query
"SELECT Count(*) FROM TABLE"

i want to see the result in my variable as number but i see
"SELECT Count(*) FROM TABLE" (i need to add this numner to the file name)

smeeluv
Starting Member

20 Posts

Posted - 2009-11-10 : 10:37:32
Try running an sql task and change the result set to single line, then load the value into that variable and use that variable in your original expression.
Go to Top of Page
   

- Advertisement -