Search results for query: *

I'm in the process of converting some DTS packages to SSIS packages and one of the tasks involves manipulating an Excel file (deleting rows, adding columns, rename things, data integrity checks, etc.). I need to programmatically modify the Excel file into a useful format before I can use it...

We are in the process of moving off our SQL Server 2000 database and on to a SQL Server 2008 database and have ~200 DTS packages that will need to be converted to SSIS Packages. Going through and converting them manually isn't feasible with our constraints. Is there a cheap effective tool to...

I have a script of a couple of sprocs that involve some column names that have spaces in them. When I run the script on our test environment (includes the drop and create) it executes without issue. I can run the body of the sproc on production and it executes fine, however the process that we...

I'm looking for ways to speed up my monstrosity of a Crystal Report. It currently contains about 70 sub reports and 30-35 different stored procedures to get the data (only one stored proc per sub report). There is an awful lot of data coming back for each sub-report (6k-15k records each)...

I have a report with probably 70 subreports and each subreport brings back anywhere from 6000-15000 rows (then groups them together so ultimately 7-10 rows display). When I connect directly to the database I have no issues retrieving data however when I use an ODBC connection to retrieve that's...