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.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2009-10-12 : 04:13:22
|
| Dear All,I am using Data Source reader to read from ADO.net data sorce.I am using the following expression to select the rows from the table."select * from Employee where jdate='" + (DT_WSTR,20)@[User::date] + "'"when i execute the evaluated expression in query analyzer it returns the row,but the same data is not returns to destination table when i executed through the SSIS package.Do u need to do any data type conversion here please help.Thanks,Gangadhar |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-15 : 05:58:11
|
| What is the evaluated value of the expression?Example: Expression: "select * from MyTable where mydate='" + (DT_WSTR,30) GETDATE() + "'"Evaluated value: select * from MyTable where mydate='2009-10-15 10:54:46.663000000'Then run the Evaluated value in SQL Server QA. This will help - either give an error or you'll see that the evaluated value of date does not equal any value in your table, and you may need to reformat the expression. |
 |
|
|
|
|
|
SSIS Error