Viewing 15 posts - 1 through 15 (of 18 total)
March 20, 2017 at 10:33 am
Not a magic tool to do the job, but sounds like something you could maybe knock up pretty quickly in PowerShell.
June 28, 2013 at 9:13 am
Any spaces available? Love me a bit of fantasy football!
June 25, 2013 at 2:28 am
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...
March 6, 2013 at 4:38 am
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...
March 5, 2013 at 2:30 am
I usually add the whole project or solution folder, but set SVN to ignore the .suo and .user files and the /bin folder.
July 4, 2012 at 2:56 am
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...
July 2, 2012 at 5:20 am
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...
July 2, 2012 at 4:03 am
Erik Kutzler (12/10/2008)
Modify the flat file source in the Connection Manager in your SSIS package. Tell it to use a double quote as the text qualifier.
That appears to...
December 10, 2008 at 9:11 am
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...
December 10, 2008 at 8:47 am
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...
December 4, 2008 at 7:49 am
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.
December 4, 2008 at 3:13 am
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,...
December 4, 2008 at 2:42 am
Try this...
select
case
when Code= 'V918899' or Code IS NULL then '5K5'
else Code
end
from YourTable
December 3, 2008 at 4:12 am
Viewing 15 posts - 1 through 15 (of 18 total)