Viewing 15 posts - 1 through 15 (of 144 total)
I switched to just Open with all the parameters and it's working now.
December 3, 2020 at 1:19 pm
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.
Thanks.
August 19, 2020 at 5:35 pm
Thanks, it looks like bids was missing, so I have unistalled and reinstalled.
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15
At least I can add the dtsx now. I will resume next week.
Thanks!
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 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
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
active =
CASE
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
Viewing 15 posts - 1 through 15 (of 144 total)