Hi,

Well this is how I'd do it:

;WITH x AS(

SELECT [From Number], [Usage Date], ConnectTime, endTime, overlap,

ROW_NUMBER() OVER(ORDER BY [From Number]) Id

FROM VerizonDetailsFinal

)

UPDATE x1

SET overlap = 1

FROM x...

Hi,

I guess what's been missing from the help so far is using dynamic sql and assigning output to a variable at the same time.

Assuming you're assigning the max id value...

Hi,

Need to know the error message you're getting. Could be you just need to set the dateformat:

SET DATEFORMAT dmy;

Doh!

This now looks like a desktop issue. I tried using the dev server itself to create the package and everything runs smoothly from there. The server was using .NET framework...

The destination column in the target table is nvarchar. I can't see anywhere else to define the type other that in the DataReader Source where changes have had no positive...

Hmmm, guess everyone's on holiday.

I realised that I can view the tables, views and can query them using Server Explorer in VS. However I still have problems actually extracting the...

It's something called ePEX by these people: http://www.ascribe.com. Of course, it's old and on the way out. The ODBC driver is called Protechnic PHC. I think the issues...

Aha! Now I've worked out what's what here. DATABASEPROPERTYEX was running locally and so only gives results for databases on the remote server that happen to have the same names...

Sorry, am I thick? Linked Server Authentication? What was the answer - it's not at all clear

This was shaping to be a magnificent series, but is part 3 on the way? I really hope so.

The import routines we use for our crm system all use cursors...