Post reply

SSIS's example in a single point

  • October 5, 2010 at 2:39 pm

    #229123

    Hi

    Is there examples of SSIS for each and every control flow and data flow items control flow Starting from pointer, for loop container,foreach loop container... xml task.

    Maintenance plan pointer.... update statistics task

    Data flow Source Starting from Ado NET Source ... xml Source.

    Data flow Transformations Starting from pointer.... unpivot

    Data flow Destination Starting from pointer.... SQL Server destination

    Any links or example with AdventureWorks or AdventureWorksDW as examples.

    I have googled but i could not find all @ one point it will be better to

    have those in a single site or in multi site which covers all the items

    (This is to just have understand what does each item doing,only explnations are there ,if it is with data(real time) it will be easy to understand)

    Thanks

    Parthi

    :smooooth:

    Thanks
    Parthi

  • October 5, 2010 at 2:54 pm

    #1232090

    you could start here: http://technet.microsoft.com/en-us/library/ms141026.aspx


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 5, 2010 at 3:07 pm

    #1232095

    Alvin Ramard (10/5/2010)

    you could start here: http://technet.microsoft.com/en-us/library/ms141026.aspx

    Hi

    Thanks for your response,i need to have examples for each and every item, this will come under help itself but. I need examples but there is no examples for each item.

    Thanks

    Parthi

    Thanks
    Parthi

  • October 5, 2010 at 3:16 pm

    #1232100

    I don't think you'll find one source that has examples for everything.

    There's a number of books that are good references for what you're looking for. If you're in hurry to learn, you might want to start with:

    Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services published by Wrox


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 5, 2010 at 3:22 pm

    #1232102

    Alvin Ramard (10/5/2010)

    I don't think you'll find one source that has examples for everything.

    There's a number of books that are good references for what you're looking for. If you're in hurry to learn, you might want to start with:

    Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services published by Wrox

    Once again thanks for replay.If u know more books on SSIS /SSRS refer here.I would like to learn on it

    Thanks
    Parthi

  • October 6, 2010 at 2:57 am

    #1232314

    Please follow here

    Raunak J

  • October 6, 2010 at 3:52 am

    #1232340

    It better to pick any book which talks about every task in SSIS,

    and then just try out your own.

  • October 6, 2010 at 7:45 am

    #1232532

    I have used the following book and it is quite comprehensive:

    Professional MS SQL Server 2008 Integrations Services from Wrox. (one of the authors is Brian Knight)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 13, 2010 at 5:42 am

    #1236090

    Thanks a lot Raunak....:-) vry useful link.....

  • October 13, 2010 at 5:50 am

    #1236095

    chandrakala_h_s (10/13/2010)

    Thanks a lot Raunak....:-) vry useful link.....

    😎

    But again I would re-iterate what other posters have said..."read and practice":-)

    Hapy to help.

    Raunak J

  • October 13, 2010 at 6:16 am

    #1236105

    yep Sure.....

  • October 15, 2010 at 12:04 am

    #1237308

    hi,

    Can nyone hlpout on dis err...!!!!

    [Flat File Source [1]] Error: Data conversion failed. The data conversion for column "Column 1" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

  • October 15, 2010 at 12:18 am

    #1237312

    chandrakala_h_s (10/15/2010)

    hi,

    Can nyone hlpout on dis err...!!!!

    [Flat File Source [1]] Error: Data conversion failed. The data conversion for column "Column 1" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

    hi

    The flat file defaults initially all columns to characters with length of 50. You can change this by going to the “Advanced” page of the Flat File connection page and change the length manually, or you can click on "Suggest Types..." to get suggested column metadata attributes based on sampling a certain number of rows from the file.

    Your destination table is having more or less length than the default(50) one. so you need to change the length accordingly

    Thanks

    Parthi

    Thanks
    Parthi

  • October 15, 2010 at 12:23 am

    #1237314

    Thanks Parthi.... its sorted.....:-) i changed the column width values in the advanced option as u said....

  • October 15, 2010 at 12:57 am

    #1237322

    chandrakala_h_s (10/15/2010)

    Thanks Parthi.... its sorted.....:-) i changed the column width values in the advanced option as u said....

    I am glad that i could help u in solving ur problem

    Thanks

    Parthi

    Thanks
    Parthi

Viewing 15 posts - 1 through 14 (of 14 total)

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