[p]Or may I know how to pass value to a package level variable in SSIS Agent job..?

Any suggestions please..[/p]

Please check these links might solve your issue:

http://msdn.microsoft.com/en-us/library/ms141704%28SQL.90%29.aspx

http://technet.microsoft.com/en-us/library/cc721270%28SQL.100%29.aspx

[p]I don't think so it is possible. The better way is to remove header and footer. :unsure:[/p]

[p]Any suggestions please.. :pinch:[/p]

Create package level variables and pass those values across all tasks in the same package.

If possible please attach screen shots.

You can change Compatibility Level in SQL Server 2005 by right clicking your database -> Properties -> Options -> Compatibility Level.

As u said u just installed ...u can remoe and install again that the better way..

IF u have any data or changes..take backup of all database and do the above...

Good question.. Thanks

Yes, it is good question but where and how we can use this? Anybody can explain with an example?

Really interesting and good question. :Wow:

Replaced with "User::sourceTable" and tried, but again the old value only it is taking.

Now I removed "sourceTable" value from Variables window.

Got error saying Incorrect syntax near 'FROM' ...

I given just like sourceTable in the ReadWrite variables list for the script task.

And I used MsgBox to know the value like:

MsgBox(Dts.Variables("sourceTable").Value.ToString())

Yes, it is package level variable. But it is resetting to old value i.e.: "SE_DatabaseServer".

What type of connection you are using in connection manager?