Category Archives: Others

Accessing SharePoint Lists with SQL Server Integration Services SSIS 2005

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

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

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