Viewing 15 posts - 1 through 15 (of 3,232 total)
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...
November 16, 2017 at 1:31 pm
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...
November 9, 2017 at 12:04 pm
Thanks Lowell, I'll check that tonight as well. I should have brought my laptop with me today!
May 8, 2017 at 12:11 pm
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...
May 8, 2017 at 11:50 am
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...
January 3, 2017 at 7:22 am
reported as spam
December 30, 2016 at 10:58 am
December 30, 2016 at 10:56 am
You don't need the replace function here. Simply set the Description value to your desired value (in this case, accountID + description)
set [Description] = t.accountid...
December 9, 2016 at 7:30 am
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...
December 8, 2016 at 11:36 am
Time to start looking...
December 8, 2016 at 8:53 am
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...
December 1, 2016 at 12:15 pm
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...
December 1, 2016 at 12:09 pm
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...
November 23, 2016 at 10:32 am
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...
November 21, 2016 at 7:35 am
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...
November 21, 2016 at 7:23 am