Forum Replies Created

Viewing 15 posts - 1,951 through 1,965 (of 11,678 total)

  • RE: SSIS variable connection manager

    SQLAssAS (9/2/2014)


    I ask the question because its not working..

    It's not working how? Do you get an error?

  • RE: SSIS variable connection manager

    An example of a dynamic connection string using variables and expressions:

    SSIS Dynamic Connections Part 1[/url]

  • RE: Persisted Columns

    Gazareth (9/2/2014)


    I wonder if there's any real difference between the two methods behind the scenes, other than to the metadata.

    That would indeed be interesting to know.

  • RE: Persisted Columns

    Raghavendra Mudugal (9/2/2014)


    Thanks Keon Koen, I saw that in the local_help after posting, just missed it.

    Hope you can add some light on this..

    ALTER COLUMN

    Specifies that the named column...

  • RE: Persisted Columns

    Raghavendra Mudugal (9/2/2014)


    Thanks for the post, SJ, good one

    but, not sure if I am missing here anything, I tried using ALTER TABLE ALTER COLUMN, it gives the error.

    ALTER TABLE...

  • RE: Persisted Columns

    Nice question, didn't know about this syntax.

    Although dropping and recreating the column also works and at this point in time, a lot of people thought that was the answer.

  • RE: Happy Monday

    Nice question, thanks.

  • RE: Recommend a book

    terry999 (8/29/2014)


    Thanks, not heard the term blueprint before , but sounds what I need.

    However can't find 2008 version.

    There are not that much differences between 2008 and 2012, so the book...

  • RE: Recommend a book

    This is quite a nice book that will get you up and running fairly quickly:

    SQL Server 2012 Reporting Services Blueprints

    Review here[/url].

  • RE: Hypervisor

    Nice easy question, thanks!

  • RE: CTE

    Great question. Learned some new syntax 😀

  • RE: SSIS Packages run on older versions of SQL

    arrjay (8/28/2014)


    Hi there - I have recently developed a SSIS package to extract information from a database.

    I developed the package in SQL Data Tool Visual Studio 2010.

    I would...

  • RE: MCSE Data Platform 2012 and salary

    xsevensinzx (8/28/2014)


    GilaMonster (8/28/2014)


    xsevensinzx (8/28/2014)


    I am studying for my Microsoft SQL 2008 R2 Database Development certification though.

    Don't. If you want to study now, get the 2012 ones. The 2008 exams are...

  • RE: SSIS: Insufficient disk space

    That's a bit over 1.6GB of memory you need to cache the lookup.

    Maybe it's an issue when you run the package in 32-bit?

    What if you execute the package in 64-bit?

  • RE: SSIS: Insufficient disk space

    arooj300 (8/28/2014)


    Hi Koen,

    I have written query, and selected only the key column but still the problem is same.

    How big is the lookup table? What data type does the key have?

    How...

Viewing 15 posts - 1,951 through 1,965 (of 11,678 total)