Viewing 15 posts - 7,831 through 7,845 (of 11,678 total)
1) Yes. Although I wouldn't use the SQL Server Destination. The performance gain is neglible and it has certains downsides: it only works if the package runs on the same...
February 27, 2012 at 12:45 am
What name did you specify for the server in the configuration?
February 27, 2012 at 12:41 am
If the Excel file contains the whole set of records, truncate the table and load it from scratch, as crazy4SQL suggested.
If it doesn't, you need to find the business key....
February 27, 2012 at 12:05 am
Where do you store the names of those 3 sheets?
February 27, 2012 at 12:02 am
You cannot put "unknown" in an integer column. You need to cast it to a string column.
ISNULL(DepartmentID) ? (DT_STR,7,1252)"Unknown" : (DT_STR,7,1252)DepartmentID
February 26, 2012 at 11:58 pm
You can set this in the Advanced Editor of the Excel Source component.
Right click on the source, choose Advanced Editor.
Input and Output properties --> source output --> output columns.
Choose the...
February 26, 2012 at 11:54 pm
ilan_2610 (2/26/2012)
Thanks a lot Ron.I don't find the answer to my issue.
It seems complicated.:(
By what logic do you want that last row.
Is it always the last row, or the one...
February 26, 2012 at 12:48 pm
Lynn Pettis (2/24/2012)
February 25, 2012 at 11:13 pm
steveyc (2/25/2012)
Why not just use the inbuilt File System Task?
Have you ever used it before and made it dynamic with expressions?
It can be a nightmare, and .NET is easier, more...
February 25, 2012 at 11:06 pm
SQLRNNR (2/24/2012)
Jeff Moden (2/24/2012)
Attacking SSIS at last...
I finally started doing the same thing and had to stop. They really took serious offense to me hitting the server with a...
February 25, 2012 at 11:05 pm
Maybe SSAS gets only a really small portion of your 3.5GB?
February 24, 2012 at 3:19 am
HowardW (2/24/2012)
... I find it helps to seperate the wheat from the chaff in the ever-growing, fragmented MS BI stack.
Fragmented? There are barely 3 report building applications. (4 if you...
February 24, 2012 at 3:14 am
Raghavendra Mudugal (2/24/2012)
Thank you Keon.
No problem Madagul. 😉
February 24, 2012 at 2:55 am
Raghavendra Mudugal (2/24/2012)
anthony.green (2/24/2012)
Raghavendra Mudugal (2/24/2012)
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation ...
February 24, 2012 at 2:53 am
Viewing 15 posts - 7,831 through 7,845 (of 11,678 total)