New to SSIS

  • Hi All,

    I have just begun with SSIS.

    I am following a manual kind of stuff to create a sample SSIS package.

    I have done the following:

    1. Export DB data to Excel

    2. Create Project/Solution

    3. Create Connections in Connection Manager

    Now my prob is, i am not able to see the items within the ToolBox when i click on the package.

    What may be wrong?

  • This was removed by the editor as SPAM

  • Hi,

    Thanks for the reply.

    M in the control flow page, not able to proceed further.

    what would be my next step?

  • Hi

    Take one souce db or other what ever do u want

    and next take destination in execel sheet and connect to s to d

    execute that packages before that drag one dataflow task doule click auto matically goes to control folw task then do it.

    Tx

    subu

  • Thanks for the reply,

    But i could not understand what would happen in the data flow region.

    My prob is i dont even have the least idea of SSIS.

    like in SSRS we see the data sources, design and preview ... can i see what happens in SSIS?

    Also i have the following questions:

    1. I read packages can be independent. they dont need SSMS to be running.

    So, can i copy a package to some temporary storage and carry it?

    I mean if i design a package at one machine, can i run it on my server here?

    2. What are the Protection Level,Isolation Level properties?

    3. Now in a tutorial i am following, they have begun with packages. is this the right way to do?

    4. And lastly, What are Control Flow and Data Flow?

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • To give some sort of general definition of SSIS:

    SSIS is an ETL tool. If you don't know what ETL is, search it on wikipedia.

    It reads data from a source, then you transform the data with various components and/or tasks and then writes it to a destination.

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

Viewing 8 posts - 1 through 7 (of 7 total)

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