Viewing 15 posts - 16 through 30 (of 171 total)
Would that just be for the large tables i.e. the 250,000, 500,000 and the 900,000 tables or all would you say? I'll have a good read of those articles now.
Martin...
February 22, 2012 at 8:54 am
For the data flow containing the largest transformation (i.e. the table with 900,000 records) the DefaultBufferMaxRows is 10,000, DefaultBufferSize is 3145728. I've set Rows per batch to be 1000 and...
February 22, 2012 at 8:25 am
How do I check the amount of memory available/allocated please?
Martin Schoombee (2/22/2012)
Griffster (2/22/2012)
February 22, 2012 at 8:19 am
Also, having run a trace on the production server, by running the new package in design mode, it seems to be running a series of insert bulk [dbo].[Table_Name] statements with...
February 22, 2012 at 8:08 am
Think that's a bit of red herring looking in to it a bit further. I created the main body of the new SSIS 2008 package using the import/export wizard. I...
February 22, 2012 at 8:01 am
I've tried the sql statement approach already unfortunately. I've just tried to run the ssis 2005 package in VS 2008 and it runs the same speed on my PC. Weird!...
February 22, 2012 at 7:05 am
Aha. Good ploy. I've just tried that and it's the same speed on my development machine. Well that's something I guess. Any ideas on the odbc source then?
February 22, 2012 at 6:32 am
Yes, they're all Table or view - fast load data access mode.
February 22, 2012 at 6:22 am
Ok, thanks both. Looks like I'm not going to be able to do this then if that's the order of precedence.
October 26, 2011 at 5:01 am
I have an ssis package that runs from an xml configuration file. This contains an end date. I need to be able to run the package up to a certain...
October 26, 2011 at 5:00 am
Ok, thanks.
October 25, 2011 at 2:15 am
Elliott Whitlow (10/24/2011)
October 24, 2011 at 9:36 am
Would I have to set all the variables I refer to in my xml configuration file i.e. my dtexec command will skip the configuration file and so I'll need to...
October 19, 2011 at 7:20 am
PAram-383796 (12/11/2008)
You can also use package configuration and store that config in XML File and update that file at runtime.
I have a similar requirement here. I have an xml configuration...
October 17, 2011 at 2:36 am
Aha. That seems to have worked. I (stupidly) was concentrating on the second CTE (filteredaddresses) and was testing isnull(A.Address1,'') <> ISNULL(B.Address1, '')) in my where clause. Thanks again.
September 13, 2011 at 7:13 am
Viewing 15 posts - 16 through 30 (of 171 total)