Just thought of this, you may want to put the File System Task in a ForEach container using the file enumerator. That is how ours works. We have multiple...

Actually, once you read up on the File System Task, I think you'll find it very easy to use.

😎

I'd look at the File System Task. It can move a file easily and doesn't require all that code you have in the Script Task. We use the...

And then comes along a merger, and your unique OrderNo/CustomerNo/InvoiceNo whatever is no longer unique as you have to merger both companies data into a single database. It comes...

You mentioned pulling the data from both SQL Server and the mainframe, if the layout of the data from the mainframe the same as in SQL Server?

😎

More than one. You also have the variations on the name as well: John Smithe for example. Is it really Smithe or is it a typo and should...

Okay. And, tell me if I am wrong, this also leads to another potential problem in the data. I could be in there multiple times as Lynn Pettis,...

Quite simple really, I'd put an alternate index (unique) or a unique constraint on CountryName.

😎

majorbloodnock

Isn't the 19th century when psychiatry came into being with people like Freud?

😎

That looks like laziness on their part. They obviously didn't want to take the time to analyze the data that would be stored in the varchar fields so that...

Jeff,

It may not be your job to evaluate peoples code, but I personally take it as a great compliment when you have complimented me on my code. I'm sure...

Try this code. It is untested as you did not provide the DDL or any test data.

with TestDate (

PersonNumber,

EntryDate

) as (

select

...

Jack,

I didn't take it as a criticism. The more detailed the request, the more info provided about what has been tried, and what is expected, the more likely you...

Jack Corbett (2/26/2008)

Lynn Pettis (2/26/2008)

Jeff,

Thanks for the comment. ...

Jeff,

Thanks for the comment. Sometimes it isn't giving...