Viewing 15 posts - 121 through 135 (of 187 total)
Hi Crispin,
I'm not sure that I understand all of your suggestion. I added a script component of transformation type to the Data Flow task but I cannot see where you...
September 13, 2007 at 6:37 am
I've worked out what the problem is but I don't know what to do to fix it.
The problem is being caused by a connection manager within the package; when executing...
August 28, 2007 at 6:15 am
Colin/Andras,
Thank you both for your help. I added newid() to the default for the column and it is now working as expected.
Release documentation and control is something that we should...
August 23, 2007 at 3:15 am
Ah, I see!
Thanks for your help Alex. Your English is much, much better than my Spanish!
August 20, 2007 at 6:03 am
How strange, on the server the option is there?!
Why would the job type be available on the server but not on the client??
August 20, 2007 at 4:54 am
I use SSMS that is installed on my client machine
August 20, 2007 at 4:22 am
Hi Crispin,
I did as you suggested, I created two DF and merged them all in one go. Don't know why I didn't think of that to start with but thank...
July 24, 2007 at 2:56 am
Hi Crispin,
Ideally that is what I would do but unfortunately the code has to create an instance of a COM object that was supplied by a third party. As far...
July 5, 2007 at 3:54 am
Hi Adrian,
Yes there is a data pump task within the package. I shall try what you have suggested and let you know if it resolves the problem.
Thanks
David
June 14, 2007 at 2:40 am
Hi Antares,
I had a look at the following in the end which helped:
http://support.microsoft.com/kb/314520
Thanks for your response.
May 10, 2007 at 8:32 am
Sorry, the amended script was:
March 8, 2007 at 4:40 am
Thanks Sreejith, that worked great!
September 5, 2006 at 1:15 am
declare @intCCentre INT
declare @fltTotal FLOAT
declare prod_totals cursor
for select fintCostCentreID, sum(fdecHours)
from tblExtract
where fvchProductFamily <> '945'
group by fintCostCentreID
open prod_totals
fetch next from prod_totals into @intCCentre, @fltTotal
while @@FETCH_STATUS = 0
begin
select fintCostCentreID,
fvchProductFamily,
'80000165' as...
September 4, 2006 at 8:24 am
Jules/Mike, thank you both for your help the correct results are now being returned.
May 30, 2006 at 9:10 am
Viewing 15 posts - 121 through 135 (of 187 total)