You can add a Lookup transformation to your dataflow. Lookup the incoming rows in the database based on whatever makes them unique. Only insert to the database those...

Note: The date datatype can hold dates from Jan 1 of year 1 thru Dec 31, 9999. The datetime datatype can only hold dates from Jan 1, 1753 thru...

This is a little OT but here goes! I'm learning F# and among...

maybe you should post screenshots of what you want and what you get. There may be a way to make it work. Note however, that SSRS to Excel...

be sure your source and target tables are indexed on the key column

This worked for me:

declare @TargetTable table ([Key] char(8), SecurityID int)

declare @SourceTable table ([Key] char(8), SecurityID int)

insert into @TargetTable([Key]) values

('KKL43431'),

('KKLFK992'),

('KKL11011')

insert into @SourceTable([Key], SecurityID) values

('KKL43431',401),

('KKL43431',987),

('KKLFK992',533),

('KKL11011',123)

update t

set t.SecurityID = s.SecurityID

from @TargetTable t

join @SourceTable...

I took your sample code and ran it in a test database.

Then, I build a test report, defined a datasource for the test database and a dataset definition using it....

In spite of declaring that PKs and CIs are not the same, the author seems to conflate the two. Pretty much every table should have a CI -- hopefully...

OK -- I see why this is happening. When I created the config file, SSIS did not export the SQL login password, even though I told it to do...

Solved it:

Problem was the file connector thought it had the extra columns. I deleted them in the connection manager.

I think we need some help to understand what kind of help you need.

Have you tried plink from the makers of PuTTY? http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

You should be able to run the script on the linux machine like:

plink.exe -ssh -pw pass -noagent user@linux-server /path/to/your/script/make-live

You can schedule...

Bobby Russell (6/18/2014)

---

Fire the guy who added a cloud DB to the ONSITE server and give me my point back! The correct answer here is INCORRECT. This is an ONSITE...

Wrong! ...

My results were different. e.g.

USE MASTER

GO

SELECT SUBSTRING('NY', is_read_only + 1, 1)

, USER_NAME()

...