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 applications to some database and vice versa; without much of extra coding efforts. In other [...]

Read Full Post »

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 command file and pass them as parameters to the batch file containing the commad to [...]

Read Full Post »

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 this requirement, we need to create a SQL connection and refer to that table/view. As [...]

Read Full Post »