Viewing 15 posts - 1,096 through 1,110 (of 1,192 total)
Hi Unnati,
If I'm reading that right you want
We have not received a payment for your loan account. this is debt collecor.
We have received a payment for your loan account.this...
February 3, 2012 at 1:16 pm
Well it is an undocumented & unsupported proc 😀
February 3, 2012 at 10:02 am
I'd recommend the second approach.
Use sp_rename for changing the names once done?
February 2, 2012 at 10:41 am
Hi bobba,
What error do you get? Are you connecting to machinename\sqlexpress rather than just machinename?
Cheers
Gaz
February 2, 2012 at 7:48 am
Koen Verbeeck (2/2/2012)
I especially left out this option because creating custom components/tasks for SSIS is much easier than asking the DBA's to create a simple stored procedure. 😀
Undoubtedly 😀
February 2, 2012 at 7:31 am
Ah, thanks Phil, I didn't know that.
Although if you're doing all that, I wonder why SSIS would be used at all in this case.
Surely at that point SSIS has basically...
February 2, 2012 at 6:52 am
There's no such thing as reusable functions in SSIS (edit: not true! - thanks Phil) so if you do use it you will have to create multiple tasks containing the...
February 2, 2012 at 6:23 am
Gary Varga (2/2/2012)
AKA would work...never get past a committee though!!!
Let's spike their punch! 😀
February 2, 2012 at 5:48 am
John Mitchell-245523 (2/2/2012)
Then you have two options:(1) Get all the data into a staging table and update it with an Execute SQL task
(2) Use my original suggestion.
John
(3) Don't use SSIS?
February 2, 2012 at 5:37 am
Gary Varga (2/2/2012)
I totally understand that. Following reading the article, if I was part of designing the SQL as a new language then with the old 20:20 hindsight I would...
February 2, 2012 at 5:27 am
I use AS on column aliases but nothing on table aliases, might need to sort that out!
Can't see me switching to = on columns, although I can see the point...
February 2, 2012 at 5:21 am
Cheers Steve, I was looking for the trap too!
I love this feature, actually currently writing lots of them for a data migration project.
February 2, 2012 at 4:30 am
Thanks David, great article - 5 stars!
Our Devs here are using nHibernate for a new project so I'll be keeping an eye on this.
I agreed to it with the proviso...
January 31, 2012 at 5:39 am
Viewing 15 posts - 1,096 through 1,110 (of 1,192 total)