I'm still interested if you have a space.

Not a magic tool to do the job, but sounds like something you could maybe knock up pretty quickly in PowerShell.

Any spaces available? Love me a bit of fantasy football!

I'd say it would depend on your experience. I've been using T-SQL for over 10 years and passed the exam in January using mainly that book. I used it to...

I can understand your nerves regarding this new role, but it sounds like a great opportunity for you. You're going to get exposure to a lot of aspects of SQL...

I usually add the whole project or solution folder, but set SVN to ignore the .suo and .user files and the /bin folder.

Can you confirm you're mapping the correct column to your destination? If you're not replacing the existing column in the Derived Column transform, can you check that the new column...

Hi, what do you mean by SSIS is not resolving it? Are you getting an error, or output that you do not expect? Can you show us some sample input...

That appears to...

I'm not certain that it's not something else causing the error, but I've narrowed it down to the quotes so far. Every one of the rows in the error...

You could put the first part, the select statement without the into, in a SQL or OleDb Source in a Data Flow, creating a dataset that you can then pass...

Ah yes. You'll need to join the inserted table to the source table, otherwise the insert will try to insert all rows from the table to the destination.

I think you should be using the "inserted" table rather than referencing the table itself. So your insert statement would be more like this:

INSERT INTO DBntext2.dbo.Destination (Id, Title,...

Try this...

select

case

when Code= 'V918899' or Code IS NULL then '5K5'

else Code

end

from YourTable