Viewing 15 posts - 11,041 through 11,055 (of 11,678 total)
Maybe you could try a script task to solve this problem. After you've created the file, you could open it in .NET and go to the last line to delete...
October 8, 2010 at 8:03 am
SSIS is very sensitive about metadata changes.
With out-of-the-box SSIS, there is not much that you can do than manually remap the columns each time they change.
But maybe you could try...
October 8, 2010 at 8:00 am
cmbrooks08 (10/8/2010)
We ended up pulling the max date out of the dimension, then only loading records newer than that. In...
October 8, 2010 at 7:10 am
Nice question.
I was afraid it was some trick question of some exotic behaviour of SQL Server (with the no lock hints and everything), but luckily common sense was enough to...
October 7, 2010 at 4:33 am
Congratulations!
SSC is a wonderful site and I have learned tons of things in the past few months.
I'm certain I will still learn a lot more here at SSC.
Keep up the...
October 7, 2010 at 3:07 am
cliffb (10/6/2010)
da-zero (10/6/2010)
...
Join your source (staging) table with the destination (dimension/fact table)
...
If your data source is on the same server as the dimension table, then I agree with you....
October 7, 2010 at 12:40 am
If SSIS 2005:
you can use a left outer join in your data source. Join your source (staging) table with the destination (dimension/fact table) with the no lock hint. If your...
October 6, 2010 at 7:56 am
Phil Parkin (10/6/2010)
Does View/Error List give you anything useful?
That is indeed the place to find your errors/warning. Just make sure you haven't filtered the errors out. (you can enable/disable the...
October 6, 2010 at 7:47 am
I have used the following book and it is quite comprehensive:
Professional MS SQL Server 2008 Integrations Services from Wrox. (one of the authors is Brian Knight)
October 6, 2010 at 7:45 am
Great question! Definately learned something today.
October 6, 2010 at 12:27 am
_rmullen_ (10/5/2010)
But if the tools in SSIS behave so poorly..why are they there? Are they meant for small datasets?
Well, that statement is largely incorrect. Some components of SSIS behave poorly....
October 6, 2010 at 12:22 am
Jason Coleman (10/5/2010)
Does the SQL Server Agent account has the necessary privileges to access the Excel file?
Sounds like this might be the cause....how can I check this though?
Thx
Check the...
October 5, 2010 at 4:16 am
Well, you can't. At least not with out-of-the-box SSIS.
There are possibly some commercial add-ins that let you achieve this task.
So basically, you are stuck with scripting. Either in a Script...
October 5, 2010 at 1:31 am
Good question!
At the time of writing, only 34% have the right answer. So it is a good question indeed to refreshen some concepts about clustered index.
Another great resource is this...
October 5, 2010 at 1:27 am
_rmullen_ (10/4/2010)
So join/linked server would (and do) work...any reason *not* to use the lookup in SSIS with a cache connection manager?
Reasons why I normally don't use the lookup component:
* sensitivity...
October 5, 2010 at 1:16 am
Viewing 15 posts - 11,041 through 11,055 (of 11,678 total)