Viewing 15 posts - 1,156 through 1,170 (of 3,232 total)
OK, then the transaction that you are creating (by setting the Transaction Option to Required) needs to be scoped out to include the Truncate. Instead of setting the Transaction...
August 11, 2009 at 2:24 pm
I did not know you had a step in the package to truncate the table. Where is that happening? Inside the data flow or in the control flow?
August 11, 2009 at 1:47 pm
So you've got 2 issues here.
1. E-mail notification on error - you said that it did not send an email when your flat file destination encountered an error....
August 11, 2009 at 12:47 pm
I would cluster the date column only and create a non-clustered index on your key columns linked to dimensional tables.
When you query the data, filter the query based...
August 11, 2009 at 10:16 am
roundel1900 (8/11/2009)
August 11, 2009 at 9:55 am
Thanks for the info Greg. I've got a busy morning ahead of me, but I'll get something back to you today sometime. I'll share with you how I...
August 11, 2009 at 9:51 am
Pretty simple then, since you'll be returning the results from the SP via varchar(max) data type, add the XML header info to the top of the varchar string and away...
August 11, 2009 at 9:43 am
So you're using an IDENTITY column as a surrogate key for your parent rows. Is there a business key available that you could use to find the parent row...
August 11, 2009 at 9:33 am
Jack Corbett (8/10/2009)
John Rowan (8/10/2009)
You should be able to accomplish this by seting the Maximum Insert Commit Size setting on your OLE DB Destination Fast-Load component.
Duh, why didn't I think...
August 10, 2009 at 5:20 pm
So just to be clear, your application is tracking user events in the form of XML messages in a table. You want to move those messages into other tables...
August 10, 2009 at 5:00 pm
You may be better off adding some logic to your data flow to ensure that there is only 1 instnace of any given row id in the pipeline. What...
August 10, 2009 at 4:51 pm
Jack's got some good questions here. You have not told us much about what you are doing.
In general, you'll need 2 data flows. One to load the parent...
August 10, 2009 at 4:39 pm
Yes. If you put a Send Mail task in the OnError event, you'll get an e-mail when the task raises an error.
August 10, 2009 at 4:23 pm
You should be able to accomplish this by seting the Maximum Insert Commit Size setting on your OLE DB Destination Fast-Load component.
August 10, 2009 at 4:20 pm
Just curious, have you tried using the SCD transformation for this?
August 10, 2009 at 4:10 pm
Viewing 15 posts - 1,156 through 1,170 (of 3,232 total)