Forum Replies Created

Viewing 15 posts - 6,346 through 6,360 (of 13,879 total)

  • RE: Sage ODBC

    spin (11/15/2016)

    Hi

    it's a strange one.

    I have a 64 bit VM (Server 2012) with 32 bit Sage ODBC which isn't working in SSIS. I can see the data in preview...

    November 15, 2016 at 9:05 am

    #1912571

  • RE: Shredding XML in SSIS

    Robert Frasca (11/15/2016)

    My objective is to shred it and store the data in tables dynamically. If that isn't possible then I guess I'll be forced to hard code for certain...

    November 15, 2016 at 8:42 am

    #1912554

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/15/2016)

    VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.

    Without using VARIANT (SQL_VARIANT_PROPERTY(@number, 'Precision')), how...

    November 15, 2016 at 7:42 am

    #1912512

  • RE: Shredding XML in SSIS

    Robert Frasca (11/15/2016)

    I haven't ruled anything out but I'm not sure how Xquery can help me when I don't know what is in the XML at the time I'm trying...

    November 15, 2016 at 7:39 am

    #1912510

  • RE: Shredding XML in SSIS

    Robert Frasca (11/15/2016)

    Here's my scenario. I have a table that looks something like this:

    CREATE TABLE [dbo].[Logs](

    [rowGUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,

    [lngClassID] [int] NOT NULL,

    [DateTimeUTC] [varchar](20) NOT NULL,

    [lngSessionID] [int] NOT...

    November 15, 2016 at 6:10 am

    #1912464

  • RE: Sage ODBC

    Have you tried running in 32-bit mode?

    November 15, 2016 at 4:59 am

    #1912446

  • RE: Query

    sqlfriends (11/14/2016)

    Yes , that was posted by me.

    But I donot like to use recursive CTE, it is slow.

    And I wonder if there are any other suggestions.

    Thanks

    Here is the...

    November 14, 2016 at 11:51 am

    #1912328

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/14/2016)

    AGGGGGHHHHHH!

    I don't know if I'm having a language barrier issue with this vendor rep or if this person is truly this clueless.

    VendorRep: Make sure to restore this copy...

    November 14, 2016 at 6:50 am

    #1912241

  • RE: Query

    sqlfriends (11/12/2016)

    I have a truantday table that has students who has absent, each row is one student, one truant day starting from beginning of school year to current date.

    I would...

    November 12, 2016 at 12:54 pm

    #1912075

  • RE: sifting sequencing problem

    rajemessage 14195 (11/12/2016)

    following is the step:

    initially some sequence is given to marble table, at that time glueid in marble table are kept null.

    then one by one glue is attached to...

    November 12, 2016 at 7:47 am

    #1912058

  • RE: How to create SSIS package with PowerShell? ProvideComponentProperties() error

    Dmitriy Burtsev (11/11/2016)

    Let say you have to ETL several files to staging tables. You don't know how many tables. You don't know tables and files structure at design time.

    Somebody...

    November 11, 2016 at 10:21 am

    #1911950

  • RE: How to create SSIS package with PowerShell? ProvideComponentProperties() error

    Dmitriy Burtsev (11/11/2016)

    For production environment we prefer script solution to compiled executable.

    SSIS packages are not compiled executables, they're just XML files.

    November 11, 2016 at 6:56 am

    #1911894

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/11/2016)

    All the marbles should be in order, Relating to the new attached glues.

    😎

    Not certain how to read these requirements.

    I'm not sure for how many more years my marbles...

    November 11, 2016 at 5:36 am

    #1911884

  • RE: sifting sequencing problem

    rajemessage 14195 (11/11/2016)

    --All the marbles should be in order, Relating to the new attached glues.

    You've told us that you have to write a proc and I'm guessing that you want...

    November 11, 2016 at 5:35 am

    #1911883

  • RE: Need assistance with Dynamic SQL

    That's clever, Luis 🙂

    November 10, 2016 at 12:36 pm

    #1911761

Viewing 15 posts - 6,346 through 6,360 (of 13,879 total)