I click on debug and nothing...

A false alarm perhaps It is validating each transformation now at a snails pace.:-D

Thanks for the all of ideas.:-)

I would have included the actual file but the table names are confidential.

I guess you know what I needed or you would not suggest that I use the splitter.

Have a...

The items listed are table names.

I need to remove the comma and replace it with a line feed to that each table appears on a separate row.

I got the same thing, what's up?

Lynn Pettis (4/16/2012)

---

Looking at this line:

SET@OpenQueryPrefix = @OpenQueryPrefix + ', ''SELECT COUNT(*) AS400TableCount FROM ' -- << and here

AS400TableCount is a column alias, I am naming the column that contains...

I reverted to you version of the code and it works.

What Line are you referring to because I do see an Table Alias?

I use them all of the time.

Thanks.

Lynn Pettis (4/16/2012)

---

The select count(*) in the openquery still has no alias and you are still doing a select * from the openquery and not assigning anything to the variable...

I changed my code slightly so I can remove when I convert it to a Stored Procedure but I get the same results:

SQLRowCount

5

00001

5

MyCount

NULL

SET @SQLQuery = 'SELECT @cnt = COUNT(*) FROM...

I'm sorry but I do not follow.

I do not have a column Alias in the SQL Select?

So the first part works, the SQL Server Count.

SET @SQLQuery = 'SELECT @cnt = COUNT(*) FROM ' + @SchemaName +'.'+ @SQLTableName

DECLARE @MyCnt INT;

DECLARE @SQLRowCount int

DECLARE @ParmDefinition nvarchar(500);

SET @ParmDefinition =...

Lynn,

It works, my vision must be failing me because I did not notice the difference?

Thanks!

I tried changing it slightly but I get a NULL When SELECTING on @MMyCount:

SET @SQLQuery = 'SELECT COUNT(*) FROM ' + @SchemaName +'.'+ @SQLTableName

DECLARE @MyCnt INT;

DECLARE @ParmDefinition nvarchar(500);

SET @ParmDefinition...

I tried the following which is obviously not it and a bunch of other tries"

EXEC sp_executesql

@query = @SQLQuery,

...