Viewing 15 posts - 9,496 through 9,510 (of 13,874 total)
As you're new here, I have been generous and done some set-up coding for you. In future, please see the link in my signature for an excellent article on how...
December 9, 2013 at 1:10 am
spin (12/6/2013)
ok here's the completed solution, thanks to all who helped....
Nice work, well done.
December 6, 2013 at 3:41 am
Ells (12/5/2013)
I have tried a variety of destinations including just the root of C. I am convinced it is not the location:hehe:
I have in the past seen cases where there...
December 6, 2013 at 1:02 am
OK, so now your table is created and exists in the form you want - and you want to insert any new rows from source, or update those with new...
December 5, 2013 at 11:03 pm
Also, setting the default (design-time) value of the variable to be a valid query may help you get over this hurdle.
December 5, 2013 at 10:54 pm
At what point did you receive the error? (Run time or design time.)
Have you made any modifications to the DelayValidation property?
December 5, 2013 at 10:53 pm
If I assume that you could do this if you knew the names of the columns, the problem reduces to getting the names of the columns and then assembling them...
December 5, 2013 at 11:22 am
mohan11cbi (12/5/2013)
java.sql.SQLException: Warning: Fatal error 824 occurred at Dec 5 2013 10:11AM. Note the error and time, and contact your system administrator.
Is this a blog entry, or do...
December 5, 2013 at 2:49 am
stanteitelbaum (12/4/2013)
December 4, 2013 at 9:03 am
sqlnaive (12/4/2013)
Koen Verbeeck (12/4/2013)
twin.devil (12/4/2013)
SSIS Package extension is "dtsx" not "dstx".Nicely spotted 😀
Twin/Koen, It was a typo. It's infact dstx. I was just cleaning the official info from the logs....
December 4, 2013 at 8:59 am
abhas (12/4/2013)
Thanks twin,but again interrupting.
linked server is already defined and i am able to select records using the linked server. Facing issue with merge statement only.
please help.
thank you
Have you got...
December 4, 2013 at 8:50 am
abhas (12/4/2013)
Hi Phil,by comparing source and target hoe to update the target isdelete flag if record is deleted from source?
Thanks
abhas
You'd already written 99% of the required query:
MERGE dbo.tblcustomerTarget AS dd...
December 4, 2013 at 5:56 am
abhas (12/4/2013)
December 4, 2013 at 5:18 am
suchitra.venkataramani (12/4/2013)
I have created a package in ssis and i need to schedule it every week. How do i do that since i found out that there is no...
December 4, 2013 at 3:47 am
abhas (12/4/2013)
But in the target table there is one extra column ISdelete. If record is deleted from source then i need toset value of this column is D. If...
December 4, 2013 at 12:21 am
Viewing 15 posts - 9,496 through 9,510 (of 13,874 total)