Viewing 15 posts - 9,301 through 9,315 (of 13,874 total)
Are you able to break down the load times for the different components?
I'm guessing that it's the fact table reload that takes most time. Have you tried using (cached) lookups...
April 22, 2014 at 1:32 am
So do you truncate your fact table every load too?
April 22, 2014 at 1:22 am
Anjan Wahwar (4/15/2014)
I have the requirement to load source txt file and perform incremental update on my destination table. As I was not allowed to create any table to...
April 15, 2014 at 3:14 pm
Resender (4/14/2014)
There no error message except for the validation error,cause that stops the execution of the rest of the package
I mean are you redirecting error rows - have you checked...
April 14, 2014 at 5:11 am
Resender (4/14/2014)
Phil Parkin (4/13/2014)
Did you modify the datatype of the column in both 'External Columns' and 'Output Columns'?
yes I changed them both from string DT_STR to DT_WSTR & that leads...
April 14, 2014 at 3:00 am
Did you modify the datatype of the column in both 'External Columns' and 'Output Columns'?
April 13, 2014 at 1:36 pm
a4apple (4/10/2014)
DECLARE @String VARCHAR(MAX) = 'SourceFile1_20140803073209.txt'
DECLARE @String1 VARCHAR(MAX) ='SourceFile1_2014073209.txt'
SELECT @String AS [String] ,...
April 13, 2014 at 4:43 am
The complexity of the problem means that a derived column solution is unlikely to be practical.
A Script Component would allow you to write code with as much complexity as you...
April 13, 2014 at 4:38 am
Resender (4/11/2014)
Phil Parkin (4/11/2014)
What exactly are you changing when you 'change to Unicode type'?I go into the advanced editor and change the datatype of the column
Can you post the error...
April 11, 2014 at 8:52 am
Resender (4/11/2014)
I got a series of databases that have...
April 11, 2014 at 8:19 am
From this I understand that the package format is upgraded - does it mean that the package (& functionality contained) will not run against 2008 when using the dtexec command...
April 10, 2014 at 5:44 am
peter 89731 (4/10/2014)
The company I am working for has a 2008r2 server and packages developed using bids 2008. They are also using TFS, and because of some of the...
April 10, 2014 at 4:07 am
KoldCoffee (4/9/2014)
Ooooh, I didn't interpret the lower case f's as intended 😉
..along with >99% of others, I would guess 😀
Phil, you're really a great resource on these forums and have...
April 10, 2014 at 2:29 am
And regardless of where those servers are, you can still get rid of SORT components if you decide to keep the Merge Joins.
April 10, 2014 at 2:27 am
sqlbuddy123 (4/9/2014)
This error usually occurs due to an out-of-memory condition.
Check if you are experiencing any memory problems and errors ..
--
SQLBuddy
Note also that SSIS may do some caching to the...
April 9, 2014 at 11:33 pm
Viewing 15 posts - 9,301 through 9,315 (of 13,874 total)