Viewing 15 posts - 9,706 through 9,720 (of 13,880 total)
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
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
wolfkillj (7/25/2013)
July 26, 2013 at 9:47 am
peterzeke (7/26/2013)
As you suggested, I exported a spreadsheet as a text file. The values in the text file match the values in the...
July 26, 2013 at 9:32 am
Viewing 15 posts - 9,706 through 9,720 (of 13,880 total)