Forum Replies Created

Viewing 15 posts - 10,651 through 10,665 (of 11,676 total)

  • RE: External column's datatype keeps reverting

    hxkresl (1/3/2011)


    Looking at Advanced Editor/Input and Output Columns for the flat file: The external source is a flat file (.csv) and output destination is SQL Server table. The external and...

  • RE: How to decided which connection type to use?

    I think the most important questions for the initial interview are:

    * where is the file located?

    * can the location change over time?

    * what are the columns and what data is...

  • RE: Error with MDX

    Do you have dimension security or are you using NONEMPTY?

    If yes, read the following KB article:

    http://support.microsoft.com/kb/940019

  • RE: to resist the duplicates in the ssis packages

    Be aware that the Sort component is a blocking component in SSIS and that it can drastically affect performance if you transfer a lot of rows. If this becomes an...

  • RE: TRUNCATE in TRANSACTION

    Oh yeah, a tip for the author:

    if you really want to deceive people, you should've included the number of rows that had a 3 in the answer. Eight rows I...

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/3/2011)


    Brandie Tarvin (1/3/2011)


    Quick question for those on LinkedIn. I just received a message over the past two days (two messages actually) asking for advice on performance tuning tools....

  • RE: T-SQL

    sathishmcc (1/4/2011)


    Im getting the error while running the query

    Server: Msg 8101, Level 16, State 1, Line 7

    An explicit value for the identity column in table '@student' can only be specified...

  • RE: grouping_id questions

    autoexcrement (1/3/2011)


    Okay, thanks for the answer. I think I was basically on the right track, that the whole "Grouping" thing is just a convenient way to check for NULL intersections.

    What's...

  • RE: Goals

    Craig Farrell (1/3/2011)


    Well, that should keep me from being bored. *sighs* All of that's REALLY going to dig into my video game time.

    With all those goals, I'm even surprised...

  • RE: TRUNCATE in TRANSACTION

    Good question, but with lots of trickery.

    What point were you trying to make? Duplicates with UNION, TRUNCATE in transaction or columns referenced directly in the IN clause?

  • RE: Visual Studio for Apps environment does not launch

    btio_3000 (1/3/2011)


    Looks like reinstalling SP3 took care of it.

    Read

    http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/0fb52353-3b54-4ece-99d7-4fd187ca000d

    So it's probably the order of installing, like in the article... Not sure, but it seems to be fixed and showing

    Glad...

  • RE: SSIS package(package ->cube)

    miriyalasrihari (1/3/2011)


    thanks this is very helpful to me.....

    No problem at all. If you have more questions, do not hesitate.

  • RE: Where are you?

    With fireworks? 😀

  • RE: Are the posted questions getting worse?

    Craig Farrell (1/3/2011)


    For anyone following the earlier infringment discussion, some sleuthing around SSC finally revealed the blog owner. A brief PM conversation seems to have dealed with that issue.

    Happy...

  • RE: Goals

    Nice concept. I'll add my bit.

    Goals for 2010:

    Professional

    * Get certified. Well achieved: 1 cognos certificate and the 3 MCTS certifications for SQL Server

    * Events: attended MS Tech Days and SQLServerDay...

Viewing 15 posts - 10,651 through 10,665 (of 11,676 total)