Collation affects the way that data is compared and sorted, not how it is stored. As long as you are using a unicode datatype then you should be able to...

try this

SELECT @@SERVERNAME

conditional split is fairly easy, attach the input data flow from your look-up transformation.

open up the properties of the split, in the condition box add the condition ...

yes you can

SELECT REPLACE('YourString',',','.')

In the look-up transformation.

select the destination table , and the columns tab join the input columns to the destination table based upon your primary key(s).

Then add this primary key column...

500,000 rows is not a huge number in SQL by any means, and I am sure that you could get quicker results from your query. Though this does depend on...

In SSMS right-click on the database diagram node, and this will create one for you.

What you need to do, is add a lookup transformation that will check against the destination table and use this to check whether the value exists already,

If it...

there are databases linked here that are in various stages on corruption.

http://sqlskills.com/BLOGS/PAUL/category/Corruption.aspx

or Upgrade to 2008 and use the FILESTREAM datatype..

I have had the situation when SQL thought the tools were installed but they weren't so it sounds similar to the problem that you are having. Maybe a...

The advantage of having a witness is that it enables automatic fail-over

You just need to run the setup form cd/image and select client tools from the options

Do these date-time values mean anything? what are your rules for converting a...

abhishek.sahoo (1/20/2009)

---

I am not sure whether we can use sys index to retrieve data from a linked server. The T-SQL you have provided works fine if the table is in...