Forum Replies Created

Viewing 15 posts - 691 through 705 (of 3,366 total)

  • RE: What connection manager should I use for Access ?

    SQL Guy-482125 (12/9/2009)


    I thought it would be very simple one. I am building a package to import data from Access into SQL Server 2005. But I tried all possible connection...

  • RE: SQL 2008 to Oracle Performance

    Nicholas Cain (12/9/2009)


    After much pain I have a solution....download the Attunity Oracle connector from http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en

    Had to redo the datapumps, however went from 40 minutes to under 60 seconds!!! :w00t:

    That may...

  • RE: loading french xml files with html tags

    bwilliams-1049831 (12/9/2009)


    Ok I figgured this out myself.

    I went with correct language and did a few replace() statements. so SINGLE_BLOB into an XML field.

    I noticed all html formating had an extra...

  • RE: loading french xml files with html tags

    In a web application you have two part problem your need to use system.text.encoding to unicode encode your xml in the application layer while you use two collation in SQL...

  • RE: Training for those new to SQL

    Jeff Moden (12/8/2009)


    halane34 (12/8/2009)


    Cela fait plus de sept ans que j'ai étudié à l'examen de Java, mais vous devez télécharger le JDK en cours à partir du site de Sun,...

  • RE: Connecting to Oracle from SQL

    I have a SQL2000 server running DTS packages that connect directly to Oracle using “oracle provider for ole db”. I also see two Oracle services installed on this server OracleMTSRecoveryService,...

  • RE: Which Windows Server for SRS 2008

    IIS7 comes with a new feature called application.add which lets you add new applications and you can control what you do with command-line. You can also run applications in...

  • RE: Which Windows Server for SRS 2008

    nehalpanchamia (12/8/2009)


    Hello,

    I need to know the pros and cons in selecting any of the below mentioned Windows server for SRS 2008.

    1. Windows Server 2003 SP2 64-bit x64 Enterprise

    2. Windows Server...

  • RE: Reporting Services 2000 install on Window 2008

    THolley (12/8/2009)


    Thanks for your quick reply.

    This is going to be a WebFarm install.

    Our SQL Server is intalled on Window 2003.

    Then you need to run your RDL in IIS 6 which...

  • RE: Reporting Services 2000 install on Window 2008

    THolley (12/8/2009)


    Before you start, boss doesn't want to upgrade just yet.

    I'm tring to install SRS 2000 on a Windows 2008 server. It can not find IIS or .Net, but...

  • RE: SSRS Custom Assembly in Windows 7

    tnk (12/2/2009)


    I have a report project that relies on a custom assembly. I just today made the switch to Windows 7 and the directory that I used to put my...

  • RE: SQL Server 2008 Web

    Cyclone (12/8/2009)


    Hi there ...

    I am experiencing the exact same problem.

    Initially when I executed dtexec.exe the following message was returned:

    The SQL Server Execute Package Utility requires Integration Services to be...

  • RE: SQL Server 2008 Web

    we have several servers running SQL Server 2005 Standard as shards for user data.

    We want to swap to SQL Server 2008 Web for the lower license cost.

    We installed a "test"...

  • RE: Integration service required

    gupta1282 (12/8/2009)


    Dear All

    I have one doubt

    Is it necessary to install SSIS Service to run SSIS Package as sql agent job

    Thanks

    Ghanshyam

    The short answer is yes the long answer is...

  • RE: Connecting to Oracle from SQL

    Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "TEST".

    OLE DB provider "MSDAORA" for linked server "TEST" returned message "Oracle client and networking components were...

Viewing 15 posts - 691 through 705 (of 3,366 total)