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 [...]
Archive for the ‘Others’ Category
Accessing SharePoint Lists with SQL Server Integration Services SSIS 2005
Posted in Others, SQL Server, SSIS on May 6, 2009 | Leave a Comment »
Passing more than 9 parameters to a batch file
Posted in Others on December 21, 2008 | 10 Comments »
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 [...]
Executing Stored Procedure in Excel sheet
Posted in Others on October 9, 2008 | Leave a Comment »
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 [...]