July 9, 2010 at 3:47 am
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
July 9, 2010 at 5:01 am
Hi,
Thanks for the reply.
M in the control flow page, not able to proceed further.
what would be my next step?
July 9, 2010 at 6:14 am
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
July 9, 2010 at 6:25 am
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
July 9, 2010 at 8:36 am
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