New to SSIS

• malavika.ramanathan

  SSCrazy

  Points: 2790

  More actions

  July 9, 2010 at 3:47 am

  #226616

  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?

• July 9, 2010 at 4:42 am

  This was removed by the editor as SPAM

• malavika.ramanathan

  SSCrazy

  Points: 2790

  More actions

  July 9, 2010 at 5:01 am

  #1190699

  Hi,

  Thanks for the reply.

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

  what would be my next step?

• shiv-356842

  SSCarpal Tunnel

  Points: 4312

  More actions

  July 9, 2010 at 6:14 am

  #1190732

  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

• malavika.ramanathan

  SSCrazy

  Points: 2790

  More actions

  July 9, 2010 at 6:25 am

  #1190747

  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?

• July 9, 2010 at 6:30 am

  This was removed by the editor as SPAM

• July 9, 2010 at 6:43 am

  This was removed by the editor as SPAM

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  July 9, 2010 at 8:36 am

  #1190830

  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