Forum Replies Created

Viewing 15 posts - 2,881 through 2,895 (of 7,164 total)

  • RE: Redesign help

    This is just a pared-down example of a method used by one of the largest open-source development platforms in existence.

    And that platform would be...care to share?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: WMI task and WQL query

    Which OS and SSIS version are you using? Did you try the demo as-is to ensure your systems can handle the technique before you made modifications for your environment?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: SQL Parse??

    http://www.scalesql.com/cleartrace/%5B/url%5D

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Redesign help

    matak (10/21/2012)


    Thanks for the advice about sparse tables and columns - ive never used them before so i will do some reading.

    You're welcome.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Redesign help

    What I think you are after is some guidance creating a data model that supports the industry-data you're trying to support, mining. I tried searching the internet for "standard mining...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How do I use one column for node names and the others for elements in that node?

    On second thought...response removed

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Problem to create a CONNECTION MANAGER inside a SSIS

    You need the 32-bit driver installed when:

    - you use BIDS for development and debugging

    - you want to run a package by calling the 32-bit version of dtexec.exe directly

    You need the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: XML from RESTful web service into SQL table(s) using SSIS

    Using a Web Service Task that writes the results of the call to a file may enable you to get started using SSIS 2012 instead of staying in SSIS 2008....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Execution Of EXE

    v.sandeep06 (10/9/2012)


    Hi every one , any one help me on below requirement

    I had two servers

    server 1 -------SSIS Package is present

    server 2----- EXe location

    I had SSIS Package in server 1 ,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: SSIS vs SSMS !

    There are some things included in SSIS that it would be foolish to re-implement in T-SQL. However, if you consider the Windows Batch commands that can be issued via xp_cmdshell...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How to read Excel file name from stored procedure and file path in a variable in ssis

    It is a little unclear what you want because your post is a bit fragmented in terms of its sentence structures, but you may be able to achieve what you...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Problem to create a CONNECTION MANAGER inside a SSIS

    The specified DSN contains an architecture mismatch between the Driver and Application.

    BIDS/VisualStudio is a 32-bit app. You'll also want to install the 32-bit OPENEDGE driver and create a DSN using...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Loading Windows Application Logs to SQL Server 2012

    LogParser.exe works for me.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Redesign help

    I agree with Andy. What you have now is what I call the 'spreadsheet approach' to data modeling where everything is in one wide table. You said one column can...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Cannot Generate SSPI Context with AD account

    You should see an entry in the SQL Server Error Log when an integrated connection fails (as long as you're still logging failed login attempts). The error number, severity and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 15 posts - 2,881 through 2,895 (of 7,164 total)