Viewing 15 posts - 1 through 15 (of 143 total)
Data view helped, I never tried to get it going before. It's actually occuring on the data source. The file definition had char(15) for it and was set to ignore...
August 19, 2020 at 7:22 pm
Instead of truncating and inserting as truncated, I want it to redirect row to the error output file.
It's not clear why it's truncating.
August 19, 2020 at 5:35 pm
Thanks, it looks like bids was missing, so I have unistalled and reinstalled.
At least I can add the dtsx now. I will resume next week.
January 24, 2020 at 9:21 pm
Sorry, I don't see SSIS Package node underneath projects (see above image). Maybe something is not installed? Yet, I have SSIS on the menu when I open a .dtsx and...
January 24, 2020 at 4:40 pm
Please bear with me. I've never had to create a project in the 23 years I've worked with SSIS. I created a SQL Server project and add my .dtsx and...
January 24, 2020 at 3:56 pm
I've looked all over for the project / package props and cannot find it. This was originally created with SSIS Export from SQL 2008R2.
Right mouse shows nothing...
January 24, 2020 at 3:16 pm
I wonder if companies are starting to think that we are all brains and that we should just google search our way out of problems. Hey, google knows everything (or...
January 8, 2020 at 12:53 pm
Ahh, yes the table does have a full text definition. It's just not finding A00J010002158. If I do like '%A00J010002158', it finds it. But that is very slow.
July 22, 2019 at 3:13 pm
January 24, 2018 at 4:12 am
January 23, 2018 at 2:17 pm
I started hacking up the sp and found at the beginning there are a couple of checks to verify there's valid data in the spreadsheet and it stops processing if...
February 15, 2017 at 11:47 am
That's a linked server to an Excel Spreadsheet.
December 1, 2016 at 1:17 pm
I have updated to add table alias and changed table alias on OUTPUT and gone with a real table instead of temp table:
UPDATE company SET
WHEN [F51] < GETDATE()...
December 1, 2016 at 1:16 pm
Here's an example: I built a FoxPro database queue solution to update a telephone switch. There was a FoxPro communication library that was able to connect to it....
February 3, 2016 at 8:49 am
I took my 10th trip (I had been going since the 1970s) to the UK from the US. Instead of just staying in London and doing day trips to...
July 25, 2014 at 6:47 am