OK just out of curiosity

We have a similar scenario

A query that runs an inner join on a select statement on a linked server

If the linked server is unavoidable,what would...

ok in the end I added a copy file delete file step into the package

Tried that over the weekend,same result,the file could not be opened cause it's in use.

Txn,it was that simple

OK,that works thanks

Thank you for your answer,I guess it's not pratical to show that in one select so It might be better to split it up

=IIF(DateDiff("d",Parameters!bd.Value,Parameters!ed.Value) = 0,"3.75pt","0pt")

Will show the markers when only 1 day is selected

That would be a solution but what if the user selects to show all the data of the past 3 years,then the we wouldn't be able to see the graph...

Indeed cause the funny thing was this behavior in the program was only triggered when it ran/runs on schedule,when they manually ran the program it did not occur.

SO their were...

We found the issue apparently the program that was running the delete statements with that user reinserted the same records it just deleted.

Well its not a 'real' problem.

It's more me wondering why I should get truncation errors on colums while I'm expecting null values in that column & explicity said that the...

Phil Parkin (4/14/2014)

I mean are you redirecting error rows - have...

There no error message except for the validation error,cause that stops the execution of the rest of the package

yes I changed them both from string DT_STR to DT_WSTR & that leads to...

When trying to execute with the colums put on unicode, via advanced editor

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at Pull [Source [1]]: The output column "VNDNAM" (1294) on the...