Viewing 15 posts - 9,706 through 9,720 (of 13,879 total)
kevin_nikolai (8/2/2013)
For SQL Reports stored procedures you most definitely want to use "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED".--
If you can guarantee that the database is and will be in a...
August 2, 2013 at 3:34 am
Presumably you are using some sort of front-end application (Winform/Web) to get this info from the user. This validation should be done there and not by SQL Server.
August 2, 2013 at 3:30 am
August 2, 2013 at 1:46 am
Ryan1 (7/31/2013)
August 2, 2013 at 12:40 am
Or put this query in your task.
If your source is SQL Server, this is what I would do - use a query for your data source and include this...
August 2, 2013 at 12:34 am
I second Sean's comment.
The contents of the page linked to by Durai Samuel should not be relied on as they contain multiple incorrect statements relating to the nature and...
August 2, 2013 at 12:24 am
Smash125 (7/31/2013)
please this is not job site please do not send. u r wasting people's time
It's just the wrong forum. Try posting here[/url] instead.
July 31, 2013 at 3:05 am
My assumption was that we were talking about a single script, consisting of multiple batches. In which case a local temp table would do
I see! I agree with your comments...
July 31, 2013 at 2:16 am
If you have a couple of these suckers, and they are decently complex, the temp table is not a bad idea.
On this, I think we shall have to agree to...
July 31, 2013 at 1:44 am
Erland Sommarskog (7/30/2013)
You could use a single row temp table for your "global variables".
Presumably you mean a global temp table.
Although it would probably work, it's a bad idea - it...
July 31, 2013 at 12:00 am
John's suggestion is the way I would do it.
I would also have a process to move unwanted / processed / duplicate batch files somewhere else, to keep the 'to be...
July 30, 2013 at 11:52 pm
Please note that Script Tasks and Script Components are different things. Using the terms interchangeably will confuse people who know the difference.
Script Tasks are used in the Control Flow (and...
July 30, 2013 at 11:47 pm
Having a CTE which is effectively defined as
select * from (subquery)
is somewhat bizarre too.
You've been here long enough to know how to post questions - not only does your...
July 30, 2013 at 11:41 pm
Bill McDonough (2/2/2007)
One way to do this is a script task. In the script, you'll have something like this:
PublicOverrides Sub ProcessInputRow(ByVal Row as rowInBuffer)
In that function, you can usethis...
July 29, 2013 at 3:22 am
vasu1.vi (7/26/2013)
I am working on a package that needs to populate currentdate when we insert new row on the table. For this i am using getdate() in the vaiable. when...
July 26, 2013 at 10:02 am
Viewing 15 posts - 9,706 through 9,720 (of 13,879 total)