CODEWITHSUNDEEP
sql-serverssis
John
John

Reputation: 2792

SSIS Filtered SQL Server OLE DB Datasource

I'm writing a data transfer application that syncs two databases of similar, but differing schemas. I'm partway through, but I was wondering if SSIS might make things easier. I'm trying to figure out if it's the right solution for me, but I can't do something very simple.

The sync application is only moving subsets of data, so I need to grab rows that match a parameter. I don't see any filtering options on OLE DB datasources, though. How do I accomplish a simple where clause in SSIS? Do I have to write it myself, or is SSIS smart enough to handle it?

Upvotes: 0

Views: 3191

Answers (1)

Jayvee
Jayvee

Reputation: 10875

When you double click on the OLE DB souce, in 'Data access method' by default you'll see 'Table or View' but you can select SQL Command to enter your sql, and this will be used by the ole data source to extract the data.

Upvotes: 1

Related Questions