Post reply

Choosing control flow and data flow items?

  • June 21, 2012 at 7:38 am

    #276596

    Hi Friends,

    i don't see anywhere choosing data flow and control flow components from tool box items in Visual studio 2010 for ssis?

    how to get that ?

    Help me Friends..

    Thanks,
    Charmer

  • June 21, 2012 at 8:40 am

    #1503973

    What edition of SQL server?

    2012 runs SQL Data Tools which is built on VS20120

    2008+R2 runs BIDS2008 which is built on VS2008

    2005 runs BIDS2005 which is built on VS2005

    I always ensure that I am running BIDS or SSDT from the SQL start menu folders instead of VS to ensure you run the right level of Visual Studio.

  • June 21, 2012 at 9:34 am

    #1504030

    anthony.green (6/21/2012)

    What edition of SQL server?

    2012 runs SQL Data Tools which is built on VS20120

    2008+R2 runs BIDS2008 which is built on VS2008

    2005 runs BIDS2005 which is built on VS2005

    I always ensure that I am running BIDS or SSDT from the SQL start menu folders instead of VS to ensure you run the right level of Visual Studio.

    Anthony, Could you tell me the steps please to start from SQL menu?

    Thanks,
    Charmer

  • June 21, 2012 at 10:03 am

    #1504049

    Charmer (6/21/2012)

    anthony.green (6/21/2012)

    What edition of SQL server?

    2012 runs SQL Data Tools which is built on VS20120

    2008+R2 runs BIDS2008 which is built on VS2008

    2005 runs BIDS2005 which is built on VS2005

    I always ensure that I am running BIDS or SSDT from the SQL start menu folders instead of VS to ensure you run the right level of Visual Studio.

    Anthony, Could you tell me the steps please to start from SQL menu?

    I'm sorry, but please tell me you are joking.

    If not, however, you start by clicking on the Start ICON on the far left of the task bar (if it is located at the bottom of your screen), finding the Microsoft SQL Server (your version) folder, expanding it, then starting the BIDS from there.

  • June 21, 2012 at 10:34 am

    #1504066

    sorry Lynn, the problem was i was not able to connect the integration services theorugh SSMS....i get the following error Lynn....

    Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

    Connecting to the Integration Services service on the computer "LOCALHOST" failed with the following error: "Access is denied."

    By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.

    For help, click: http://go.microsoft.com/fwlink/?LinkId=220763

    Connecting to the Integration Services service on the computer "LOCALHOST" failed with the following error: "Access is denied."

    By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.

    i tried gooling, it has a solution in this link

    http://sqlbuzz.wordpress.com/2011/12/07/connecting-to-the-integration-services-service-on-the-computer-mirrorstand-failed-with-the-following-error-access-is-denied/

    but i see no where MsDtsServer100 in my machine under DCOM Config....

    that's why i asked step by step process.....don't mistake me....i am sorry about that..

    Thanks,
    Charmer

  • June 21, 2012 at 10:37 am

    #1504068

    anthony.green (6/21/2012)

    What edition of SQL server?

    2012 runs SQL Data Tools which is built on VS20120

    2008+R2 runs BIDS2008 which is built on VS2008

    2005 runs BIDS2005 which is built on VS2005

    I always ensure that I am running BIDS or SSDT from the SQL start menu folders instead of VS to ensure you run the right level of Visual Studio.

    i tried installing sql server 2008(not 2008 R2) but it was not installed successfully because it gave me an error like it looks for vs 2008 sp1 ....

    Thanks,
    Charmer

  • June 21, 2012 at 10:40 am

    #1504073

    Well that's a completely different error to what you said you where getting at the start of the thread.

    But again my initial question still stands, what version of SQL are you running.

    2005 it is msdtsserver90

    2008 it is msdtsserver100

    2012 it is msdtsserver110

  • June 21, 2012 at 10:42 am

    #1504074

    Charmer (6/21/2012)

    anthony.green (6/21/2012)

    What edition of SQL server?

    2012 runs SQL Data Tools which is built on VS20120

    2008+R2 runs BIDS2008 which is built on VS2008

    2005 runs BIDS2005 which is built on VS2005

    I always ensure that I am running BIDS or SSDT from the SQL start menu folders instead of VS to ensure you run the right level of Visual Studio.

    i tried installing sql server 2008(not 2008 R2) but it was not installed successfully because it gave me an error like it looks for vs 2008 sp1 ....

    Well download visual studio 2008 service pack 1 then install it then you can install SQL 2008. Simple.

    Anyway what is the true nature of your error? Not able to drag things in relation of ssis components into a dtsx package or connecting to ssis via ssms?

  • June 21, 2012 at 10:48 am

    #1504079

    anthony.green (6/21/2012)

    Well that's a completely different error to what you said you where getting at the start of the thread.

    But again my initial question still stands, what version of SQL are you running.

    2005 it is msdtsserver90

    2008 it is msdtsserver100

    2012 it is msdtsserver110

    i am using sql server 2012 but i don't see msdtsserver110 at anywhere under DCOM config....i don't know why i am not having this MsDtsServer110...

    Do you know where my problem is?

    Thanks,
    Charmer

  • June 21, 2012 at 10:51 am

    #1504082

    You do know that you don't need Interation Services service running in order to develop, deploy, and run SSIS packages, right? You only need it to manage the packages using SSMS.

  • June 21, 2012 at 10:52 am

    #1504083

    problem with both Anthony...

    i mean i added some third party tools and i tried to choose it from toolbox but i does not even show me the data flow components as well as control flow components tab....like i do in Vs 2008..

    and i am not able to connect ssi through ssms as well...

    Thanks,
    Charmer

  • June 21, 2012 at 10:56 am

    #1504086

    Lynn Pettis (6/21/2012)

    You do know that you don't need Interation Services service running in order to develop, deploy, and run SSIS packages, right? You only need it to manage the packages using SSMS.

    i don't want to lie to you Lynn, to be frank i know to some extent(not that much knowledge)about what we can do with ssms for ssis packages ...

    but i know that we use ssms for maintaining tasks...

    Thanks,
    Charmer

  • June 21, 2012 at 11:01 am

    #1504089

    Sounds like you can fire up BIDS for SQL Server 2005, correct?

  • June 21, 2012 at 11:06 am

    #1504095

    Lynn Pettis (6/21/2012)

    Sounds like you can fire up BIDS for SQL Server 2005, correct?

    i am not getting Lynn...what did you say..?

    Thanks,
    Charmer

  • June 21, 2012 at 11:08 am

    #1504096

    Charmer (6/21/2012)

    Lynn Pettis (6/21/2012)

    Sounds like you can fire up BIDS for SQL Server 2005, correct?

    i am not getting Lynn...what did you say..?

    You can run the BIDS application and build SSIS packages.

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

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