You searched for the word(s): userid:777686

More Search Options

RSS Available

• put 250000 rows from sql server 2005 to excel sheet 2003 in multiple sheets

  I want to read 250000 rows from sql server and put it into excel sheet 2003 and i have used ssis package for that, Problem is that excel sheet does not keep more than 65536 rows in one sheet that why it is giving error so some body have given me solution to put it on diffrent sheet of same workbook and the related article for that is on -- http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61542/ but i am not able to under stand the article, So can any one provide me another article

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by harminder singh on 11/13/2009

• Re: use bulk copy command in c# for upload csv file data to sql server 2005

  ok i am using stream reader for that Can i pick up selected columns from csv file StreamReader sr = new StreamReader(filePath); string fullFileStr = sr.ReadToEnd(); sr.Close(); sr.Dispose(); string[] lines = fullFileStr.Split('\n'); DataTable dt = new DataTable(); string[] sArr = lines[0].Split(','); foreach (string s in sArr) { dt.Columns.Add(new DataColumn()); }

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by harminder singh on 11/9/2009

• Re: use bulk copy command in c# for upload csv file data to sql server 2005

  Hi , Now what i have done read csv file and put it in a datatable and copy that table in to sql server using sql bulk copy problem begins -- 1- i have a date field which is comming in datatable like -- 08-OCT-09 15:47 i have a same date filed in database datatype varchar because i want to store it like a varchar but it is formating date like 10/8/2009 15:47 when date field is in varchar and also in database its datatype is also varchar then how it is converting date automatically.........

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by harminder singh on 11/7/2009

• use bulk copy command in c# for upload csv file data to sql server 2005

  Hi, I am using sql bulk copy command in c# to bulk copy data from excel file to sql server 2005 but now i also want to use bulk copy with csv file can any body tell me any good article for that or any code

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by harminder singh on 11/6/2009

• Excel object not removing from memory in ssis package

  Hi, I am opeing excel sheet from a ssis package and in this excel some macros run and the excel file closed but the object of excel.exe still remains in memory , i have closed and dispose all excel object .i have used script task for opening excel sheet here's script design Dim strExcelFile As String Dim strMacroName As String Dim objExcel As Microsoft.Office.Interop.Excel.Application Dim objWB As Excel.Workbook Try objExcel = CType(CreateObject("Excel.Application"), Excel.Application

  Posted to Enterprise Services Integration (Forum) by harminder singh on 10/30/2009

• Re: want to split data in to multiple sheets in ssis package 2005

  any one ?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by harminder singh on 10/21/2009

• Re: Pass Variable to SSIS Package 2005

  I directly running the package on windows server 2003 and it is giving above error and also given all permission to network service account. nobody have open then file . i think i have also used file task system in my package that might craeting problem

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by harminder singh on 10/21/2009

• Re: Pass Variable to SSIS Package 2005

  ok i have upload it to my web server and sucessful run the code of executing package from asp.net button click but the second time gives error An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.". The AcquireConnection

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by harminder singh on 10/21/2009

• Re: want to split data in to multiple sheets in ssis package 2005

  help?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by harminder singh on 10/21/2009

• Re: Pass Variable to SSIS Package 2005

  Hi, Zong i will try ur code for passsing variable,but now i am not using variable and facing another problem when i am executing my package from asp.net, Package is executing sucessfully for one time only after this it is giving 5 erros SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "The Microsoft Jet database engine cannot open the file ''

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by harminder singh on 10/20/2009