|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
advanced editorI am used to DTS packages in sql server 2000 and now I want to use Integrated
services to create 'DTS' packages. Going to a .net users group meeting, I was told to use the 'Advanced editor' since it would help me alot. However, I can not find the 'advanced editor' in sql server 2005. Thus can you tell me where the 'advanced editor'is and what are some good uses of the advanced editor? Thanks! Wendy Elizabeth (WendyElizab***@discussions.microsoft.com) writes:
> I am used to DTS packages in sql server 2000 and now I want to use Are you looking in SQL Server Mangement Studio? You find precious little> Integrated services to create 'DTS' packages. Going to a .net users > group meeting, I was told to use the 'Advanced editor' since it would > help me alot. However, I can not find the 'advanced editor' in sql > server 2005. Thus can you tell me where the 'advanced editor'is and what > are some good uses of the advanced editor? support for Integration Services there. You should have a look at Business Intelligence Development Studio (BIDS), which really is Visual Studio under a custom name. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx I did find it was in Business Intelligence part of Visual studio.net. But
once you are in BIS, where do you find the advanced editor? Thanks! Diane Stein Show quote "Erland Sommarskog" wrote: > Wendy Elizabeth (WendyElizab***@discussions.microsoft.com) writes: > > I am used to DTS packages in sql server 2000 and now I want to use > > Integrated services to create 'DTS' packages. Going to a .net users > > group meeting, I was told to use the 'Advanced editor' since it would > > help me alot. However, I can not find the 'advanced editor' in sql > > server 2005. Thus can you tell me where the 'advanced editor'is and what > > are some good uses of the advanced editor? > > Are you looking in SQL Server Mangement Studio? You find precious little > support for Integration Services there. You should have a look at > Business Intelligence Development Studio (BIDS), which really is Visual > Studio under a custom name. > > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Books Online for SQL Server 2005 at > http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx > Books Online for SQL Server 2000 at > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > Wendy Elizabeth (WendyElizab***@discussions.microsoft.com) writes:
> I did find it was in Business Intelligence part of Visual studio.net. But Now you asking me questions that goes over my head. :-) I don't use SSIS> once you are in BIS, where do you find the advanced editor? much, or rather not at all. I just wanted to save you from looking in SSMS. But isn't this "Advanced Editor" simply the Package Designer you get when you create an Integration Services project? -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx The "Advanced Editor' most likely refers to a property dialog for SSIS
components that allows you to set any property available on that component and configure a lot of settings beyond what's typically available on the regular Properties dialog for the same component. In general, to use new SSIS designer, you start BIDS application, and create a new SSIS project (click New -> Project, and pick SSIS project from the list). This will create a new SSIS package within a project and open it up. From there you will see the package's design surface, where you can drop control flow components from a toolbox window, connect them into a flow and configure. If you right click on any component, you will see an 'Advanced Editor' option. If you have more questions, there is a separate SSIS forum where you will find more experts ready to answer those. Regards, Maciek Sarnowicz Show quote "Erland Sommarskog" <esq***@sommarskog.se> wrote in message news:Xns99E4C3B06E16BYazorman@127.0.0.1... > Wendy Elizabeth (WendyElizab***@discussions.microsoft.com) writes: >> I did find it was in Business Intelligence part of Visual studio.net. But >> once you are in BIS, where do you find the advanced editor? > > Now you asking me questions that goes over my head. :-) I don't use SSIS > much, or rather not at all. I just wanted to save you from looking in > SSMS. But isn't this "Advanced Editor" simply the Package Designer you > get when you create an Integration Services project? > > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Books Online for SQL Server 2005 at > http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx > Books Online for SQL Server 2000 at > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics