Yes, the join fields must be the same data type and the data sets must be in the same sort order, so you may have to do some sorting.

This component:

http://www.sqlbi.com/Projects/FlowSync/tabid/76/language/en-US/Default.aspx

Will...

Data type.

Try this:

SELECT FLOOR(-0.25), FLOOR(-1/4), FLOOR(-1/4.0)

-1/4 is integer/integer which gets rounded to an integer.

SSIS comparisons are very data-type sensitive as well as case and accent sensitive. They are also sensitive to trailing spaces. You will often have to TRIM/RTRIM and UPPER...

Actually, in step "7", you need to include the second table's ID and then use a conditional split afterwards to exclude records that do not have a NULL ID.

It was me that prompted you to post again, so I hope you get some additional feedback, but I will give you some detail here.

First question - yup, the LEFT,...

I don't think I would take that approach, I would be more comfortable modifying things through the web services, but I think your approach should work.

After you made your update,...

You are trying to get the table your OLEDB Destination is writing to into a variable? Are you selecting a table in the component editor to choose the table?

I...

My thoughts exactly - for performance it will probably be impossible to distinguish the two. However, you should not use FLOAT for financial values unless you are directing rounding...

If you don't trust what your vendor is telling you, get a new vendor.

I would assume they are correct - they have probably sold these before. Most SAN's will...

Yes, that is it, you need to manage security so you have only a few sysadmin users.

Also, you cannot restore over a database that has active connections, so if you...

I have to believe you have mis-diagnosed your performance problem.

I do not even think it is possible to see any performance degredation because there is too much in the plan...

Using a MERGE JOIN, you would have to include the columns you intend to join on. With a stored procedure, you may not need these columns, but they are...

I don't think you can, but you may want to look into the available options on the connection string. Create a .udl file, open it, and look at the...

1) Why is it creating an interim table? Is that to temporarily hold the output from the main query before it can be input to the Excel file?

There...

Sorry, not much else to say. It will not work. Management studio uses the Native SQL Client and non-ANSI standard stored procedures.

There are some 3rd party tools that...