Post reply

SSIS

  • August 26, 2010 at 11:16 am

    #387670

    Hello,

    I have got 3 tables in one schema. I am selecting a few columns from the 3 tables using join.Apart from that i am hard coding columns and displaying the combimed output using a select query as mentioned before. I need to import these tables in to another schema. I have got a table in the second schema with the same data type as the columns i am trying to import. The table in the second schema has got a composite defined on it. I am thinking of using a dataflow task for the requirement. I am using sqlsever2005. The importing of data is not a one time task....... every time there is an updation of data in the first schema, I wil b running this package n updating the data in the second schema. Can any one tel me which is the best approach for the requirement?

    Let me know which transformations should i be using n how to use them. I wil be very thankful if any one can help me out. Please keep in mind abt error handling too.. let me know how to get my ssis package going......

  • August 26, 2010 at 10:38 pm

    #1212713

    Hey Ria,

    What I understand is that you need to implement 'Reflection'.

    Am I correct?

    Raunak J

  • August 27, 2010 at 1:19 am

    #1212770

    Dosnt look like replication as the destination looks like only 1 table. If so this looks like a perfect job for SSIS.

    If your new to SSIS I'd do some light reading on starting out (basic 101 stuff), you'll learn about connection managers and the basics on data flows. Youll than get a feel for the things you can do. This seems like a good intro package.

    However, this seems like a simple process and could be done well with thraditional SQL methods.

  • August 27, 2010 at 3:25 am

    #1212813

    RiaRay (8/26/2010)

    Hello,

    I have got 3 tables in one schema. I am selecting a few columns from the 3 tables using join.Apart from that i am hard coding columns and displaying the combimed output using a select query as mentioned before. I need to import these tables in to another schema. I have got a table in the second schema with the same data type as the columns i am trying to import. The table in the second schema has got a composite defined on it. I am thinking of using a dataflow task for the requirement. I am using sqlsever2005. The importing of data is not a one time task....... every time there is an updation of data in the first schema, I wil b running this package n updating the data in the second schema. Can any one tel me which is the best approach for the requirement?

    Let me know which transformations should i be using n how to use them. I wil be very thankful if any one can help me out. Please keep in mind abt error handling too.. let me know how to get my ssis package going......

    Sounds to me like a simple insert statement in a trigger - the table in the second schema will be updated automatically when data is inserted/updated in the table in the first schema.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • August 27, 2010 at 3:31 am

    #1212814

    I missed that 🙁 your right.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply