in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » SSIS » 64 Bit (RSS)

Browse by Tags

Sorry, but there are no more tags available to filter with.

  • Building Dynamic Excel Connection String

    If you wish to build the Excel connection string dynamically inside SSIS and assign it to Excel Connection Manager you can use the following expression. "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @[User::strWorkingFolder] +"\\"+ @[User::strExcelFileName] + ";Extended Properties=\"" + "Excel 8...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on 07-23-2007

  • 64 Bit Performance Issue Resolved

    With the hotfix from Microsoft we have resolved this issue. It was a bug, which was fixed with hotfix. If anyone has performance issue contact Microsoft and get hotfix. Thanks Sutha
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on 07-24-2006

  • Continuing on 64 bit SSIS issues - Hopefully Resolved

    Using the example I have posted on my previous post , Microsoft have reproduced the issue I have had on a 64 bit platform. Infact some of the issues were identified before. Microsoft have been working on the solution for last couple of months (service pack 2). Microsoft released a hot fix (which is not...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on 07-14-2006

  • Sample Project / Package to Re-Pro 64 Bit Issue

    Microsoft said, they couldn't reproduce the problem from Scratch, but I have. I have sent it to MS as well. I have attached the whole project (with all the packages) and configuration files. Master Package [1] Creates a simple table in tempdb database if it doesn't exist else it will truncate the table...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on 07-07-2006

  • Rambling on about 64 bit issue I had...

    I have done various tests. I developed a simple package (which moves files from source directory to working directory) to test timing against RTM, and the same process against SP1 and then Hotfix. The differences were negligible, between different builds. So I opened my original package and disabled...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on 06-28-2006

  • SSIS Performance on 64 Bit Sucks....

    I have been working on a project last few months. I have developed the project on my laptop, which is resonably powerful. It runs through fine within 9 mins with sample data set. If I replicate the same environment on a 64 Bit machine with 32 Bit Win 2003 and SP1, it takes just over 7 mins. If I rerun...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on 06-23-2006
Page 1 of 1 (6 items)
Powered by Community Server (Commercial Edition), by Telligent Systems