I did declare the variable?

DECLARE @SQLQuery NVARCHAR(255)

The problem is that I need to store the results of @i in a variable.

I tried:

SET @SQLRowCount = @i

It is NULL but how do I capture the SQL Count...

Post removed.

Post removed.

Post removed.

I created the destination by a SELECT INTO Destination Table FROM the Source Table

WHERE 1 = 2

It had NOT NULL Constraints in the destination and that was the issue.

Thank...

I removed the WHERE Clause that included the input parameter and I still get the error.

When the Task executes the parameter does not have a value.

I did not mean to...

The variables are set during runtime.

I checked the variables when I executed...

The OLE DB Source which contain the Select with a paramater in my OP and the Destination task faile and I'm getting the following errors:

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED....

It is running on Windows Server 2008 R2 which has tightened up security..

I setup another machine last weekend running the same OS and no problem,

Thanks Lowell, I tried that but I did not see any differences other than The descriptions that I used.

For some reason I do not have access to the machine.config file.

I...

post removed.

Lynn Pettis (4/9/2012)

---

Books Online is your friend. It can answer many of your basic questions faster than posting on ssc. If still confused, then ssc is a good...

In addition to some routine tasks, today I created Insert_Date (with constraint), Update_Date and Record_Type (DML Operation) for 69 Tables.

I also created Indexes on the Date Columns.

My thought process...

I'm trying to...