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)  SSIS Variable

Author  Topic  GetLost Starting Member 2 Posts Posted - 2009-09-17 : 08:04:09 In an SSIS project I'm trying to populate a variable with the result of a query stored in another variable. My variable are : User::Query_StartDate - datatype String = Select StartDate from dbo.Date_extract and User::Startdate - datatype DateTime I have an execute SQL Task - Sourcetype : variable, SourceVariable=User::Query_StartDate Result set=single row, Result Name=StartDate, Variable = user::StartDate. When I run the task the result (put in a msg box) is the current date, not the date of my table. Can anyone help?