Viewing 15 posts - 1,006 through 1,020 (of 11,678 total)
I would simply put an Execute SQL Task after the data flow that will update the source tabel with an UPDATE statement.
Make sure to use an OnSuccess precedence constraint (the...
February 19, 2015 at 9:50 am
It's a bit like a Gantt chart, but with multiple events at one row.
Someone had a similar question like you, and it seems he found the answer:
https://ask.sqlservercentral.com/questions/95761/gantt-range-chart-with-multiple-events-per-row.html
February 19, 2015 at 6:36 am
Open the source, go to columns and deselect all columns. Select them again.
Go to the destination, open it and click OK.
This should have refreshed all metadata.
February 18, 2015 at 1:49 pm
What is your logic when there are ties?
For example, you have two records for Smith. It looks like the row number is assigned from the lowest score to the highest...
February 18, 2015 at 1:48 pm
Very interesting question, thanks!
February 18, 2015 at 3:43 am
Steve Jones - SSC Editor (2/17/2015)
TomThomson (2/15/2015)
But how much of the data does an individual DBA need to see? ...
Very good points, Tom, and I mostly agree in principle....
February 18, 2015 at 1:34 am
It's possible to handle type 2 SCD with the MERGE statement.
I describe it here:
Four Methods for Implementing a Slowly Changing Dimension in Integration Services – Part II[/url]
February 17, 2015 at 2:06 am
Please do not crosspost. It wastes peoples time and fragment replies.
Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1660788-2799-1.aspx
February 17, 2015 at 1:27 am
Apparently the source failed validation.
Aren't there more error messages?
Did the metadata of the excel file change?
February 17, 2015 at 1:26 am
Why would it do an update and the insert at the same time (for a specific row).
In a MERGE statement, a row either matches or it doesn't match. It cannot...
February 17, 2015 at 1:24 am
Emil Bialobrzeski (2/16/2015)
In the article you've provided there is one thing i believe is missing, I couldn't find the step that would actually change...
February 16, 2015 at 5:40 am
If you open the package in a text editor, you can take a look at the DTS:LastModifiedProductVersion property.
For SSIS 2012, this is for example 11.0.3360.12, for SSIS 2014 12.0.2299.1.
February 16, 2015 at 2:42 am
How is your package scheduled/executed?
If you use SQL Server Agent, it's not the service account of SQL Server that is used, but the service account of Agent.
February 16, 2015 at 2:39 am
I guess you could loop over your 3 drives in the .NET code.
Maybe encapsulate the code of the previous solution in a function and use the folder location as a...
February 16, 2015 at 2:37 am
Viewing 15 posts - 1,006 through 1,020 (of 11,678 total)