.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Post New Web Links

Issues with SSIS and SQL 2008 - Integration services not running

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hey guys, I installed SQL 2008 with complete BI studio including Integration Services. When i check in my services - i cant see my integraiton services in there When i try to connect to Integration Service using localhost, I cant connect it And when i try to run setup of SQL 2008 - It shows that Integration Services already installed and that what i checked when i fetched my Installation tool report from SQL Server to verify i have it installed. Why can i access Integration services, if i already have it, Please suggest with ideas, checks i can make to ensure every setting is in place. Thanks. Would appreciate for quick response.  

View Complete Post

More Related Resource Links

SQL Agent - Running SSIS Package - Windows Server 2008/Windows 7 - Messenger Services


We have tried to run a SQL job for SSIS Package. But it failed during the execution with the error "[364] The Messenger service has not been started - NetSend notifications will not be sent". But in the job, no notifications have been configured and in windows server 2008/Windows-7 there is no messenger service at all.

When we search for the the messenger service in windows 7/windows server 2008, we found that service is not in both the OS and it was replaced by msg.exe. 

Any help or workaround would be appreciated.

Thanks in advance.

PS: The normal SQL jobs other than SSIS are working fine without any error.

Vijay Pandurangan

Issues with running SSIS packages programmatically

Hi, I have spent days trying to solve this problem and still stuck with this and I have posted some questions already in forums, but didn't get satisfactory answers. I am trying to be more clear this time and hope to get a better answer. I have gone through this article already http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx and here are my issues (I need to run the SSIS package from ASP.NET) option 1 is not suitable for me, because it may recycle worker process if it consumes memory option 2 is also not suitable because of security issues in creating a new process and passing the context to new process looks very complicated for me (according to the support article) option 3 is not suitable because using SQL Server Agent to run SSIS package is not allowed by the company I am working for(I guesss it requires installation of db engine on application server, not sure). but SSIS is installed on the application server. option 4&5 will have the same issues as options 1&2. I guess the only option left now is to create a windows service and start the service from ASP.NET. but will this allow running multiple packages in parallel? OR is there a better alternate solution for this? please let me know. Thanks.

Problems with Report Services 2008 Integration in Sharepoint Foundation 2010

hi Folks, i ihave tried to solve my problem with this entry, but it has not fixed the issue. I would like to integrate RS in a Sharepoint Foundation 2010 environment, but when try to integrate the RS in Central Administration I am receiving the following error, see pic: Central Administration jpg When I try to access direct the RS Url the I get an access denied error please help.   thx a lot

Problems installing SQL Server 2005 Integration Services for Server 2008 R2

I am trying to install Microsoft Forefont and i have got a tick on every requirement bar 1. I can't install SWL Server 2005 Integration Services Component. I am running windows Server 2008 R2. I have tried numerous steps such as going into to control panel and adding component but the Integration services is not appearing on the options. Is it actually possible to install 2005 integration services on server 2008 and if so how? Thanks

Reporting Services 2008 Performance Issues

We are experiencing longer than should be, although intermittent, response times from Reporting Services server when requesting reports via HTTP.  Here's what we've done to try and locate the issue.
  1. We used the FireFox Net panel to locate the request that appears to be the culpret - it is the '...Pages/Report.aspx?ItemPath=...' request.  This request sometimes returns in 2 seconds and sometimes it takes 20+ seconds
  2. We have checked the Reporting Services ExecutionLogStorage table to see the actual report querying, processing and rendering times for the report and since the report has been up, the total time reported by Reporting Services is less than 3 seconds total (even less than 1 second most of the time)
  3. We're almost positive that there isn't a network issue - we're able to ping the server (although on a different subnet) while the report is taking it's 20+ seconds to return and the network has excellent ping results
  4. We've run a packet sniffer during the http request of the report - the browser sends a few messages to the server, the server responds.&n

SQL Server 2008 R2 integration services SCD error


Dear All,

