Yep yep, my bad. Skimmed the first post. Only came on here because I...

And that's what comes from skimming the first post and not reading the thread. . .

Simple...

SELECT GETUTCDATE()

select count (codaux) from

(select codaux,nomaux from aqua.softland.cwtauxi

except

select codaux,nomaux from 0718.softland.cwtauxi)

Do you understand?

Ask your DBA.

Please read this link --> http://www.sqlservercentral.com/articles/Best+Practices/61537/

to see how to post a question that people will want to help you with. I doubt anyone will want to take the time...

Is the problem already in the XML files?

I believe the problem is to do with XML serialization/de-serialization in .NET

DECLARE @table AS TABLE(Id INT, Product CHAR(5), TT INT, Week CHAR(2))

INSERT INTO @table

SELECT 1, 'Test1', 75, '1'

UNION ALL SELECT 2, 'Test2', 20, '1'

UNION ALL SELECT 3, 'Test1', 60, '2'

UNION ALL...

If there's no relationship then how do you know whether or not you have correct results? You could just merge the tables, but you can't g/tee the results.

What's the relationship between the two tables?

Homework? Interview questions?

Best bet is BOL, then come back if you have specific questions.

See this post, I think it answers your question

Thanks. I've spent some time looking at the Subscriptions table and written an ugly little replace statement to get out all of the relevant information from the extensionsettings and...

Yes, I got what you meant. What I mean is; you need to change the expression that generates the filename to a variable, then add a new script task that...