Nope nothing else could be done in that case.

Good luck

There is no special name for it. It's just another way of writing a join condition.

KoldCoffee (5/18/2014)

---

Just wondering why this SELECT TOP subquery works in the below sql query, when it doesn't have a FROM clause. What are keywords I can search to learn more...

I would say no. It is just DETA afterall. The usual precautions still apply - proceed with extreme caution and know your data.

What Gail said is spot on.

If you want to see it in tsql, here is something that will work.

WITH compatversions AS (

SELECT 65 AS MajorVersion ,'SQL Server 6.5' AS ServerVersion

UNION

SELECT...

Grant Fritchey (5/16/2014)

---

To address the scan, you need to either have a filter of some kind to reduce the amount of data, or fix the conversion so that the optimizer...

See if this article will be of any help.

http://bisherryli.com/2011/03/06/ssis-pass-a-variable-to-a-ole-db-source-in-a-data-flow/

The database diagram tool is a lightweight data modeling tool. At least until you have a diagram created that matches your schema.

If you are trying to get a feel...

What exactly are you trying to do with these 400+ tables through SSIS in a looping manner?

So back to the original questions.

What kind of data flow task? The data flow is essentially just a container for different kinds of tasks. So what kind of...

K. FWIW - A script task is not a DF task.

Inside the script task, you need to add your variable to...

What kind of DF task?

Is your DF inside the foreach containter?

As Louis said, do a select len(whateveryourcolumnis) for all of the columns and find which one has lengths that are beyond your target table definitions.

Having a staging table with data...

Fun times

Allies