Q
Problem solve Get help with specific problems with your technologies, process and projects.

SSIS package to filter false records

I have a table, let's call it AlarmTriggers and it has a Boolean field pulled into it. When my software writes to it the table doesn't set the field to true. It's kept false. I want to use an SSIS package that filters all false records in the table and pull it over to another server. After the records have been pulled I would like the SSIS package to mark those pulled records as true. So, the source table field pulled must be set to true. I am using SQL Server 2005 Workgroup Edition. Can you tell me how to do this?

I have a table, let's call it AlarmTriggers and it has a Boolean field pulled into it. When my software writes to it the table doesn't set the field to true. It's kept false. I want to use an SSIS package that filters all false records in the table and pull it over to another server. After the records have been pulled I would like the SSIS package to mark those pulled records as true. So, the source table field pulled must be set to true. I am using SQL Server 2005 Workgroup Edition. Can you tell me how to do this?
You can certainly use SSIS to transfer the data to another server and to mark the rows as transferred using the Boolean column. Use a Data Flow task in SSIS to transfer the data. In the Data Fow task you will specify an OLE DB source connection that points to your server and database. In the OLE DB source you can specify a table, view or some SQL code to extract the data. You may consider using a SQL code and creating SELECT statement that filters data based on your Boolean column. When you transfer the rows using your Data Flow task you can use an EXECUTE SQL task to update the rows setting the Boolean column to True.
This was last published in November 2006

Dig Deeper on SQL Server Interoperability

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close