Forum Replies Created

Viewing 15 posts - 8,416 through 8,430 (of 13,882 total)

  • RE: scheduling the SSIS jobs

    VRT (5/13/2015)


    --

    I don't see SQL Server Agent also, may be I don't have permissions to schedule.

    This sounds very likely.

  • RE: Package failed

    vipin_jha123 (5/13/2015)


    Hi According to me Checkpoint is used to restart the package from the point point where it fail.

    so u can seee that when your package failed one files are...

  • RE: Package failed

    reddychaitanyakrishna (5/13/2015)


    Hi,

    I have a DFT in a package which loads around 2lakhs records in to destination but, it fails loading after 1 lakh records, my package was checkpoint enabled. I...

  • RE: SSIS 2012 version issue , package corrupt mystery

    This is not a version issue. This relates to the fact that you saved the package with encrypt sensitive with user key turned on. if you save the package as...

  • RE: SSRS 2014 Performance issues

    sreenubabu.s (5/12/2015)


    We have installed recently SSRS 2014 (SQL 2014 RTM) and deployed the reports into the server and all users being accessed. We have done memory configuration in config file...

  • RE: How to get row of first change?

    Something like this?

    if object_id('tempdb..#date', 'U') is not null

    drop table #date;

    create table #date (a int, b int, dte date);

    insert #date

    (a

    ...

  • RE: Adding New Row in Temp Table

    Then your top 1 query has a flaw too, it has no where clause.

    No ORDER BY clause, I think you may have meant.

  • RE: Window Authentication

    RTaylor2208 (5/12/2015)


    --

    The only exception is that when launching the application providing its on a windows machine you use the method of right clicking on the application and selecting "Run As"...

  • RE: Execute SQL Task -SSIS

    vipin_jha123 (5/12/2015)


    Hi ,

    It was a problem with the length of column.

    i increased the length of column and now running fine.

    regards,

    Vipin jha

    I'm amazed you worked that out, based on the error...

  • RE: Execute SQL Task -SSIS

    Can you confirm that you have resultset set to none and include a screen shot of your parameter mapping screen?

  • RE: Copying database failed

    Are you using the Copy Database wizard?

    Why not use backup/restore instead?

    Try looking for that text in all objects in the database using SQL Search[/url]

  • RE: Copying database failed

    Is there anything special about

    dbo.MostOrderedGenerics

    ?

  • RE: SSIS - Image Import Filename

    No problem. Thanks for posting back.

  • RE: Idempotent

    Eric M Russell (5/8/2015)


    Bradley Deem (5/7/2015)


    Phil Parkin (5/7/2015)


    'Flashback'. What is that?

    Sorry, Oracle terminology. In SQL Server this would be Snapshot. Regardless, use technology to allow you to rollback to the...

  • RE: SSIS - Image Import Filename

    am_mal80 (5/8/2015)


    Hi Guys,

    I need your help how to solve the below error.

    Warning: 0x802092A8 at Data Flow Task, OLE DB Source [1]: Truncation may occur due to retrieving data from database...

Viewing 15 posts - 8,416 through 8,430 (of 13,882 total)