Viewing 15 posts - 2,686 through 2,700 (of 4,820 total)
I know it would be a fair amount of work, but you could create an SSIS package that could transform the code page on the file (you may need to...
March 29, 2017 at 12:41 pm
| account_id | event_time | sign | |
|---|---|---|---|
| 1 | 2251 | 28.03.2017 19:00:04 | YES |
| 2 | 2251 | 28.03.2017 19:00:04 | YES |
| 3 | 2251 | 28.03.2017 19:00:04 | YES |
| 4 | 2250 | 28.03.2017 15:45:11 | NO |
| 5 | 2250 | 28.03.2017 15:45:11 | NO |
| 6 | 2250 | 28.03.2017... |
March 29, 2017 at 12:29 pm
SET @Begin_Period = 201712;
SET @Last_Period = CASE WHEN @Begin_Period...
March 29, 2017 at 12:18 pm
March 29, 2017 at 12:12 pm
March 29, 2017 at 12:03 pm
March 29, 2017 at 11:16 am
We are about to deploy a third party SSIS DWH project which contains over...
March 29, 2017 at 10:42 am
table...
March 29, 2017 at 10:27 am
Chris and Scott,
Thanks for making me aware of those options. I learn something new every day...
March 28, 2017 at 2:15 pm
March 28, 2017 at 12:15 pm
March 28, 2017 at 12:10 pm
Hi Tim,
Thanks for the reply. The Error/Failure workflow attaches from the OLAP task to...
March 28, 2017 at 11:40 am
That's because every SELECT or INSERT or UPDATE affects @@ROWCOUNT. It's not a reliable tool when you have triggers involved.
March 28, 2017 at 11:29 am
The only way to do that is to detect what user is actually performing the update. If the application's connection to the database is a SQL user instead of a...
March 28, 2017 at 11:26 am
Okay... first order of business is to ensure you have a table that represents when a given person (I assume this is represented by PayRollID occupied each PositionID. Have you...
March 28, 2017 at 11:21 am
Viewing 15 posts - 2,686 through 2,700 (of 4,820 total)