Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    20

    Unanswered: SSIS data transformation

    Well ,
    I am basically using Data source--> data transformation--> data flow destination method in SSIS to transfer my data from a flat file source to a SQl table.

    Do we have any transformation component or any other technique which allows me filtering the data? I mean i don't want all the records in the destination table instead of that I want to execute a select query before all the records are loaded to the destination table. How can I do that??

    Kunal

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I've moved your question from Database Concepts and Design Forum into the Microsoft SQL Server Forum so that it will be more likely to get an answer.

    The objects in an SSIS package are fundamentally snippets of VBA that manipulate ADO objects. There are multiple ways to filter a query from a data source. If you are using the GUI tools, I'm not much help... I rarely use them myself, but I believe that you can right-click and select the Properties on the pop up menu to add or change the filter.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jun 2009
    Posts
    20

    Smile

    Thank you very much Pat for moving my post to the right place.

    And to the answer to answer my question: Actually I came across on transformation component called " look up transformation component" That actually helps little bit in filtering the query with the help of select statements.

    Thank you very much for you r concern and your help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •