Viewing 15 posts - 4,531 through 4,545 (of 11,678 total)
PhilipC (10/14/2013)
Thank you. No real advantages for us in using Windows 12 over 2008 R2 really.
Ed of course forgot to mention the slick Metro user interface! :w00t: 😎
Reason enough to...
October 14, 2013 at 3:28 am
Please read the first article in my signature on how to post questions. 😉
It will give you more info on how to post table definitions, sample data etc.
October 14, 2013 at 3:20 am
nalini.kumari143 (10/14/2013)
As per my Client requirement That's y am asking is it possible in control level using with execute sql
Clients and their strange requests sometimes. :rolleyes:
You can do it in...
October 14, 2013 at 3:07 am
pavithrareddyc (10/14/2013)
I wanted to try using cursor. I know that performance is poor but still i want to implement the logic using cursor.
You can start by providing table DDL, sample...
October 14, 2013 at 3:06 am
sureshdk (10/14/2013)
In some environrment xp_cmdshell is disabled/removed because of the hardening purpose. So we may not use this, is there any alternate method?
Yes, use the options in SQL Server Agent...
October 14, 2013 at 2:35 am
Koen Verbeeck (10/14/2013)
nalini.kumari143 (10/14/2013)
Hi,is it possible to do this task on control flow level in ssis
No, you need a data flow.
Any reason you don't want a data flow? They...
October 14, 2013 at 2:30 am
nalini.kumari143 (10/14/2013)
I want to implement the SCD with row level log using CheckSum option in Execute Sql Task
My Source table : Emp_Source(EId ,EName,Sal,Deg,Staus) -- here staus is add/update/delete
My Destination...
October 14, 2013 at 2:30 am
Interesting point of view. I find it quite a hassle though to execute SSIS packages using the way you proposed. Validating a package to find out if it is 32-bit...
October 14, 2013 at 2:20 am
nalini.kumari143 (10/14/2013)
Hi,is it possible to do this task on control flow level in ssis
No, you need a data flow.
October 14, 2013 at 2:10 am
wendy elizabeth (10/12/2013)
October 14, 2013 at 1:00 am
TSQL is set-based, meaning, it's all or nothing in a transaction. If one row fails, the entire statement fails.
You can however achieve your requirements very easily in SSIS.
October 14, 2013 at 1:00 am
I guess those add-filled blogs are free of hosting charges, so they can linger in limbo for a long time.
October 11, 2013 at 7:35 am
Viewing 15 posts - 4,531 through 4,545 (of 11,678 total)