Another question in addition to Phil's...will your target table be updated by anything outside of this process?  For example, will other processes or a users be able to update this...

Use the Data Import Wizard.  Set it up to read from your flat file with the correct delimiter, then on the Advanced tab, press the 'Suggest Types' button.  This will...

Thanks Lowell, I'll check that tonight as well.  I should have brought my laptop with me today!

I'll have to go back and check on the .NET framework.  It's a Windows 10 laptop, 64-bit.  I'm pretty sure I've got the right .NET framework as I'm running Visual...

Sounds like a package with two data flows. In your first data flow, load the master table. In the second data flow, load the child data, but look...

reported as spam

reported as spam

You don't need the replace function here. Simply set the Description value to your desired value (in this case, accountID + description)

update c

set [Description] = t.accountid...

huh, I'm in downtown Fort Worth! Looks like we're almost neighbors. Do you want to do DBA work, web development, etc? There are technical recruiting firms here...

Time to start looking...

I would recommend going with straight up Package parameters to set these. If you are on 2012 and greater, consider using SSIS environments. Here's a walk-through. I...

I assume this is from Integration Services? If so, use a data flow to put the query results in a file (with your format of choice) and then use...

Guessing that the DTS.Runtime library is referencing the local SSIS instance. Not sure how you'd point that to another catalog. You may check the class properties to see...

Consider changing your design. I prefer to not persist this type of value in my data. A view would be a great way to expose the 'IsActive' value...

In addition to what Phil gave you for question #1, you say you want an easy user interface for execution packages? What about SQL Agent? Why not set...