I had the code backwards, thanks Chris for clearing that up.

what you are seeing here is the implicit conversion that takes place when comparing different data types.

so in this case an empty string ('') is implicity converted to a...

miriyalasrihari (9/5/2011)

---

i know some concepts of Microsoft SQL Server Analysis Services.

my Team Leader told me that - try on open source it'll help you in future that's way i am...

to get the anywhere near the sort of functionality that google has, then you will probably need to do some coding in an application langauge such as c# or Python...

you could try and use the SOUNDEX function in T-sql and do this without a loop/cursors

http://msdn.microsoft.com/en-us/library/ms187384.aspx

Yes you will also need an order by, ...

As you are running 2000, you are in luck as Redgate provide their log-reader for 2000 for free..

http://www.red-gate.com/products/dba/sql-log-rescue/

you could always search through the XML code of the dtsx package for the procedure name and this should also show you what task is calling the procedure

for me it would depend on whether or not this process is part of a larger ETL load and/or something that needs to be run regular, or whether is...

Do both connection managers use the same username and password?

because , from memory, a fast-load can require special permissions to run such as ALTER TABLE to keep...

I have also used them many times without any issues, what version of SSIS are we dealing with?

Get a copy of the Data warehouse lifecycle toolkit by the Kimball group and read this from cover to cover. It will give you a very good...

Another way of doing this without using CREATE TABLE is

SELECT 'A' as A into T3

this will create the table for you, if you need to specify the data type...

db2mo (7/29/2011)

---

There is an Export Wizard in SAS where I can export the file to a csv or txt file. How would I then take the csv file and...

As you mentioned that you worked...