Viewing 15 posts - 151 through 165 (of 544 total)
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...
December 18, 2012 at 6:25 am
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...
December 18, 2012 at 6:20 am
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...
November 28, 2012 at 6:40 am
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...
November 28, 2012 at 5:54 am
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...
November 28, 2012 at 5:32 am
Cadavre (10/12/2012)
Here are...
October 12, 2012 at 6:54 am
Phil Parkin (10/8/2012)
Charmer (10/8/2012)
Phil Parkin (10/8/2012)
A no-code solution could utilise FOREACH containers - the container just does not execute if the...
October 8, 2012 at 7:51 am
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...?
October 8, 2012 at 7:19 am
Phil Parkin (10/8/2012)
A no-code solution could utilise FOREACH containers - the container just does not execute if the file is not...
October 8, 2012 at 6:33 am
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...
October 1, 2012 at 7:14 am
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...
September 26, 2012 at 8:09 am
Charmer (9/26/2012)
I have a doubt regarding joining two tables, so i came here to get...
September 26, 2012 at 7:00 am
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...
September 25, 2012 at 9:31 am
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...
September 25, 2012 at 2:25 am
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...
September 21, 2012 at 9:16 am
Viewing 15 posts - 151 through 165 (of 544 total)