Viewing 15 posts - 10,351 through 10,365 (of 13,879 total)
rhythm.varshney (11/25/2012)
Phil Parkin (11/25/2012)
So what is your question?
I need to import the data into the table.The logic is If Type is MSAD then it should update MSAD column of table...
November 25, 2012 at 5:15 am
grantbanjo (11/23/2012)
I am using SSIS in SQL Server 2008 R2 and have been creating packages for a few years, but have not done so where the packages will be going...
November 25, 2012 at 5:06 am
Could it be that the server's default date format is dd/mm/yyyy and your PC it is mm/dd/yyyy (or vice versa)?
November 25, 2012 at 4:51 am
What is the data type of User::SCH_DFEE?
November 21, 2012 at 8:34 am
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
Viewing 15 posts - 10,351 through 10,365 (of 13,879 total)