Viewing 15 posts - 1,486 through 1,500 (of 1,583 total)
Is the query you killed running on a remote/linked server? If so, it's possible it's in a KILLED/ROLLBACK state on the server you killed it from, but still running...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 24, 2011 at 10:46 am
I don't suppose someone could actually post what was changed in the config files for these past 2 posts? 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 18, 2011 at 12:11 pm
In that case try this:
(DISCLAIMER :: there's probably much better ways to accomplish this but I prefer this because it's easier to write and modify)
Alos, you'll need to have xp_cmdshell...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 12, 2011 at 9:58 am
Do you ultimately want to load one XML file at a time from the directory or loop through and load them all at the same time?
If it's just the one...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 10, 2011 at 8:58 am
Hey I'm here to learn as well and am by no means an expert 🙂 Just trying to reiterate something that I was taught (apparently mis-taught) without ever validating...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 9, 2011 at 12:47 pm
Shouldn't SELECT COUNT(1) be the preffered method here over (*)? In larger tables I've noticed drastic performance improvements by choosing only 1 column...
Also, linked servers can be sporadically "quirky"...Do...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 9, 2011 at 11:01 am
I use this all the time with great success:
Script #1 (saved as setup.bat)
set ServerName=YourServer
set DBName=YourDB
set sql_login=YouUser
set sql_passwd=YourPwd
Script #2 (saved as DeployScripts.bat)
@Echo Off
goto skipcomments
rem
:skipcomments
call setup.bat
if not "%UserName%"=="" goto ok
goto...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 6, 2011 at 1:50 pm
While you don't specify where the data you're importing is coming from (flatfile, another table, etc). You should use a WHILE loop to batch process your records. You can...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 2, 2011 at 2:13 pm
I disabled the DELETE file control and replaced it with a simple script and it appears to have worked. Go figure :S
I really don't get this SSIS...what on earth...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 27, 2011 at 1:21 pm
Well I thought this was fixed.
Randomly it appears to rear its ugly head.
Again, everything in the package runs successfully (all GREEN) yet there are errors with the foreach...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 27, 2011 at 8:48 am
How would I go about adding that (forgive me but I'm not that accustomed to SSIS yet)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 25, 2011 at 1:43 pm
This has been resolved. In case anyone's interested the issues lays with setting the variable beforehand.
Variable Mapped:
Name: RRINVHDR
Scope: Package Level
Data Type: String
Value: F:\ETLDrop\work\RRINVHDR.dat
The value should be set to an...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 22, 2011 at 2:40 pm
NEVER use BETWEEN on dates with times.
Why?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 14, 2011 at 9:20 am
The main table (with potentially millions of records) exists and has data the the BI team reports against. The flatfiles contain data that may or may not already exist...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 14, 2011 at 9:05 am
So the consensus is (please correct me if I'm wrong):
Dump the contents of each file into a staging table, put an index on the column I want to look up...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 14, 2011 at 7:36 am
Viewing 15 posts - 1,486 through 1,500 (of 1,583 total)