Viewing 15 posts - 1 through 15 (of 31 total)
Good suggestions, Shawn, but the program does work. It works when I run the package in debug and it works when I execute the package under DTSEXEC. It...
July 14, 2014 at 1:16 pm
Yes, the package was developed in SSIS 2005. Yes, the package that executes the process task was updated to SSIS 2012 through the wizard. Yes, I have no...
July 14, 2014 at 11:56 am
Hey Phil, you're right. This is much ado about nothing.
My mistake was trying to directly change the connection string in the properties window of an existing connection. Knowing...
June 27, 2014 at 7:21 am
I may have answered my own question.
I took the package from the Sql Server 2005 server, copied it to the Sql Server 2012 server, ran it through the update wizard,...
June 26, 2014 at 3:09 pm
You said it, Sean. I'm going to get out my whoopbutt stick when I find out who coded something like "Select * into..."
Jason, it's a mix of adhoc and...
August 16, 2013 at 7:32 am
Good advice, Jeff. Thanks.
May 30, 2013 at 7:06 am
No, I haven't done anything to avoid them being used in the database. I've just said most of them dealing with this issue.
May 30, 2013 at 6:54 am
Sorry, above response posted twice due by mistake.
May 29, 2013 at 1:15 pm
Okay, the need for all this is:
A process inserts a parent row, then takes the identity value and puts it as the first 4 characters as part of a longer...
May 29, 2013 at 1:11 pm
Jeff, I work with what I'm given. And I've probably covered all the possible swear words just thinking of the best way to handle what I'm given.
May 29, 2013 at 12:10 pm
Sure. I'm looking at base 36 right now.
The base 36 representation of decimal 1,679,615 (which I assume is the highest value I can use) would be ZZZZ. I...
May 29, 2013 at 12:09 pm
Phil, I thought I had already tried that but apparently I didn't (or didn't do it correctly). I changed the connection string name from "My Connection String Name" to...
May 2, 2013 at 9:20 am
Well, it was worth a shot Malleswarareddy but, unfortunately, that didn't work. I just get this error:
Option "/CONNECTION=MY" is not valid. Process Exit Code 6. The...
May 1, 2013 at 12:56 pm
Thanks Phil,
In my case, this will always be a positive decimal. But you made a good point.
February 19, 2013 at 9:07 am
Awesome! That works!
I was already using Floor to pull out the integer part of the decimal. It didn't occur to me to use floor to subtract the...
February 19, 2013 at 9:05 am
Viewing 15 posts - 1 through 15 (of 31 total)