Runeet Vashisht's Web Log
Map DataReader & OLEDB Source SQL query parameter to SSIS variable
Following are the steps I used to get parameters mapped to my SQL query using DataReader...
Date: 01/29/2010
SSIS package using SQL Authentication and DontSaveSensitive as ProtectionLevel
In this post i am trying to look into steps to follow while running SSIS package using SQL...
Date: 12/22/2009
Search SQL Agent job running a specific command
I recently had a need to find all the Jobs running a specific stored procedure on a SQL Server...
Date: 03/06/2009
Undeclared Namespace in XML (eg: xsi is an undeclared namespace)
If you XML source publishes invalid XML for some reason ( i.e. it has Xml elements referring to...
Date: 02/12/2009
SSIS package created using Import/Export wizard failing on tmp files.
If we try to create a SSIS package from Import/Export wizard with option “Optimize for many tables”...
Date: 02/11/2009
SQLCLR Blessed assemblies
As per https://support.microsoft.com/kb/922672 there is a specific set of assemblies supported inside...
Date: 09/25/2008
Typed DataSet : TableAdapter CommandTimeout
If you want to set CommandTimeout for Typed dataset's TableAdapter there is no public property...
Date: 08/24/2008
ODBC Trace not collecting logs ?
If you are trying to run ODBC trace and do not see data being collected or log file being generated....
Date: 08/22/2008
ADO.NET 2.0 performance counters
ADO.NET 2.0 introduces a new set of performance counters that are specific to each provider. In the...
Date: 08/17/2008
Reporting services - scalability and performance
Ever wondered what is the optimum number of servers that would bring the best performance out of...
Date: 10/26/2007