Viewing 15 posts - 11,341 through 11,355 (of 13,861 total)
GilaMonster (6/8/2011)
All indexes, if they can be used, reduce the IO cost for queries. That's the whole point of an...
June 8, 2011 at 2:40 am
hl6a (6/7/2011)
Is it possible to use precedence contraint to bypass a task? For example, the control flow starts with task A, checks an expression, if true, run B then...
June 7, 2011 at 10:08 am
Another problem is where Tax_Period is a stored as a string (which it appears to be), and not a numeric, as exemplified below:
DECLARE @Tx1 VARCHAR(5), @tx2 VARCHAR(5)
SET @tx1 = '21'
SET...
June 7, 2011 at 7:59 am
Note also that custom formatting in Excel has no effect on the data which is stored or extracted - it is a display format effective only in the Excel application.
June 7, 2011 at 7:36 am
davidsalazar01 (6/6/2011)
Chris,--
Is that Craig Chris or Phil Chris? 🙂
We need to know what you will be doing with the dates before we suggest the best solution.
June 6, 2011 at 10:29 am
From what you say, it sounds like you want a completely flexible number of parameters (from your "..all dates in the last 2 months" comment).
Have you thought about setting up...
June 6, 2011 at 10:25 am
Use a conditional split to redirect the unwanted lines to an unused output as part of your data flow.
June 6, 2011 at 10:20 am
One easy way is to put your dataflow inside a Foreach (file) container - using the input file's name as the filespec. Then it will not execute if the file...
June 4, 2011 at 2:59 pm
Gangadhara MS (6/3/2011)
I have a table with 5 column out of which one column datatyp is "Datetime"
ID,Country,Dateruled Isactive
Ex: 1,India,Rural,2008-05-15 18:30:00.000 ACTIVE
The datatype for the Dateruled column is of...
June 3, 2011 at 2:44 am
No problem - but you'll need a dataflow for each one.
You can't easily do this dynamically, if that's what you're thinking of.
June 2, 2011 at 10:35 am
Sriram.RM (6/2/2011)
Add an empty result set at the top with the same structure as the select statement, this will return the...
June 2, 2011 at 5:33 am
quasar_phoenicis (6/2/2011)
Koen Verbeeck (5/31/2011)
quasar_phoenicis (5/31/2011)
I have a parent package with 2 execute packages tasks that are connected through a "success"contraint. Execute SSIS package 2 should not run until execute ssis...
June 2, 2011 at 5:23 am
I see your point.
Another option is to use an Execute SQL task to log start and end dates to a job status table - so you can track when the...
June 1, 2011 at 10:35 am
Interesting.
My first thought is to move the scheduling logic to a new script task at the beginning of the package, which executes the subsequent tasks if the conditions are...
June 1, 2011 at 10:16 am
Viewing 15 posts - 11,341 through 11,355 (of 13,861 total)