Viewing 15 posts - 1 through 15 (of 46 total)
I was about to write something similar, but Thom A beat me to it. In my case, both precedent constraints are "Logical OR, one constraint must evaluate to true" so...
June 8, 2021 at 4:09 pm
Have you set up an error path on your data flow? If I was debugging this, I'd start with that. If records are not flowing to your desired destination, they...
May 28, 2021 at 2:17 pm
Are there any unmapped columns in your OLE DB or ABO destination? If so, that might get you pointed in the right direction.
May 11, 2021 at 5:37 pm
Try setting your Windows date format in Regional Settings, I found that is affects how dates are presented in various applications. How to get there depends on your Windows version. ...
April 26, 2021 at 3:18 pm
When I encountered DTS_E_PRIMEOUTPUTFAILED errors (on SQL Server) , it generally had to do with the columns in the input flat file manager not matching the columns in the flat...
March 2, 2021 at 3:14 pm
February 4, 2021 at 8:34 pm
This is a wild stab, but have you updated VS recently? I had a similar experience a couple days ago, updated VS to 16.8.2, then 16.8.3, which was apparently released...
December 10, 2020 at 10:26 pm
Unless I misunderstand the question, you should be able to enclose your conditions in parens, e.g.:
I tested the expression below, using two booleans Var1 and Var2. It returns true if...
December 3, 2020 at 4:52 pm
I have found the Scripting Guy helpful over the years. Check out some of the links on the third paragraph on this page:
July 13, 2020 at 8:54 pm
I think I've seen this when one of the data rows has a different number of columns that the header row, or when the connection manager was created using a...
June 9, 2020 at 8:50 pm
I think the answer might depend on how many files you are processing in each run, if there are files in the same folder that you do not want to...
May 27, 2020 at 7:27 pm
It may the the Access Database Engine version. When I worked with SSIS/Excel, Visual Studio needed the 32 bit version, which was included with my 32 bit Office 2016 so...
May 8, 2020 at 10:31 pm
If I was experiencing this error, I would first try to create an input file with a single record that caused the error. Creating such a file can be a...
April 27, 2020 at 2:48 pm
For some imports, I use a text log file as transaction report, showing basic info about rows added or updated in the destination tables. Info about errors, like the subject...
April 22, 2020 at 4:30 pm
In my experience, this is a general purpose error that may hide the underlying error.
Looking back thru my notes, I once encountered this in a script task method the did...
April 22, 2020 at 1:27 pm
Viewing 15 posts - 1 through 15 (of 46 total)