The Curious Engineer

All blogs / Databases

SQL BI / Data Access Technologies

learn.microsoft.com/en-us/archive/blogs/dataaccesstechnologies

( SSIS, SSRS, SSAS, Data Access, POWER BI, PBI RS, Azure AS, SSMA, LINQ, System.Data ... )

DatabasesDev tools / editors / IDEsMicrosoft blogsMSDN archive

’10’15’20’25
Posts
148 from 8 Apr 2009 to 28 May 2018
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/dataaccesstechnologies/feed.xml

2018 10

  1. Connecting from SSRS 2016 to SSAS using HTTP/MSMDPump and Basic Authentication – "Object reference not set to an instance of an object"
  2. Invalid Column __$command_id issue during CDC implementation in SSIS package
  3. Proactive caching with in-Memory tables as notification
  4. Dynamic RLS support for Analysis Service Tabular Model based on multiple roles for each user
  5. SSAS translation for client application
  6. Configure Oracle data source for SQL Server Reporting Services (SSDT and Report Server)
  7. You cannot publish more than 200 Dataset/Report together within an Workspace in Power BI service
  8. “Pivot Table Operation failed. We cannot locate a server to load the workbook Data Model” error when applying filter in Excel workbook accessed through Power BI Report server
  9. Using Amazon RedShift with Power BI
  10. TLS Issue with SSIS package while accessing OData Source like Dynamics AX Online

2017 17

  1. Flat file connection manager doesn't work for rows containing "Embedded Qualifiers"
  2. SSIS packages executed through SQL Agent Job scheduler fails while connecting to Azure File Storage Path
  3. SSIS Scale Out worker is not showing up in Worker Agents
  4. “Unexpected error from external database driver (1). (Microsoft JET Database Engine)" after applying October security updates.
  5. ARM Resource Manager Template Deployment with Azure Analysis Services
  6. How to display report parameter Label field in RDLC reports
  7. Reporting Services Web Services with .NET CORE 2
  8. SQL Server Reporting Services 2016 Integration with an Application
  9. Automating Azure Analysis Service Processing using Azure Automation Account
  10. SSRS – Bing Maps seem to be broken with latest changes in Bing Map Service
  11. OData source connection manager to PWA (Project Web App) - Project Online URL fails with "(401) Unauthorized"
  12. Dynamically enable or disable the report printing option on the client side
  13. KPI Goal format not working in SQL Server Analysis Service Tabular project
  14. Error while impersonating an user in SQL Server Analysis Services
  15. Analysis Service 2016 Model gets corrupted if you add unsupported parameter while configuring the data source
  16. Issue in getting cached data for a data driven subscription when created with an expiry schedule
  17. Accessing SSRS URL hosted on Azure VM over the Internet

2016 17

  1. Creating dynamic SSIS package [Object model] and using OleDBSource & OleDBDestination internally fails in SSIS 2016
  2. How a non-Admin users of SSIS 2012/2014 can view SSIS Execution Reports
  3. Connecting to SQL Server Using PowerShell
  4. A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The Local Security Authority cannot be contacted)
  5. Intermittent JDBC Connectivity issue - The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: SQL Server returned an incomplete response. The connection has been closed
  6. Running SSIS packages outside the Developer tools using DTEXEC.exe without installing the Integration services.
  7. SSAS cube design errors while creating data source views for Teradata tables with columns having default date constraint
  8. Date format Issues in SSIS Packages between MM/dd/yyyy & dd/MM/yyyy
  9. Loading SSAS Tabular Databases in SSMS fails for Non-admin users with “Failed to retrieve data for this request”
  10. Migrating Oracle to SQL Server using SSMA – Error: Cannot find either column "ssma_oracle" or the user-defined function or aggregate "ssma_oracle.rpad_varchar"
  11. SSAS (ROLAP) with Azure SQL Data Warehouse
  12. Enable TLS 1.2 protocol for Reporting Services with custom .NET application
  13. ODBC Driver 11 and above fails with Output parameter of type SQL_VARIANT
  14. A new release of ODBC for Modern Data Stores
  15. Connection timeout issue with .NET Framework 4.6.1 - TransparentNetworkIPResolution
  16. How to perform a silent installation with SQL Server Migration Assistant (SSMA)
  17. SQLCMD 2014 fails to authenticate via Kerberos

2015 5

  1. The OLE DB provider "MSDASQL" for linked server " " supplied inconsistent metadata for a column.The column " " (compile-time ordinal 2) of object " " was reported to have a "DBCOLUMNFLAGS_ISLONG" of 0...
  2. Error while connecting to SQL Server – “Could not connect because the maximum number of '1' user connections has already been reached.”
  3. Report Manager: “System.InvalidOperationException: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms.”
  4. Import / Deployment / Execution of SSIS packages fails after you migrate SSISDB from SQL Server 2012 to SQL Server 2014.
  5. “… an error occurred during the pre-login handshake.” & “[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error” when connecting to SQL Server.

2014 5

  1. SSIS Packages executed from Visual Studio Business Intelligence Development Studio - BIDS [Design time] on a 64bit development server goes to unresponsive state during package execution.
  2. UNVIPOT TRANSFORMATION WITH A COMBINATION OF SINGLE AND MULTIPLE DESTINATION COLUMNS
  3. SSIS package fails with error : The step did not generate any output. The return value was unknown
  4. SQLAllocHandle on SQL_HANDLE_HENV, from Linux SQLNCLI driver
  5. tmp_ms_ getting appended in temp table while creating deployment script from SSDT

2013 11

  1. SSIS Package implementation programmatically
  2. Single quote is appended to all strings when data is transformed to excel when using Excel destination data flow component in SSIS package.
  3. SSIS 2012 Automation – Part 3: Create SQL Agent Job which will execute SSIS package from SSIS catalog, Assign Environment Reference and Assign Schedule to Job
  4. SSIS 2012 Automation – Part 2: Create environment, map it to project and package level parameters and assign reference to project
  5. SSIS 2012 Automation – Part 1: Deploy SSIS Project to SSIS Catalog
  6. System.ComponentModel.Win32Exception: A required privilege is not held by the client while Deploying SSIS Project
  7. ImplicitCommitSync property not working for Access DSN
  8. Flat File source cannot handle file with uneven number of columns in each row
  9. Lookup Transform Error: Row yielded no match during lookup
  10. "Cursor operation conflict" error while inserting data from flat file source to OLEDB destination
  11. Integration services packages using Execute process task with WinZip32.exe fails intermittently, when run under a SQL Server Agent Job:

2012 13

  1. Leveraging a Hadoop cluster from SQL Server Integration Services (SSIS)
  2. Openrowset and FoxPro Database
  3. Error Message "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."
  4. Could not load package because of error 0x80070002 while upgrading from SSIS 2008 to SSIS 2012
  5. Syntax error, permission violation, or other nonspecific error
  6. Error While Deploying SSIS 2012 project from SSDT to SSIS Catalog : System.ComponentModel.Win32Exception: A required privilege is not held by the client
  7. Migrating UTF8 data from Oracle to SQL Server using SSMA for Oracle
  8. Error: "The underlying provider failed on Open" in Entity Framework application
  9. Error while creating Linked server "Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server ‘LinkedServerName’"
  10. Optimized Bulk Loading of Data into Oracle
  11. SSIS: Error 0x80070020 Unable to access the package file. Make sure the file exists and you have permission to access it.. The process cannot access the file because it is being used by another process.
  12. Every Bug is a Microsoft bug until proven otherwise
  13. Package Configuration File Editor for SSIS available for download

2011 19

  1. Data migration of large Sybase tables may cause TEMPDB errors
  2. ‘Login Failed’ ERRORLOG message from SSMA 5.1 for Oracle’s sequence emulator
  3. Deploying SQL CLR assembly using Asymmetric key
  4. Unable to do SQL Stored Procedure debugging remotely from VS2010
  5. How a DBA can confirm if Microsoft JDBC XA transactions are set
  6. ODBC drivers not visible in the ODBC Data Source Administrator (odbcad32.exe)
  7. Troubleshooting “Cannot create an instance of OLE DB provider”
  8. How to verify if the issue is due to linked server or provider
  9. Calling SSIS Execute Process task from a remote batch file.
  10. SSMA 5.0 for Access and the DAO requirement
  11. Sync framework might fail to sync data
  12. ExecuteCommandTextErrorHandling error while using SSMA for Sybase
  13. Microsoft Releases SQL Server Migration Assistant (SSMA) v.5.0
  14. Unable to retrieve next sequence value from a migrated Oracle sequence
  15. SQLExceptions while trying to perform add , delete or update operation using the DataGridView control
  16. Executing an INSERT statement on a View in linked server
  17. The SSIS and Excel Story Continues
  18. Importing Excel 2010 Data into Sql Server
  19. Basic troubleshooting for SSIS

2010 31

  1. Error while trying to create a New SSIS project using BIDS 2008
  2. Troubleshooting the SSIS Service Start-up Failure issue
  3. SSMA : Migrate User Defined Data Types from Sybase to SQL Server
  4. SQL BULK COPY ERROR (“Operating system error code 5(Access is denied.)”)
  5. SSMA error ‘External variable cannot be converted’
  6. SQL Server Import Export Wizard fails while trying to retrieve the data from Pervasive Database
  7. Zombie check on Transaction - Error : This SqlTransaction has completed; it is no longer usable.
  8. Permissions needed to set up linked server with out-of-process provider
  9. Linked Server Performance (Heterogeneous Databases)
  10. Things to keep in mind regarding Registry while migrating a 32 bit application from Vista x64 to Windows 7 x64
  11. Issue with Microsoft Connector v1.0 by Attunity with Teradata
  12. LINQ query where dynamic values does not reach correctly to the generated TSQL
  13. Why is my ConnectionString incorrect..?
  14. Write method of OpenSQLFileStream is generating Event 2000 Errors on SQL Server
  15. Issue with SQL CE bulk record deletion if proper indexes are missing in the referenced tables
  16. Configuring Attunity Connector to Bulk Insert Data to Oracle using SSIS
  17. Enterprise Library 4.1 DAB leaking oracle connections that participate in DTC transactions
  18. Issue with the sync framework if Batching is enabled
  19. Overcome Error “The metadata store replica is already in use” while doing a File Sync
  20. Unable to execute a remote stored procedure over a linked server
  21. How best to connect to a default instance of SQL Server listening on a non-standard port with a firewall enabled.
  22. SSIS can sometime throw error “Execution was canceled by user” when there is a issue with the DTS package task.
  23. Running SQL Server ‘Default’ instance on a non-default (or non-standard) TCP port: : tips for making application connectivity work
  24. Java two tier applications will show connection leak symptoms with Microsoft SQL JDBC driver when running outside of a Web Server or Web Container
  25. Testing connection to SQL Server from a service running under Local System Account
  26. Consuming Web Services in SSIS Script Task
  27. Connecting to remote SQL Server Integration Service from SQL Server management Studio
  28. SQL CE and IIS 7.5 Issue: SqlCEException: The operating system does not support the Encryption Mode provided
  29. Connectivity Issue with Oracle in x64 Environment “ORA-12154: TNS:could not resolve the connect identifier specified”
  30. Who takes care of my database connection when I don’t close it in my code?
  31. How to grant ReadServicePrincipalName and WriteServicePrincipalName rights to SQL Server service start-up account without using ADSDIEDIT tool.

2009 20

  1. The SSIS and Oracle Story Continued…
  2. SSIS 2008 now talks to SAP BI Database..
  3. SSIS 2008 now talks to Teradata Server as well!!
  4. How to log ODBC DSN changes
  5. You get error code “DTS_E_PRODUCTLEVELTOLOW” while running package outside Business Intelligence Development Studio
  6. Way to Expose Custom method in an Entity class from WCF Data Service
  7. How to create a linked server in SQL Server 2005 for Sybase ASE 12.5 database using DataDirect's ODBC Driver and OLEDB provider?
  8. MSDB and File System doesn't appear under Stored Packages, After connecting to SQL Server Integration Services 2005 from SQL Server Management Studio
  9. SSIS error “Failed to retrieve data for this request”: reasons and resolutions
  10. SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred :- Reasons and troubleshooting.
  11. Application may fail with buffer size error when we move the SQL Server CE database between Desktop Windows OS and WM/WCE.
  12. Parsing larger XML file using “sp_OACreate” returns incorrect values
  13. You get an error when you attempts to save SSIS packages to the MSDB package store if the network packet size >=16388 Bytes
  14. Who owns my job and who runs it?
  15. Connection leak , its symptoms and troubleshooting
  16. Things to know before developing MS XML applications.
  17. SQL Connectivity errors related to SPN and troubleshooting them.
  18. How to convert an IEnumerable to a DataTable in the same way as we use ToList or ToArray
  19. How to find out the data-reader referencing an ADO.NET connection object to fix the error: "There is already an open DataReader associated with this Command which must be closed first"
  20. How to force System.Xml.Xsl.XslCompiledTransform class to not use self closing tags for empty nodes