Brandie,

Still working on the basic flow. Regarding the data scriub, once you have done everything possible programmatically, questionable and bad matches should go to an error report and back...

Manie,

If you create new numbers for the company being merged, do you keep a cross-reference table so you can map the old numbers to new? You still need to...

Matt, You're being modest!

😎

Manie,

Your code >>

select @nextinvoice = [next invoice number] from company

update company set [next invoice number] = isnull([next invoice number],0)+1

How I would change it >>

update dbo.company set

[next...

I also have to agree with Matt. But back to my last post, getting an idea of the data flow with perfect data should also help identify how things...

I'm still working through what you are trying to accomplish, but to give you an idea of how I am approaching this I thought I should make a quick post.

I...

I added a second MSDB entry to your file. You will need to edit it as appropriate. After replacing this and restarting IS, when you attach IS to...

We have a development server running two instances of SQL Server 2005, a default instance and a named instance. I just modified the MsDtsSrvr.ini.xml file to show the msdb...

I actually like case sensitive collations. Forces accuracy in your scripts. Column names in system views in SQL Server 2005 are all lower case, so that's how I...

Matt, Online? Which one?

😎

I liked the D&D reference too (played it a lot in my younger days!)

😎

Matt,

I'll look at it. I found another link to MSDN (haven't the foggest how, but did it through BOL somehow) that may also help.

Lynn

😎

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...