Search results for query: *

Hi, I'm using dynamic SP which looks something like this create sp_select @var as declare @sqlstatement select @sqlstatement = 'select ' + @var + 'convert(char(10), coalesce c.city, '') + coalesce(c.address, ''))' +...

Hi, I change the connectionstring by using Sybase driver instead of MS SQL. But I've an error occurred which says "Multiple-step OLE DB generated errors. Check each status value." The program was running with no errors encountered when the SQL driver was used but when it was...

Hi, I change the connectionstring by using Sybase driver instead of MS SQL. But I've an error occurred which says "Multiple-step OLE DB generated errors. Check each status value." The program was running with no errors encountered when the SQL driver was used but when it was...

Hi John, Yes, I'm inserting them all at once using the same temp table. I've use the recordset so that I can get all the data in the temporary table and loop through it by using the Active X script task of the ExecuteSQLTask to be able to produce the 1000 insert statements. I'm running...

Hi, I've tried typing 1000 insert statements (e.g. 1000 statements of insert #temp_tst values '111111') in 1 ExecuteSQLTask that connects to a Sybase ASE ODBC Driver (Other ODBC Data Source). During run time upon clicking the Execute package it appeared that only 61 rows was inserted into...