Viewing 15 posts - 1 through 15 (of 43 total)
Thanks for the replies. I have to apologize, this query is from an OLTP system behind a very large healthcare application, it's very messy. I essentially got lost inside the...
February 3, 2020 at 7:02 pm
Thanks for the help, i'll take a look.
April 18, 2019 at 5:06 pm
I added the Derived Column Transformation and handled it that way. Seems to work now.
January 22, 2019 at 5:29 pm
Phil Parkin - Tuesday, December 4, 2018 1:37 PMDid you change the compatibility levels of the databases after restoring them?
We did,...
December 4, 2018 at 2:25 pm
Hello All -
Thanks again for all of your input, really helped. I modified the sample query provided by Frederico_Fonseca and it works perfectly. I now have a fully-functioning job...
June 5, 2018 at 1:55 am
Thanks for all of the replies.
The file is a fixed-width with the row delimiter being {cr}{lf}.
June 4, 2018 at 11:56 am
February 6, 2018 at 12:20 pm
Thanks Sue.
I highly suspect this issue has something to do with account permissions via Visual Studio however I can't be certain. I did create a new folder at...
February 1, 2018 at 10:58 am
That's correct, just simply replicating the vendor's data. I'm thinking that a restore would be best, most direct way, but i'm getting resistance. I would love to transform some of...
December 7, 2017 at 5:59 pm
Hey folks - anyone have any suggestions? I'm dead in the water here. I looked at the XML code behind the package and that looks okay, i've restarted...
August 19, 2016 at 1:25 pm
I didn't have a chance to get back to this until this evening. I've figured out the problem, and as I suspected, it was an easy one. In...
January 12, 2016 at 7:45 pm
Just an update, I tried removing the Powershell layer and just running the .exe file itself from SSIS, I get the following error:
[Execute Process Task] Error: In Executing "C:\MyFolder\my.exe" "2016-01-11...
January 11, 2016 at 9:57 pm
Orlando that worked, my export is running very fast and easy now. Thanks for the help, BCP is sort of new to me but I see the value.
December 7, 2015 at 11:12 am
Hello All,
Thanks for the replies. Excellent advice on posting questions, i'll take heed of that going forward.
You're correct about the whitespace character, I actually went back and handled...
August 17, 2015 at 10:51 am
Okay, so I kind of answered my own question here -
CASE WHEN LEN(Call_Transaction_ID) > 1 THEN call_transaction_ID ELSE -1 END
When I did a LEN(Call_Transaction_ID) on the field I get...
August 13, 2015 at 8:29 pm
Viewing 15 posts - 1 through 15 (of 43 total)