Viewing 15 posts - 10,276 through 10,290 (of 13,876 total)
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
Mitesh Oswal (12/21/2012)
DECLARE @tbl TABLE
(
ID INT IDENTITY(1,1),
SomeData VARCHAR(100)
)
INSERT INTO @tbl SELECT 'NA11345'
INSERT INTO @tbl SELECT 'NA113456'
INSERT INTO @tbl SELECT 'RA11345'
UPDATE @tbl SET SomeData = SUBSTRING(SomeData,CHARINDEX('NA',SomeData)+2,LEN(SomeData))
WHERE CHARINDEX('NA',SomeData) = 1
select *...
December 21, 2012 at 5:56 am
eklavu (12/20/2012)
UPDATE #TEST_TABLESET COLS = SUBSTRING(COLS,3,LEN(COLS)-2)
WHERE LEFT(COLS,2) = 'NA'
Possibly not relevant here, but if the 'COLS' column is indexed, a better option would be
where cols like 'NA%'
As this will...
December 21, 2012 at 2:18 am
Someone at MS will write a conversion utility for sure if this is implemented. I don't think it's worth worrying about - there is no agreement as to exactly when...
December 20, 2012 at 9:35 am
Viewing 15 posts - 10,276 through 10,290 (of 13,876 total)