Viewing 15 posts - 10,276 through 10,290 (of 13,879 total)
i wonder if you all took care of scenario whereby package i executed before or at 8am.
My solution handles that.
December 28, 2012 at 2:04 am
Here's my pseudo-code expanded a bit to accommodate the start and end date bits:
declare @StartDate datetime
,@EndDate datetime
set @EndDate = dateadd(hour, 8, DATEADD(dd, 0, DATEDIFF(dd, 0, DATEADD(HOUR, - 8, getdate()))))
set @StartDate...
December 28, 2012 at 12:33 am
Phil Parkin (12/27/2012)
asita (12/26/2012)
Could you please help me out here, i am totally stuck here,
i have total 20 tasks in my ssis package (dataflow, execute sql task, etc)
at 16...
December 27, 2012 at 4:25 am
santoooo (12/27/2012)
I also had the same problem,
In my table Timestamp column is there which is not supported by the OLEDB DESTINATION connection.
Please cross check the data types in your...
December 27, 2012 at 4:14 am
10e5x (12/27/2012)
You are right, definately will have overhead. i try to get it done first before looking at efficiency issue. Actually my problem is defining startDate and endDate. Thanks phil
OK,...
December 27, 2012 at 4:12 am
OK, then you need help from an Oracle developer to design your SELECT statement for the OLEDB source.
Select col1, col2
from table
where [convert varchar date and time to datetime] between [startdate]...
December 27, 2012 at 2:54 am
buyme22 (12/27/2012)
input this URL:you can find many cheap and high stuff
Believe you will love it.
WE ACCEPT CREDIT CARD /WESTERN UNION PAYMENT
YOU MUST NOT MISS IT!!!;-):-D:-D
Reported as...
December 27, 2012 at 2:48 am
Is the source a SQL Server database?
December 27, 2012 at 2:18 am
asita (12/26/2012)
Could you please help me out here, i am totally stuck here,
i have total 20 tasks in my ssis package (dataflow, execute sql task, etc)
at 16 dataflow task...
December 27, 2012 at 2:03 am
Depending on the nature of your OLEDB source (is it an RDBMS?), the most efficient way would be to CAST the varchar date/time columns to a single column with a...
December 27, 2012 at 1:53 am
There's an interesting script written by Dan Guzman here which demonstrates that the physical ordering is not necessarily the same as the clustered index logical ordering.
December 26, 2012 at 7:18 am
Nice article, but rather than fields and records, I think you really mean columns and rows - there is a difference.
December 24, 2012 at 6:59 am
Eugene Elutin (12/21/2012)
Phil Parkin (12/21/2012)
...
And as to common practice - not in my experience. I guess it depends on whatever standards are in place where you are working.
In SSMS Object...
December 21, 2012 at 10:24 am
Comments can precede CREATE/ALTER line.
It is most common practice to have stored procedure header comments section outside of stored proc body.
While true, that's being a bit picky:-) Comments immediately preceding...
December 21, 2012 at 8:24 am
Shadab Shah (12/21/2012)
December 21, 2012 at 7:31 am
Viewing 15 posts - 10,276 through 10,290 (of 13,879 total)