Viewing 15 posts - 10,351 through 10,365 (of 13,874 total)
Your answers are confusing. Perhaps if you provided some sample data and details of where you want it to go it would clarify things.
November 20, 2012 at 9:53 am
var05 (11/19/2012)
--
Say if there are 100 new data coming in today into the source,then I wanted to look up the destinationand load only the newly inserted data....Is SSIS look...
November 20, 2012 at 6:59 am
It would be useful background info to have some idea of what your source and destination are - is this a flat file to SQL Server import, or something different?
I...
November 18, 2012 at 1:10 pm
1) Create UDF in T-SQL as usual.
2) Add an ExecuteSQL task which calls the function, eg
select dbo.UDF(col1)
from tab1
November 17, 2012 at 12:09 pm
Thanks. I confirmed with my boss and he said it cannot be done as you suggest.
So any other suggestion to the original question?
Can you please elaborate on the reasons...
November 16, 2012 at 3:03 am
martinez.math (11/16/2012)
A lot of query not exactly compute the age? yes! because sometime they only compute the datediff between DOB and datenow and divide...
November 16, 2012 at 3:00 am
Craigmeister (11/15/2012)
I am having performance issues migrating a particular DTS package to SSIS. A particular step is taking a LOT longer time to complete in SSIS than it does...
November 15, 2012 at 10:23 am
...readily consumable data as I've suggested a couple of times now
"Head banging" and "brick wall" come to mind.
November 12, 2012 at 1:42 am
krypto69 (11/8/2012)
Thanks Phil..This is what I have so far...
Is this going to copy only the changed (updated/inserted) record?
CREATE TRIGGER update_delete ON dbo.WSI_T_CUSTOM_BENFIT_RATES
FOR INSERT, UPDATE
AS
UPDATE WSI_T_CUSTOM_BENFIT_RATES_HIST
FROM WSI_T_CUSTOM_BENFIT_RATES
No. Did you read the...
November 8, 2012 at 10:54 am
I did a quick search and found this[/url]. Looks good enough to point you in the right direction, but there are loads of easy-to-find resources out there courtesy of Google.
November 8, 2012 at 10:20 am
farooq.hbs (11/8/2012)
Dyanmic...If it was fixed then i wud have hardcore the table name and insert but it is dynamic
Hardcore table names? I'm thinking your mind isn't 100% focused on ETL...
November 8, 2012 at 7:59 am
Here's another possibility:
declare @t1 table (Id int)
insert into @t1 (Id)
select 1 union
select 2 union
select 3
declare @t2 table (Id int, X int)
insert into @t2 (Id, X)
select 1, 10 union
select...
November 8, 2012 at 2:24 am
justforgroups2004 (11/5/2012)
We ship books - no more than 10 books per box. And Other items (toys, etc.) – no more than 15 pounds per box. Books are...
November 5, 2012 at 11:04 pm
What I would recommend is that you get your package working with a simple design and then just add the rest of the features and refinements one by one, testing...
November 2, 2012 at 9:35 am
Viewing 15 posts - 10,351 through 10,365 (of 13,874 total)