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 |
|
kote_alex
Posting Yak Master
112 Posts |
 Posted - 2009-03-18 : 10:42:50
|
| I need to import data from a table but only data starting the current year... how can I implement a where clause in a dtsx package ? 10x ! |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-03-18 : 11:30:56
|
| Instead of selecting a table as the source, select a query and add your where clause. |
 |
|
|
kote_alex
Posting Yak Master
112 Posts |
Posted - 2009-03-19 : 03:27:06
|
| so I make an execute task and I tipe my query there... ? but what if the db is not sql but mysql? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-19 : 12:46:03
|
quote:
Originally posted by kote_alex
so I make an execute task and I tipe my query there... ? but what if the db is not sql but mysql?
i think still where should work. you may however confirm by posting this in some mysql forums like www.dbforums.com |
|
|
|
|
|
|
Import data with a where clause