Forum Replies Created

Viewing 15 posts - 151 through 165 (of 544 total)

  • RE: How to convert the pdf file to blob type ?

    Koen, FYI

    "INSERT INTO [dbo].[Doc_Stage](DocName,DocPath,DocType) VALUES ('" +REPLACE(RIGHT(@[User::FilePath],FINDSTRING(Reverse(@[User::FilePath] ) ,"\\", 1)-1),RIGHT(@[User::FilePath],4),"")+ "','" + @[User::FilePath] + "','" + RIGHT( @[User::FilePath] ,FINDSTRING( REVERSE(@[User::FilePath] ),".",1)-1)+ "');"

    I googled and...

    Thanks,
    Charmer

    December 18, 2012 at 6:25 am

    #1569530

  • RE: How to convert the pdf file to blob type ?

    Koen Verbeeck (12/18/2012)

    You can use the Import Column task to import the PDF files into the database.

    Yes Koen, I am using the import column component....but the task gets failed when...

    Thanks,
    Charmer

    December 18, 2012 at 6:20 am

    #1569525

  • RE: Table is loading for long time and becoming time out?

    Lowell (11/28/2012)

    ok, does select * from table have any text or varbinary columns that are huge in size?

    No text or varbinary datatype

    can you get teh actual exection plan and post...

    Thanks,
    Charmer

    November 28, 2012 at 6:40 am

    #1563094

  • RE: Table is loading for long time and becoming time out?

    Hi,

    My query is just simple select statement....select * from table....like that

    i used this " SELECT * FROM sys.dm_os_wait_stats" statement but i am not sure which one is the result...

    could...

    Thanks,
    Charmer

    November 28, 2012 at 5:54 am

    #1563064

  • RE: Table is loading for long time and becoming time out?

    dbasql79 (11/28/2012)

    Did you check there is any session is blocking select query?

    Yes, i checked for the blocked session ID with the help of select queries as well as the activity...

    Thanks,
    Charmer

    November 28, 2012 at 5:32 am

    #1563049

  • RE: How to order the rows?

    Cadavre (10/12/2012)

    Same as the last post I made, still on lunch and waiting in the car so this is untested and written on my phone. Forgive any syntax errors.

    Here are...

    Thanks,
    Charmer

    October 12, 2012 at 6:54 am

    #1548605

  • RE: Check if File Exists?

    Phil Parkin (10/8/2012)

    Charmer (10/8/2012)

    Phil Parkin (10/8/2012)

    Are you doing the imports in parallel or in series?

    A no-code solution could utilise FOREACH containers - the container just does not execute if the...

    Thanks,
    Charmer

    October 8, 2012 at 7:51 am

    #1546727

  • RE: Check if File Exists?

    SGT_squeequal (10/8/2012)

    Do you have a list of file names? you could use master.dbo.xp_fileexist to determine if they exist or not

    yes, i have the file names...so...?

    Thanks,
    Charmer

    October 8, 2012 at 7:19 am

    #1546712

  • RE: Check if File Exists?

    Phil Parkin (10/8/2012)

    Are you doing the imports in parallel or in series?

    A no-code solution could utilise FOREACH containers - the container just does not execute if the file is not...

    Thanks,
    Charmer

    October 8, 2012 at 6:33 am

    #1546687

  • RE: Not able to run Integration service...

    Maddave (10/1/2012)

    You can simple run the setup.exe of SQL server from the installation media and add integration services to the existing install.

    If doing so, It will not affect the production...

    Thanks,
    Charmer

    October 1, 2012 at 7:14 am

    #1543971

  • RE: What is the difference?

    Thank you so much Stewart....This example is going to help me a lot...I made lot of mistakes in my T-SQL statements with this join with AND , join with WHERE...

    I...

    Thanks,
    Charmer

    September 26, 2012 at 8:09 am

    #1542434

  • RE: What is the difference?

    Charmer (9/26/2012)

    Hi Friends,

    I have a doubt regarding joining two tables, so i came here to get...

    Thanks,
    Charmer

    September 26, 2012 at 7:00 am

    #1542367

  • RE: No Progress while Update

    Koen Verbeeck (9/25/2012)

    Charmer (9/25/2012)

    What i do here is, pushing all records into Staging table and using a Execute SQL task to update all the rows in single transaction....well, the way...

    Thanks,
    Charmer

    September 25, 2012 at 9:31 am

    #1541950

  • RE: No Progress while Update

    Koen Verbeeck (9/22/2012)

    Charmer (9/21/2012)

    Koen Verbeeck (9/21/2012)

    Charmer (9/21/2012)

    Koen Verbeeck (9/21/2012)

    Could have been anything. Syntax is probably correct, otherwise it would have errored out.

    Maybe a deadlock or something?

    I am the only one...

    Thanks,
    Charmer

    September 25, 2012 at 2:25 am

    #1541698

  • RE: No Progress while Update

    Koen Verbeeck (9/21/2012)

    Charmer (9/21/2012)

    Koen Verbeeck (9/21/2012)

    Could have been anything. Syntax is probably correct, otherwise it would have errored out.

    Maybe a deadlock or something?

    I am the only one who is using...

    Thanks,
    Charmer

    September 21, 2012 at 9:16 am

    #1540790

Viewing 15 posts - 151 through 165 (of 544 total)