Forum Replies Created

Viewing 7 posts - 16 through 23 (of 23 total)

  • RE: Data Type conversion

    Thanks for replying me.

    That function is working in ssms.

    How can we use this in SSIS if I am getting that Time column in FlatFile and I want to...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 8, 2014 at 9:42 am

    #1711936

  • RE: Differences between SQL 2012 AND SQL 2008R2

    Yes,

    In 2012 there is new feature called project parameters here you can define parameters on project level and configure your connection manager accordingly.

    This feature is really useful when...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 6, 2014 at 8:46 am

    #1711102

  • RE: Differences between SQL 2012 AND SQL 2008R2

    Integration Service Catalog is really nice feature in SQL 2012 in that you can deploy your SSIS Packages and Create environment as you wish.

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    May 6, 2014 at 8:44 am

    #1711101

  • RE: "VS_ISBROKEN" error message

    I got same kind of problem while I was running my packages through "Start without Debugging".

    Then I run my packages with debugging and I resolve that error.

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    April 25, 2014 at 10:50 am

    #1708849

  • RE: Create Statistics on Tables

    Thanks Grant and Gail,

    I have been reading on internet regarding statistics on tables in PDW. I got this information that I am pasting here.

    ---------------------------------------------------------------------

    Ideally, you should create stats...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    April 18, 2014 at 1:01 pm

    #1707165

  • RE: Create Statistics on Tables

    Thanks Grant for your reply.

    Actually I am never created statistics on table but in my company someone told me to create and work on statistics it will help you...

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    April 18, 2014 at 8:45 am

    #1707098

  • RE: Create Statistics on Tables

    Thanks for your reply I have already visited those websites but I need more information regarding statistics.

    If you have real example links that would be really appreciated.

    Thanks

    Viresh

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

    April 17, 2014 at 2:48 pm

    #1706932

Viewing 7 posts - 16 through 23 (of 23 total)