Viewing 15 posts - 826 through 840 (of 844 total)
david.wright-948385 (7/15/2013)
belowery (7/12/2013)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
July 15, 2013 at 8:05 am
Here is what I've said in another post:
I've worked for the same place now for over 22 years and the philosophy here has always been your earned the vacation so...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
July 12, 2013 at 12:20 pm
I like that answer, thanks for sharing. I know some may find that logic hard to follow, at least some that I know. 🙂 We have always used...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 20, 2013 at 9:44 am
My process is set to move 3 files between DB2 and SQLserver. The first two run fine, smaller data, the third fails. These run one at a time...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 14, 2013 at 3:52 pm
We have two more servers for me to check this on, out INT and production. I set this job up on each and each ran without errors. There...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 9, 2013 at 3:34 pm
I was not able to see anything in the logs.
I opened my process in BIDS and I forced my destination connection to be the UAT server. The process ran...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 9, 2013 at 10:12 am
I've only been working with SSIS for about a year. So when you say "Try running the job manually from within the SSIS project." are you talking about...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 8, 2013 at 2:20 pm
I did over hear that the UAT server was running low on some space, could have been the tempdb.
Maybe that is what it is, since the smaller files...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 8, 2013 at 12:11 pm
The destination table is dropped and recreated before the data flow step. My process builds the table on DB2, then moves it to SQL. Then the next one...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 8, 2013 at 10:05 am
In my testing I am pulling the data from the same source DB2 table, but putting it to a different SQL server(DEV). I can run this process on DEV and...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 8, 2013 at 9:26 am
I've worked for the same place now for over 22 years and the philosophy here has always been your earned the vacation so you need to take it. They...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
April 26, 2013 at 7:45 am
My first thought would be to do the case statement shown earlier. This seems to be cleaner code if someone else has to look at it in the future....
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
April 24, 2013 at 7:26 am
Small correction to Scott's code, he has the STUFF for 4 characters, this will wipe out both slashes. You could use either one below to get 'MM/YY':
declare @enddate datetime
set...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 21, 2013 at 8:07 am
I've made assumptions that you may have more than one guest per room. I also assume that if you have one guest checking out today and one checking in...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 28, 2013 at 12:39 pm
I talked to my DBA and he said these are automatically updated. So it must be a permissions issue that is stopping you from seeing anything.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 29, 2012 at 12:41 pm
Viewing 15 posts - 826 through 840 (of 844 total)