Viewing 15 posts - 13,231 through 13,245 (of 13,874 total)
From the error message, this does not look like a problem with your GV. You could check this by replacing the field4 line with
msgbox DTSGlobalVariables("g_RunNr").Value
and then run the step...
November 29, 2005 at 2:03 am
Actually, I should have left this thread well alone ![]()
But the original post contains two questions - that is how I came up with my...
November 29, 2005 at 1:40 am
Hi Mike
I think that your answer should start with 'No' rather than 'Yes' ![]()
--edit-- I think you were answering question 2 - I was...
November 28, 2005 at 9:17 am
Semi-automatically. Select Tools/Options/Results and set 'Results to File' as the 'Default Results Target' and set the Results output format to CSV.
But you'll have to supply the filename and path.
If you...
November 28, 2005 at 9:15 am
Although the maximum column width in Excel is 255 characters, that is not the maximum length of data that can be stored in a column, which is 32,767 characters.
DTS will...
November 28, 2005 at 6:16 am
Can you post the script that generated the error?
November 28, 2005 at 3:16 am
So you are not seeing the tables in QA's Object Browser after creating them? Have you tried refreshing the view? Have you tried looking via Enterprise Manager?
November 25, 2005 at 5:06 am
Not sure about SQL7, but in SQL Server 2000, you could consider using
SET QUOTED_IDENTIFIER
to get round this.
November 25, 2005 at 4:54 am
This question is not detailed enough.
How did you create the tables - what tool did you use? What tool are you using to view the tables? Who were you logged...
November 25, 2005 at 4:44 am
This is certainly one of the more bizarre and exasperating threads on the go at the moment - suggestions for differences in performance have been posted and these seem perfectly plausible...
November 17, 2005 at 8:19 am
You are wrong in stating that functions cannot be used as defaults - getdate() works fine, for example.
What can be used - from BOL:
"Is an expression that contains only constant...
November 17, 2005 at 7:37 am
Given that you have so many tables, I suspect that the relationships will be pretty complex. Without knowing the relationships between all the tables, it is difficult to get specific.
However,...
November 17, 2005 at 5:35 am
Try running SQL Profiler when you run the query - you should be able to get exact execution times that way.
November 14, 2005 at 6:39 am
Sticking with Northwind, is this roughly where you're heading?
select sum(t1.Count1), sum(t1.Count2) from
(select employeeid,
Count1 = (
case
when Count(EmployeeID) < 100 then Count(EmployeeID)
else 0
end
),
Count2 = (
case
when Count(EmployeeID) >= 100...
November 14, 2005 at 4:38 am
Viewing 15 posts - 13,231 through 13,245 (of 13,874 total)