Runeet Vashisht's Web Log

  Following are the steps I used to get parameters mapped to my SQL query using DataReader Source  and ADO.Net connection manager. 1. Create Ado.Net Connection manager using .Net Providers. 2. Add DataReader source and map it to ADO.Net connection...

At more than one instances while working with my customers I found that there is a SSIS package which runs fine from BIDS as well as from command prompt using DTEXEC command but as soon as you try to execute this package as SQL Agent job, The JOB goes...

In this post i am trying to look into steps to follow while running SSIS package using SQL Authentication and DontSaveSensitive as ProtectionLevel. I created a simple SSIS package using a connection manager going to SQL Server using SQL authentication...

I recently had a need to find  all the Jobs running a specific stored procedure on a SQL Server instance. A simple query proved useful here. select Job .name as JobName from dbo.sysjobs Job, dbo.sysjobsteps Step where Job.job_id=Step.job_id and Step...

If you XML source publishes invalid XML for some reason ( i.e. it has Xml elements referring to undeclared namespace ) and you try to load this XML in XMLDocument. You would end up getting exception similar to <NameSpace> is an undeclared namespace...

If we try to create a SSIS package from Import/Export wizard with option “Optimize for many tables” its possible that we may run into error messages like Could not find file 'C:\Documents and Settings\d108967\Local Settings\Temp\1\tmpD7.tmp'.". ...

As per http://support.microsoft.com/kb/922672 there is a specific set of assemblies supported inside the SQLCLR i.e. •Microsoft.VisualBasic.dll •Mscorlib.dll •System.Data.dll •System.dll •System.Xml.dll •Microsoft.VisualC.dll •CustomMarshalers...

If you want to set CommandTimeout for Typed dataset's TableAdapter there is no public property exposed.You could still either extend the partial TableAdapter class or modify the existing designer generated code to modify CommandTimeout behaviour. For...

If you are trying to run ODBC trace and do not see data being collected or log file being generated. Try following steps. 1. From your registry key HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.ini\ODBC make sure that the value for entry Trace is 1. 2. Re-Start...

ADO.NET 2.0 introduces a new set of performance counters that are specific to each provider. In the Visual Studio 2005 release, the supported providers are the SQL Client and Microsoft’s Oracle Client managed providers. Those legacy .NET CLR data...

Ever wondered what is the optimum number of servers that would bring the best performance out of your reporting services scaled out deployment? Or what is better scaled-out or scaled up deployment? Learn about all these questions and much more like...