I have designed a packge using SSIS 2008 and populated 100 records first day it was worked fine.

Secound there 100 old records(some records are changed ) and 5000 new records and started load the data. When i start the package i am getting the below error.


[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Slowly Changing Dimension" (1354) failed with error code 0xC0202009 while processing input "Slowly Changing Dimension Input" (1365). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.




- Thiru

SQL Server 2008 R2 Analysis Services - Syncronization Speed Issues


We are experiencing a severe performance issue when syncronizing cubes using R2. We have 2 sets of machines that we are experiencing varied performance and speed when syncronizing cubes.

Test Server Pair 1
Dell R710, 72GB Ram, 2 drives in Raid 1 (OS), 4 drives in Raid 10 (Cube and DB Storage) - This is the source server
Dell R900, 256GB Ram, 2 Drives in Raid 1 (OS), 3 Drives in Raid 5 (Cubes & Storage) - Server recieving sync updates

These servers are running Windows 2008 R2 Enterprise and SQL Server 2008 SP1 CU9 Enterprise (64bit). The performance of the cube syncronization is slow but manageable.

Test Server Pair 2
Dell R710, 96GB Ram, 2 drives in Raid 1 (OS), 4 drives in Raid 10 (Cube and DB Storage) - This is the source server
Dell R910, 256GB Ram, 2 Drives in Raid 1 (OS), 14 Drives in Raid 10 (Cubes & Storage) - Server recieving sync updates

These servers are running Windows 2008 R2 Enterprise and SQL Server 2008 R2 CU2 Enterprise (64bit). This pair of servers running SQL 2008 R2 syncronize very slowly.  The process about 70-80 percent slower than the first pair. Our cubes that we syncronize are very large in size (some are 500-800GB in size) and for that reason con

Step By Step Integration Services 2008?


I have wored through Microsoft 2008 Step by Step Analysis Services and its brilliant so I want to do the Integration Services next, however I cant find one, does one exist?? will one exist or should I make do with the 2005 version?



SharePoint 2010 and Reporting Services 2008 R2 Integration Fail - Failed to establish connection wit


We have installed SQL Server 2008 R2 Standard Edition on a virtual server (C-SQL) and SharePoint Server 2010 on another virtual server (C-SPOINT), with the SQL Backend of the SharePoint database residing on C-SQL. This worked fine.

SQL Server was installed with the domain administrator account and SharePoint with an account called 'visi' that has domain administrator privileges.

SSRS on C-SQL was initially installed as a native database. I changed this to a SharePoint integrated database with all authentications done as the visi user. Report server url was set to the normal http://C-SQL:80/ReportServer/.

On the SharePoint central administration site under General Application Settings -> Reporting Services Integration I filled in the details as required:

  • 2 SSIS services running on one machine



    I have developed a set of packages which i am attempting to deploy to a server which i did not configure.

    The Server has three versions of SQL installed - SQL 2000 (default), 2005 and 2008.

    When i run my deployment manifest i receive an error: 0xC0011008 - I think this is because my package is developed in BIDS 2008 and the server is running SSIS 2005.

    This is my issue....when I look in the services on the server - i have two integration services, both running (i didn't think this was possible?)

    1. SQL Server Integration Services
    2. SQL Server Integration Services 10.0

    When i connect to Integration Services through SSMS - the version displayed is 9.0.4035

    There is also no DTS directory under the C:\Program Files\Microsoft SQL Server\90\ or C:\Program Files\Microsoft SQL Server\100 directory ....?

    How can i rectify this? I want to end up with SSIS 2008 installed.

    Thanks, Clay


    SharePoint 2010 & Sql 2008 Reporting Services Integration


    Need a little help.  Here is the error message I recieve when trying to add the Reporting Services URL in Central Administration

    Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages

    Here is the report from the Log.

    10/20/2010 14:31:56.58  w3wp.exe (0x0B6C)                        0x05E8 SQL Server Reporting Services  Configuration Pages            aabe Medium   RS configuration object updated with RSServerUrl=http://sql2/ReportServer, AuthenticationType=Windows 58bcdd3b-13e9-4bd7-8008-718e5fd7202a
    10/20/2010 14:31:57.61  w3wp.exe (0x0B6C)                        0x05E8 SQL Server Reporting Services  SOAP Client Proxy              0000 High     Exception encountered for SOAP method GetSystemProperties: System.

    Reporting Services 2008 report integration in a gadget


    Hello everybody,

    I would like to distribute a small report I have made in Reporting Services which contains only one graph by using a Windows 7 Gadget. Does anybody know how to integrate a MS SQL Reporting Services 2008-report in a gadget?

    Your answers are greatly apreciated.


    Kind regards,


    Warning: Cannot debug script tasks when running under the 64 bit version of the Integration Services


    Is there any workaround for that (other than switching to a 32-bit computer)?



    SSIS 2008 SCD Performance Issues



    We are having 20 dimension tables and each table will be having around 20 million records.

    These tables would be loaded on a daily frequency with 5 files, each of 3 million records.

    We are currently using SCD transformation for TYPE2 load of data.( to maintain history in the dimension table.)

    But SCD is taking a long time to insert the data and below are the statistics that I recorded when I executed the package with sample files:

    Run1: File1(0.5 million records)  -2 minutes  (Dimension Table is empty)
    Run2: File2(0.5 million records)  -13 minutes (Table has  589,000 records)
    Run3: File3(0.5 million records)  -26 minutes (Table has 1,140,000 records)
    Run4: File4(0.5 million records)  -37 minutes (Table has 1,680,000 records)
    Run5: File5(1 million records)   -51 minutes (Table has 2,780,000 records)

    Package elapsed time : 2 hr 9 min

    1. How do i improve the performance of the SCD? If not, is there any way of loading a table parallely from file so that i can achive performance?

    2. In informatica, we have a partitioning feature to load the data parallely which greatly improves performance. Is there any equivalent feature or workaround in SSIS?

    Any help would be greatly appreciated.



    Can't log into a SQL Server 2005 Integration Services with SSMS 2008.


    We have a server running SQL Server 2005 Ent on a Windows Server 2003 platform. It runs just fine and I have no problem accessing any of the Business Intelligence services using SSMS 2005.

    I recently upgraded my development PC to SQL Server 2008 as we'll be deploying it to our production servers in the next few days. I am able to access the Database Engine, SSAS and SSRS on the 2005 server with SSMS 2008, but when I try to log into Integration Services, I get the following error:

    TITLE: Connect to Server
    Cannot connect to servername.
    Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

    Connect to SSIS Service on machine "servername." failed:
    Class not registered

    Luckily I did not uninstall SSMS 2005, so I can still access it from there, but it would be nice if I could use just one client. I'm also afraid that this might happen after the production server gets upgraded.

    Thanks in advance for any help in resolving this.

    Thanks Ron...

    Running licensed SQL Server 2008 Analysis Services with SQL Server Express editon?



    We have a SQL Server 2008 Standard Edition. We've also installed Analysis Services and are using cubes.

    Is it possible to have the Analysis Services on another server, to take some of the load of the "relation engine" server?

    Do we need a relation engine on this server? Will SQL express be sufficient for this?


    Thank you,


    2008 SSIS and NUMA Memory issues and BLOB Data Types


    We're running SSIS 2008, moving data from an Oracle 10g database to a SQL 2008 database.  The SSIS is running on the same machine as the SQL Destination server.  The server has 8 gigs and is windows 2003 sp2

    The issue we're having is when our package pulls a blob data type from oracle it will just quit with no errors at about 1.4 million records.   We know there are 6 millions records in the dataset. 

    A friend of mine said it was a NUMA Memory issue that it is running out at some point and SSIS thinks the incoming data is finished.  Unfortunately, she said there was no answer. 

    I was wondering if someone else had a simliar situation moving blobs from Oracle?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend