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 2008 Forums
 SSIS and Import/Export (2008)
 Data Set Query not accepting changes

Author  Topic 

steved45
Starting Member

1 Post

Posted - 2011-10-19 : 13:01:51
I'm new to this. When I create a data set in the Visual Studio (2008R2) and use a date range query to weed out only the dates I wish to see it works fine - 1st time only. If I make a change to that query statement it ignores it - I even recreated the data set with an entirely different where statement and it ignored that too.

I am saving ALL after every change - what am I doing wrong or not doing??

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-20 : 04:23:04
you need add parameters and pass it to where statement. this will add parameters to your report and will help you to pass values for filtering as you want

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -