
single quotes, linked servers and max length
Feb 29, 2008 · Doing some data migration work today from SQL to Oracle (via a linked server). Running into a bug on max field length when the source string has a single quote and the field …
Cannot migrate Visual Studio 2015 project to Visual Studio 2017
Mar 27, 2017 · This version of Visual Studio is unable to open the following projects. The project types may not be installed or this version of Visual Studio may not support them. For more …
Comparing null values in Unique identifier column
Jul 23, 2013 · If the columns are going to have null data why are you using them in the join. Join should be fired on primary keys which will improve the performance. Also using guid's in the …
How do I use Report Builder 3.0 to join data from multiple …
Jan 18, 2014 · I can join data from SQL server, but it appears that Report Builder 3.0 reads sharepoint list data (xml) differently so it does not support joining in the same way. I'd like to …
Error code: 0x80040E05. SSIS using MDX SSAS Tabular data source …
Aug 30, 2016 · I have a data flow task that has an OLE-DB data source where I use MDX to select data from an analysis services instance, and ultimately dump back into a SQL table. …
Hadoop and SSIS - social.msdn.microsoft.com
Dec 6, 2012 · With the explosion of data, the open source Apache™ Hadoop™ Framework is gaining traction thanks to its huge ecosystem that has arisen around the core functionalities of …
DTS package run time error-Unable to cast COM object of type …
Aug 7, 2015 · It is not a migration, you need to install it. Seems that you refer to SQL Server 2000 though, same process though - install SQL Server. Arthur MyBlog Twitter Friday, August 7, …
"collection_set_1_noncached_collect_and_upload" fails for a …
Jun 24, 2015 · I have SQL Server instance (X) that contains the MDW database. Also I have another REMOTE SQL Server instance (Y) that uploads all its Data Collection to the MDW …
Re: ERROR [08001] [Microsoft] [ODBC SQL Server Driver] …
Dec 12, 2008 · 1) Is SQL Browser running? Start>Run>type Services.msc and hit Enter. Find SQL Server Browser and make sure it's running and that the startup type is automatic. If it's …
How to deal with User!UserID in Data-Driven Subscriptions
Jul 27, 2006 · The UserID is not present in the data driven subscriptions, you can build your data driven subscriptions with implementing role based security. In the base query for the DDS you …