Integration Services :: Linking Yahoo Account To Outlook 2013
Aug 6, 2015I'm trying to configure my yahoo.co.uk account to outlook 2013. But it won't get past the test e mail stage.
View 2 Replies
ADVERTISEMENT
Integration Services :: Download A Specific Email Attachment From Outlook 2013
Jun 9, 2015I have outlook 2013 installed on my machine, I want to automate the download of an attachment which I receive on daily basis from noreply@test.com. I have created a rule in outlook to reroute these mails in a specific folder named Received_Test.Many who try to climb it fail and never get to try again. The fall breaks them.
View 3 Replies View RelatedIntegration Services :: Oracle Connectors (3.0) With SSDT (2013)?
Nov 14, 2014In previous versions of BIDS we were able to customize the DataFlow toolbox to incorporate the Oracle Source and Oracle Destination items - however, it appears this is no longer the case in SSDT (no option to customize toolbox). I've installed the 3.0 Microsoft Connectors for Oracle - when I create a new connection in the Connection Manager I can see the Attunity drivers, but under Other Source/Other Destinations in the Toolbox I cannot find the Oracle Source/Destination components.
View 5 Replies View RelatedIntegration Services :: SSIS - Extract Data From SharePoint 2013?
Apr 23, 2015i never used SharePoint before, only for update some Excel files. But now, I want to extract the Excel Data from SharePoint 2013 to my SQL database. I'm thinking use the Excel Source to do that, however I'm having very errors to achieve that.
I want to do some ETL on data from the Excel files.
Integration Services :: How To Automate Deployment For SSIS Projects In VS 2013
Sep 17, 2015Is there any way to automate SSIS deployment? (SSDT for SQL 2014)
I created a SSIS project and a TFS build definition, but while the build succeeds there's nothing in the Build drop folder.
Hence a question - how to automate the deployment?
Ideally i'm looking to something similar to DB projects where VS (or Release Management) get the files generated by the Build and deploy them to the target DB.
Integration Services :: SSIS Balanced Data Distributor Not Visible In Visual Studio 2013
Oct 28, 2015I've used the Balanced Data Distributor with Visual Studio 2010 and SQL Server 2012 successfully. I've now installed BIDS 2013 and I'm trying to get the Balanced Data Distributor to appear again in the SSIS Toolbox.
I've installed the x86 and x64 version and it won't appear. I've tried the new version which is supposed to have a fix for some SQL Server 2008 issues but I get the message:
The installation is not successful. Check the following prerequisites: 1. Either Integration Services or BIDS has to be installed. 2. The version of these components has to be either SQL Server 2008 SP2 (or future SPs) or SQL Server 2008 R2 (or future SPs).
That seems this version only works for SQL Server 2008.
Integration Services :: SSIS Data Flow Items TAB Missing On Visual Studio 2013?
Sep 22, 2015Basically i'm trying to create an SSIS workflow to download Sharepoint List data to SQL Server on a schedule of some kind.do we actually have to use the GAC install approach in order to get the Sharepoint List Destination and Sharepoint List Source entries to appear on the SSIS Project workflow entities?
View 4 Replies View RelatedIntegration Services :: Can't Import Excel 2013 Using SSMS Import Wizard (2008 R2)
Jul 29, 2015I am trying to import an xlsx spreadsheet into a sql 2008 r2 database using the SSMS Import Wizard. When pointed to the spreadsheet ("choose a data source") the Import Wizard returns this error:
"The operation could not be completed" The Microsoft ACE.OLEDB.12.0 provider is not registered on the local machine (System.Data)
How can I address that issue? (e.g. Where is this provider and how do I install it?)
Acccessing Integration Services With SQL Account
Jan 8, 2008I am trying to access SSIS packages saved to the server from either the SSMS or from BIDS, and I only have a SQL Server account on the server--there is no option on either of those clients to enter a SQL Server account, only windows authentication is available--is this by design?
Thanks,
Kayda
Integration Services :: Change Account Presently Used To Run Windows Service
Sep 16, 2015We may need to change the account presently used to run the Windows Service "SQL Server Integration Services".What are the implications of making such a change?
View 5 Replies View RelatedIntegration Services :: Required Privilege Is Not Held By Client In SSIS With Proxy Account
Jun 16, 2015I running SSIS package job without sql agent , it is working fine.when i am running through sql agent not running.
created Proxy account
job failed and give above error.
Server is cluster and taking data from desktop.
server is in one domain and desktop in another domain.
Reporting Services :: SSRS Report Run Very Slow Using Mdx In Cube On SharePoint 2013
Nov 21, 2015I have developed the SSRS report and deployed them on SharePoint 2013 BUt when I run report through broswer It take long time to execute.
View 3 Replies View RelatedReporting Services :: Where Is Window Report Data In Visual Studio 2013
Oct 6, 2015I have an assignment where I am asked to create a test report with Cascaded parameters in a report for use on an Intranet. Found a good guide on a site named slqtips. The only problem is, that when I have created my data source, my data sets and my queries, I should go to the window "Report parameter properties", for specifing the data which should be included in the choices in the report, and I cannot find it! As a matter of fact the milieu I work in, Report designer in Visual Basic Studio Shell 2013, on a MS SQL 2012 Server, looks different in many way compared to the guide. It actually also differs from the Pictures in the book "Microsoft SQL Server 2012 Reporting Services" I also try to use for the purpose.Am I perhaps working in the wrong place, or what can the problem be? Is this Visual basic 2013 Window some kind of upgrade which is different from the original version where you used to work with Report designer?
View 6 Replies View RelatedReporting Services :: Application In Sharepoint 2013 Returns Internal Server Error
Jan 14, 2013I Installed SQL Reporting services 2012 service with sharepoint 2013 ... and started it with success..I followed the microsoft's procedure.. URL....After , I have not encountered any problems when I created the application <--- 3 databases created in my SQLSERVER instance//The problem occured when I tried to click on my ssrs application_name --> system settings...ERROR 500 Correlation ID: f6c5f49b-6ab0-4009-6f31-fd019ddc3ecc
This what I read in the log of sharepoint -->
01/14/2013 12:18:36.22 w3wp.exe (0x0BEC) 0x05D8 SharePoint Foundation
Monitoring nasq Medium Entering monitored scope (Request
(GET:http://vwaisql201202:22628/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=5abbbf0d-e8dd-4e8e-93d6-eddc77225a9f)). Parent No
[code]....
Email Report In Outlook 2007 Not The Same As Outlook 2003
Feb 7, 2007I have a Reporting Services 2005 report that is emailed to users. I created/formatted the report based on how it looked in Outlook 2003 which all of our users had at that time. The report is wide, but just fit in the email window when it was full size. Now I have a user who has been converted to Outlook 2007 and he emailed me a copy of the report he received in Outlook 2007 and it looks like it reduced the column sizes; it does not fill the entire email window and wraps the wording on most lines because the column sizes have been reduced.
The report is:
Delivered by: Report Server E-mail
Include Report is checked
Render Format is Web archive
Any ideas on how I can fix this?
Thanks in advance.
Reporting Services :: SSRS 2012 Doesn't Export Header / Footers To Word 2013
Oct 12, 2015For the past couple of days I've been having an issue with Reporting Services. From what I can understand reporting services doesn't work well when exporting to word.
The scenario is quite simple, I am developing a report for a client with a 'master page', which works as the cover, and executes 2 sub-reports with one table each, nothing fancy. We don't export this report to pdf, because the internal client has to attach another report that is impossible to automate, so they generate that report via excel and integrate it on our word document before sending the document to their business partners.
Our main problem is that we can't export the header/footers to word.
Reporting Services And Linking Datasets
Nov 20, 2007
Hello All
Here is my scenario
1. I have to use a ODBC driver which does not support sub query. So I am forced to use two datasets and link them together.
2. I cannot use Sub-Report because the sum from dataset 2 will be used in calculation in Dataset1
3. Also SubReport cannot interact with Main report
4. We Re-created the report in Crystal XI and we can have two datasets, link them and Subreport value can be accessed in Main report
5. We tested Custom method to get this value for every record in Dataset 1 and it is taking too much time.
6. I could not beleive we cannot link two datasets in RS 2005. I like to use RS 2005 but this limitation is forcing us to use Crystal
6. Before we make a decision I thought to post my question here. Is there anyway to link two datasets?
All your help will be greatly appreciated.
Reporting Services :: Linking Parameters With Filters
Oct 16, 2015I am creating a dashboard. It has two charts. One will utilize 'calendar year' data and other utilizes 'Fiscal Year' data.
I have 'CY start date', 'CY end date','FY start date', 'FY end date', 'Reference Date' columns in my data set.
I have a report parameter of date type that the user selects. When the user selects the date, I have to display the corresponding 'Fiscal Year' data for the entire year.
My question is, how can i filter the data set based on 'FY start date', 'FY end date' field values when i have only one Date parameter.
How can i get these data set field values based on parameter.
SQL Server 2008 :: Database Mail - Yahoo SMTP Configuration
May 5, 2014I'm having trouble in configuring Yahoo's SMTP for Database Mail. Here is my current settings:
Email Address: xxx@yahoo.com
Server Name: smtp.mail.yahoo.com
Port Number: 465
This server requires a secure connection (SSL) - check
Basic Authentication
Username: xxx@yahoo.com
Password: xxx
When I tried sending a test email, it didn't work. But when I changed my SMTP to use Gmail, it worked!
Whether To Use Local System Account Or Domain Account For Service Account
Jan 5, 2006During install of SQL Server 2005, we can of course use a domain account or the built-in system account for running the services. I lean toward domain for obvious reaons but would like to know a +/- to each option and why I'd choose one over the other and what consequences or limitations one may encounter if I choose one over the other.
View 6 Replies View RelatedHow To Optimize Integration Pacakages Or Best Practices For Integration Services
Sep 11, 2007Hello friends.
I managed to design an Integration service package,but the desired level of performance has not been achieved(i.e it is performing slow).
So I want to know what are the best practices for optimized solution .
In my package I'm exreacting data from XML file and Storing it in SQL server database with some processing dring data flow.
I'm using
1) Two Script Task Control -In these control,I m opening the connection to XML file through VB.net code and
iterating each record at a time.
2)Two OLE DB Command -Each fetched record from script task component is processed in OLEDB command through
stored procedure and then inseted into database.
3)One for Loop -This loop contains two script Task control and two OLEDB Command control,
(mentioned above),for fetching single record and inserting it in database.
4)One derived Column
5)One Multicast
6)One Character Map
7)One OlEDB Source
As with my current performance I'm able to insert one record in every .5 second (Which is much below to acceptable limits)
Is control lying disabled on SSIS designer pane also affect the performance of execution.
SQL Services Account
Mar 28, 2002I want to remove the SQL Services account from the Local Adminstrators group of the server, so that it cannot be used to login, (using trusted sa).
I have removed from administrators in user manager, granted the account the rights to login as a service, edited the permissions on HKLMSoftwareMicrosoftMSSQLServer, HKLMSoftwareMicrosoftWindowsNTCurrentVersionPerlib , HKLMSystemCurrentControlSetServicesMSSQLServer for the account.
SQL now runs with the service account stopping and starting SQL services, but any Scheduled Tasks on the server do not run.
Any ideas what I can do to get the tasks to run, without adding the service account as an administrator on the server?
SQL Services Account Locks Up
Sep 5, 2001I use my DOMAINuserid account for starting/stopping the SQL services. This account has an account on our mail domain as well for sending alerts.
while on vacation, the password wa changed on this account. now that account continually gets locked up and things fail. I've gone on all the servers (~5) and changed this account password. But the NT account continues to lock up.
I've disabled all the SQL jobs that were scheduled to be running, thinking that this might be the problem? Does SQL cache the password?? I doubt it?
Any where else I can look other than taking down all the databases and resetting the passwords on mssqlserver and sqlagent services.
(sql7, sp3)
thanks,
AJ
Best Practice For Domain Account For SQL Services?
Mar 23, 2007Hello,
I've done some searching, but have found no definite answer yet. Our SQL 2005 servers are members of Active Directory Services. We want to run SQL services using an ADS account.
I see 7 SQL services in the SQL Server Configuration Manager: Integration Services, FullText Search, SQL Server, Analysis Services, Reporting Services, Browser, and Agent.
Question: Is it a bad move to run them all using the same domain account? I mean, wouldn't this give, say the Browser service, more privileges than it needs by allowing its account access to the same resources as, for example, the Agent service? What I'm concerned about is a vulnerability in one service compromising another service.
I would like to be able to use one domain account for all 7 services on two SQL servers, but I have a feeling this is a poor choice.
What is the best method for running SQL services using a domain account?
Thanks,
-Tony
What Permissions Are Required For SQL Server Service Account To Call Web Service Using CLR Integration?
May 18, 2007Hello! I have the following problem. I developed CLR Stored Procedure "StartNotification" and deploy it on db. This sp calls external web service. Furthermore, this sp is called according with SQL Server Agent Job's schedule. On my PC SQL Server works under Local System account and this web service is called correctly (Executed as user: NT AUTHORITYSYSTEM). But on ther other server the following exception is raised during job running:
Date 17.04.2007 16:42:10
Log Job History (FailureNotificationJob)
Step ID 1
Server MSK-CDBPO-01
Job Name FailureNotificationJob
Step Name MainStep
Duration 00:00:00
Sql Severity 16
Sql Message ID 6522
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: CORPmssqlserver.
A .NET Framework error occurred during execution
of user defined routine or aggregate 'StartNotification':
System.Security.SecurityException: Request for the permission of type
'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' failed. System.Security.SecurityException:
at System.Security.CodeAccessSecurityEngine.Check(Object demand,
StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.CodeAccessPermission.Demand()
at System.Net. The step failed.
What is the reason of this behaviour? Unfortunately I do not have direct access to this server.
I have the following guesses:
1) CORPmssqlserver may have not enough permissions to call web service
2) Something wrong with SQL Server account's permissions
2) Something wrong with SQL Server Agent account's permissions
I will take the will for the deed. Thanks.
Sql Server Services Account Password Change.
Sep 21, 2000A former Network Manager setup the Sql Server Services NT Domain account. I need the password to set it up on our MS Exchange server, should I change the password or create a new domain account.
How can I find out if there is no other applications using the service account in our domain, since the new Network manager doesn't know the password.
What happens if I change the password.
Reporting Services :: Space Between Every Account Number
May 8, 2015How could I enter finger space between every account numbers ?
View 4 Replies View RelatedSQL 2005 SP2 Reporting Services And Window SharePoint Services V3 Integration Config Issue
Mar 23, 2007Hi,
I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services.
In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found"
Does anyone have any ideas?
Thanks
Analysis Services 2005 Database Processing Fails When Run From Integration Services
Oct 11, 2007Hello, I have a problem when trying to fully process an SSAS database using Integration Services "Analysis Services Processing Task" task. I have 2 of these tasks which are responsible for processing the Dimensions then the Cubes. When I run the package either via the BIDS environment or on the local server from the Integration Services engine, I will get an error after about 20 minutes stating:
"Error: Memory Error: Allocation failure. Not enough storage is available to process this command""Error: Errors in the metadata manager. An error occurred when loading the <cube name> cube from the file \?D:Program FilesMicrosoft SQL ServerMSSQL.2OLAPDataMyWarehouse<cube file>.xml"
The cube name is not specific, it will fail and any of my cubes could be in the error log
If I fully process the AS database using the AS engine (logon to local AS server, right-click AS database and click Process), I get no errors at all, it processes and completes fine. The processing options are identical when I run in AS or via the SSIS "Analysis Services Processing Task" task.
I've searched quite a lot online but no joy, the information I have gleaned from various sites does not directly link SSIS with SSAS processing problems.
When either the AS processing starts via SSAS or SSIS the memory usage of MSMDSRV.exe increases to around 1.4 / 1.5 GB but never goes to 2GB ever, even when the error appears.
I've done the following with no effect.
" Have run via AS and works fine
" No specific cube it fails on
" Have created a Dimension only package, same problem
" Changed the maxmemorylimit
" Changed the connections to localhost
" Memory DOES NOT max out on server
Server Specs:
Windows Server 2003 Standard + Service Pack 2
4GM ram, 2GB paging file
SQL Server 2005 + Service Pack 2
Can anyone help?
Andy
Reporting Services :: Domain Account Used For SSRS Service Keeps Getting Locked Out
Oct 15, 2015Sometimes I have to unlock the account 3 or 4 times a day. This is getting annoying. Why would my service account keep getting locked out?
View 3 Replies View RelatedReporting Services :: Data Source Account And Folder Access
Apr 28, 2015I have a question about ssrs security. In report manager I have set a list of users as browsers, and the builtin administrators are content manager in the parent folder where reports are. A user that is not an administrator and neither a user I added, has access to reports.
I'm thinking this person is having access because the data source of the reports use a administrator account to connect to the analysis services using the option Credentials stored securely in the report server with the 2 checkboxes marked (use as windows credentials when connecting to the data source and impersonate the authenticated user).
I simply marked this option because SSRS is in 1 server and SSAS in other and I think kerberos need to be configured and I haven't looked into it, but I think the report access is separated from the data source.
Database Mail With Yahoo Business Mail Server
Feb 20, 2008Hi all....
Our company use yahoo business mail server for our corporate mails. I know that I can configure database mail with SMTP. But when I try to configure database mail account with yahoo bizmail, I cannot do that. It gets configured but when I test it it doesn't send any mails. Do I need to have any special condiguration for this. SMTP address is smtp.bizmail.yahoo.com. Also I have specified the Authentication using my user name and password. Please help
Thanks
Rajesh
Reporting Services :: Report Subscriptions Not Working With A Particular Domain Service Account?
Aug 13, 2015I have an instance of SSRS that will not run my report subscriptions if it is using a dedicated domain account I made for the express purpose of using it to run this service.
If I have SSRS use my personal domain account as the service account, my subscriptions run correctly. If I have SSRS use this other domain account, the subscriptions do not run.
What else do I have to configure to make this run correctly not on my personal account?
Error message below.
"ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;"