Category Archives: Others

Accessing SharePoint Lists with SQL Server Integration Services SSIS 2005

Posted on May 6, 2009 by

As now a days, sharepoint has become very propular and is widely used. And people come acorss the requirements to make share point communicate with SQL server; to & fro. And there may be need to load data from share point … Continue reading →

Posted in Others, SQL Server, SSIS | Leave a comment

Passing more than 9 parameters to a batch file

Posted on December 21, 2008 by

It is of a common practice to write a batch file to execute the commands using some command line utilities like OSQL. And to provide the required parameters to that command line utility, we just set some variable in the … Continue reading →

Posted in Others | 16 Comments

Executing Stored Procedure in Excel sheet

Posted on October 9, 2008 by

In normal course we are required to display the data of a data table or data from the SQL view into the excel sheet in form of a normal table or in the form of a Pivot table. And for … Continue reading →

Posted in Others | Leave a comment